Differences

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

--- linux_wiki:perform_simple_sql_queries_against_a_database [2018/05/20 23:08]
billdozor [Basics of SQL: Add,Remove,Modify]
+++ linux_wiki:perform_simple_sql_queries_against_a_database [2018/05/20 23:08]
billdozor [Basics of SQL: Add,Remove,Modify]
@@ Line 55: / Line 55: @@
 <code bash>
 # Values method
-MariaDB [emails]> INSERT INTO users (userID,userFirstName,userLastName,userEmailAddress) VALUES (001,"Robert","Jones","rjones@example.com");
+MariaDB [emails]> INSERT INTO users (userFirstName,userLastName,userEmailAddress) VALUES ("Robert","Jones","rjones@example.com");
 # Set method
-MariaDB [emails]> INSERT INTO users set userID=002, userFirstName="Jane", userLastName="Smith", userEmailAddress="jsmith@example.com");
+MariaDB [emails]> INSERT INTO users set userFirstName="Jane", userLastName="Smith", userEmailAddress="jsmith@example.com");
 </code>