Differences

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

--- linux_wiki:create_a_simple_database_schema [2018/05/12 16:08]
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
   * Column Definitions
     * 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 -> The userid column is the primary sorting key
     * userFirstName char(25) -> Named userFirstName and of type characters up to 25 long
-    * PRIMARY KEY (userid) -> The userid column is the primary sorting key
   * Table Options
     * AUTO_INCREMENT = 100 -> Start userid at 100