Differences

This shows you the differences between two versions of the page.

--- linux_wiki:create_a_simple_database_schema [2018/05/12 15:55]
billdozor [Create a Database]
+++ linux_wiki:create_a_simple_database_schema [2019/05/25 23:50] (current)
@@ Line 73: / Line 73: @@
 Create a new table in the emails database
 <code bash>
-MariaDB [emails]> CREATE TABLE users (userID INT AUTO_INCREMENT, userFirstName CHAR(50), userLastName CHAR(50), userEmailAddress CHAR(50), PRIMARY KEY (userid)) AUTO_INCREMENT = 100;
+MariaDB [emails]> CREATE TABLE users (userID INT AUTO_INCREMENT PRIMARY KEY, userFirstName CHAR(50), userLastName CHAR(50), userEmailAddress CHAR(50)) AUTO_INCREMENT = 100;
 </code>
   * When you create a table, you must define the names of the columns and the type of data they should contain
-  * userID INT -> Named userID and of type integer
+  * Column Definitions
-  * userFirstName char(25) -> Named userFirstName and of type characters up to 25 long
+    * userID INT -> Named userID and of type integer
-  * AUTO_INCREMENT -> Auto increment this field
+      * AUTO_INCREMENT -> Auto increment the entries in this column
-  * PRIMARY KEY (userid) -> The userid field is the primary sorting key
+      * PRIMARY KEY -> The userid column is the primary sorting key
-  * AUTO_INCREMENT = 100 -> Start userid at 100
+    * userFirstName char(25) -> Named userFirstName and of type characters up to 25 long
+  * Table Options
+    * AUTO_INCREMENT = 100 -> Start userid at 100
 \\