====== Perform Simple SQL Queries Against A Database ======

**General Information**

Basic SQL commands.

----

====== Lab Setup ======

The following virtual machines will be used:
  * server2.example.com (192.168.1.151) -> Database here

**Previous Sections Completed**
  * [[linux_wiki:install_and_configure_mariadb|Install and Configure MariaDB]]
  * [[linux_wiki:create_a_simple_database_schema|Create a Simple Database Schema]]

----

====== Basics of SQL: Connect and Navigate ======

Connect to the database
<code bash>
mysql -u root -p
</code>

\\
Show databases on the system
<code bash>
MariaDB [(none)]> SHOW DATABASES;
</code>

\\
Use a specific database called 'emails'
<code bash>
MariaDB [(none)]> USE emails;
</code>

\\
Show the tables in the database, emails
<code bash>
MariaDB [emails]> SHOW TABLES;
</code>

\\
Show the fields available in a table called 'users'
<code bash>
MariaDB [emails]> DESCRIBE users;
</code>

====== Basics of SQL: Add,Remove,Modify ======

\\
Insert two new rows/entries into a table (two methods)
<code bash>
# 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>

\\
Show all entries from the users table
<code bash>
MariaDB [emails]> SELECT * FROM users;
</code>

\\
Show all entries from the users table where the last name equals "Smith"
<code bash>
MariaDB [emails]> SELECT * FROM users WHERE userLastName="Smith";
</code>

\\
Delete the entry where the user id is 2
<code bash>
MariaDB [emails]> DELETE FROM users WHERE userID=2;
</code>

\\
Update the entry of Robert Jones to change the email address
<code bash>
MariaDB [emails]> UPDATE users SET userEmailAddress="robert.jones@example.com" WHERE userID=1;
</code>

----