Differences
This shows you the differences between two versions of the page.
Both sides previous 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 column is the primary sorting key | * PRIMARY KEY (userid) -> The userid column is the primary sorting key |