Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
linux_wiki:create_a_simple_database_schema [2018/05/12 16:08] billdozor [Create a Database] |
linux_wiki:create_a_simple_database_schema [2018/05/12 16:08] billdozor [Create a Database] |
||
|---|---|---|---|
| Line 78: | Line 78: | ||
| * Column Definitions | * Column Definitions | ||
| * userID INT -> Named userID and of type integer | * userID INT -> Named userID and of type integer | ||
| - | * AUTO_INCREMENT -> Auto increment this field | + | * AUTO_INCREMENT -> Auto increment |
| * userFirstName char(25) -> Named userFirstName and of type characters up to 25 long | * userFirstName char(25) -> Named userFirstName and of type characters up to 25 long | ||
| - | * PRIMARY KEY (userid) -> The userid | + | * PRIMARY KEY (userid) -> The userid |
| * Table Options | * Table Options | ||
| * AUTO_INCREMENT = 100 -> Start userid at 100 | * AUTO_INCREMENT = 100 -> Start userid at 100 | ||