· 7 years ago · Nov 08, 2018, 05:58 PM
1CREATE TABLE /* IF NOT EXISTS */ `tableName`(
2 `PersonID` int(11) NOT NULL AUTO_INCREMENT,
3 `LastName` varchar(255),
4 `FirstName` varchar(255),
5 `Address` varchar(255),
6 `City` varchar(255),
7 /* UNIQUE (ID), CONSTRAINT UC_Person UNIQUE (PersonID,LastName), */
8 /* FOREIGN KEY (PersonID) REFERENCES Persons(PersonID), */
9 PRIMARY KEY (PersonID)
10);