CREATE TABLE `persons` (

`PersonID` int(11) NOT NULL AUTO_INCREMENT,

`Title` varchar(45) DEFAULT NULL,

`FirstName` varchar(45) DEFAULT NULL,

`Lastame` varchar(45) DEFAULT NULL,

`MaidenName` varchar(45) DEFAULT NULL,

`OtherNames` varchar(100) DEFAULT NULL,

`NickName` varchar(45) DEFAULT NULL,

`Generation` varchar(12) DEFAULT NULL,

`NameSuffix` varchar(45) DEFAULT NULL,

`PreferredName` varchar(45) DEFAULT NULL,

`NamePronunciationNotes` varchar(45) DEFAULT NULL,

PRIMARY KEY (`PersonID`)

)



CREATE TABLE `persons` (`PersonID` int(11) NOT NULL AUTO_INCREMENT,`Title` varchar(45) DEFAULT NULL,`FirstName` varchar(45) DEFAULT NULL,`Lastame` varchar(45) DEFAULT NULL,`MaidenName` varchar(45) DEFAULT NULL,`OtherNames` varchar(100) DEFAULT NULL,`NickName` varchar(45) DEFAULT NULL,`Generation` varchar(12) DEFAULT NULL,`NameSuffix` varchar(45) DEFAULT NULL,`PreferredName` varchar(45) DEFAULT NULL,`NamePronunciationNotes` varchar(45) DEFAULT NULL,PRIMARY KEY (`PersonID`))









There are two ways to layout SQL insert statements:

The "compact" version lays things out horizontally...

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...) 

The "display" version lays things out vertically (easier to see the values...)

INSERT INTO table_name (
 column1, 
 column2, 
 column3,...)
VALUES (
 value1, 
 value2, 
 value3,...) 


For our practice database, the layouts would look like...

INSERT INTO `test`.`persons` (Title, FirstName, Lastame, MaidenName,  OtherNames, NickName, Generation, NameSuffix, PreferredName, NamePronunciationNotes) 
VALUES ("Prof.", "Cliff", "Missen", "", "", "Knucklehead", "II", "", "Cliff", "In French, it's 'Cleef'")

or...

INSERT INTO `test`.`persons`
(Title, 
FirstName, 
Lastame, 
MaidenName,  
OtherNames, 
NickName, 
Generation, 
NameSuffix, 
PreferredName, 
NamePronunciationNotes)
VALUES
("Prof.", 
"Cliff", 
"Missen", 
"", 
"", 
"Knucklehead", 
"II", 
"", 
"Cliff", 
"In French, it's 'Cleef'")




SELECT * FROM Persons