Differences

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

--- linux_wiki:perform_simple_sql_queries_against_a_database [2018/04/20 12:41]
billdozor [Lab Setup]
+++ linux_wiki:perform_simple_sql_queries_against_a_database [2019/05/25 23:50] (current)
@@ Line 52: / Line 52: @@
 \\
-Insert a new row/entry into a table
+Insert two new rows/entries into a table (two methods)
 <code bash>
-MariaDB [emails]> INSERT INTO users (userID,userFirstName,userLastName,userEmailAddress) VALUES (001,"Robert","Jones","robertjones@example.com");
+# Values method
+MariaDB [emails]> INSERT INTO users (userFirstName,userLastName,userEmailAddress) VALUES ("Robert","Jones","rjones@example.com");
+# Set method
+MariaDB [emails]> INSERT INTO users set userFirstName="Jane", userLastName="Smith", userEmailAddress="jsmith@example.com";
 </code>
@@ Line 76: / Line 80: @@
 \\
-Update the entry of Jane Smith to change her last name and email address
+Update the entry of Robert Jones to change the email address
 <code bash>
-MariaDB [emails]> UPDATE users SET userLastName="Jones",userEmailAddress="janejones@example.com" WHERE userID=2;
+MariaDB [emails]> UPDATE users SET userEmailAddress="robert.jones@example.com" WHERE userID=1;
 </code>
 ----