this syntax of study table and input value.
CREATE TABLE `study` ( `studyID` int(11) NOT NULL, `studyName` varchar(45) NOT NULL, PRIMARY KEY (`studyID`))
//////////////////////////////////////////////////////////////
INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1001', 'study A');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1002', 'study B');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1003', 'study C');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1004', 'study D');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1005', 'study E');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1006', 'study F');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1007', 'study G');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1008', 'study H');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1009', 'study I');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1010', 'study J');
Subscribe to:
Post Comments (Atom)
The study table and data have been added to the database. I did have to alter the create table and each insertion query to inclued the name of the database. I'm not sure if that is related to RazorSQL or not. Any suggestions as to if it is?
ReplyDeleteI do not know about RazorSQL because the syntax may change. this syntax is in Navicat Lite. when I wrote in MYSQL workbench 5.2 OS it was slightly different.
ReplyDelete