[[linux_wiki:create_a_simple_database_schema]]

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
linux_wiki:create_a_simple_database_schema [2018/05/12 20:08]
billdozor [Create a Database]
linux_wiki:create_a_simple_database_schema [2019/05/26 03:50] (current)
Line 73: Line 73:
 Create a new table in the emails database Create a new table in the emails database
 <code bash> <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>​ </​code>​
   * When you create a table, you must define the names of the columns and the type of data they should contain   * When you create a table, you must define the names of the columns and the type of data they should contain
Line 79: Line 79:
     * userID INT -> Named userID and of type integer     * userID INT -> Named userID and of type integer
       * AUTO_INCREMENT -> Auto increment the entries in this column       * 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     * 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   * Table Options
     * AUTO_INCREMENT = 100 -> Start userid at 100     * AUTO_INCREMENT = 100 -> Start userid at 100
  • linux_wiki/create_a_simple_database_schema.txt
  • Last modified: 2019/05/26 03:50
  • (external edit)