Differences

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

--- linux_wiki:create_a_simple_database_schema [2016/09/11 00:05]
billdozor created
+++ linux_wiki:create_a_simple_database_schema [2019/05/25 23:50] (current)
@@ Line 4: / Line 4: @@
 Creating a simple database in MariaDB.
+----
+====== Lab Setup ======
+The following virtual machines will be used:
+  * server2.example.com (192.168.1.151) -> Database here
+**Previous Section Completed**
+  * [[linux_wiki:install_and_configure_mariadb|Install and Configure MariaDB]]
 ----
@@ Line 63: / Line 73: @@
 Create a new table in the emails database
 <code bash>
-MariaDB [emails]> CREATE TABLE users (userID INT, userFirstName char(25), userLastName char(30), userEmailAddress char(50))
+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 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
+  * Table Options
+    * AUTO_INCREMENT = 100 -> Start userid at 100
 \\