Birmingham mumbai

[
 340 
]
Now, let's go back to databases. Now that we've created the 
mysampledb
 database, 
what can we do with it? We'll add tables and rows, of course! A database is useless 
without actual data, so we can work through some examples of adding data to our 
database to see how this works. First, log in to the MariaDB shell as a user with full 
privileges to the 
mysampledb
 database. Now, we can have some fun and modify the 
contents. Here are some examples you can follow:
USE mysampledb;
The 
USE
 command allows us to select a database we want to work with. The MariaDB 
prompt will change from 
MariaDB [(none)]>
 to 
MariaDB [mysampledb]>
. This is very 
useful, as the MariaDB prompt changes to indicate which database we are currently 
working with. We basically just told 
MariaDB
 that for all of the commands we're 
about to execute, we would like them used against the 
mysampledb
 database.
Now, we can 
CREATE
 a table in our database. It doesn't matter what you call yours, 
since we're just practicing. I'll call mine 
Employees
:
CREATE TABLE Employees (Name char(15), Age int(3), Occupation 
char(15));
We can verify this command by showing the columns in the database, to ensure it 
shows what we expect:
SHOW COLUMNS IN Employees;
With this command, we've created a table named 
Employees
 that has three columns 
(
Name
, 
Age
, and 
Occupation
). To add new data to this table, we can use the following 
INSERT
 command:
INSERT INTO Employees VALUES ('Joe Smith', '26', 'Ninja');
The example 
INSERT
 command adds a new employee to our 
Employees
 table. When 
we use 
INSERT
, we insert all the data for each of the columns. Here, we have an 
employee named 
Joe
, who is 
26
 years old and whose occupation is a 
Ninja
. Feel 
free to add additional employees; all you would need to do is formulate additional 
INSERT
 statements and provide data for each of the three fields. When you're done, 
you can use the following command to show all of the data in this table:
SELECT * FROM Employees;

---

Chapter 13