Differences

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

--- linux_wiki:perform_simple_sql_queries_against_a_database [2018/04/20 16:42]
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 52: / Line 52: @@
 \\
-Insert two new rows/entries into a table
+Insert two new rows/entries into a table (two methods)
 <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 (userID,userFirstName,userLastName,userEmailAddress) VALUES (002,"Jane","Smith","jsmith@example.com");
+# Set method
+MariaDB [emails]> INSERT INTO users set userID=002, userFirstName="Jane", userLastName="Smith", userEmailAddress="jsmith@example.com");
 </code>