Create a mysql database, tables and insert data.

How do I create a MySQL database and tables?

If you want to create a database and set up tables for the same use the following two sql commands:

=> CREATE DATABASE - create the database


=> CREATE TABLE - create the table


=> INSERT - To add/insert data to table


CREATE DATABASE creates a database with the given name. To use this statement, you need the CREATE privilege for the database


CREATE TABLE creates a table with the given name. You must have the 


CREATE privilege for the table.


INSERT inserts new rows into an existing table.

Procedure for creating a database and a sample table

Login as the mysql root user to create database:$ mysql -u root -p


Output:

mysql>Add a database called books

mysql> CREATE DATABASE books;

Now database is created. Use a database with use command:

mysql> USE books;

Now create a table called authors with name, email and id:

mysql> CREATE TABLE authors (id INT, name VARCHAR(20), email VARCHAR(20)); 

Display your table name just created:

mysql> SHOW TABLES;

Output: 
+------------------------+
| Tables_in_books|
+------------------------+
| authors               |
+------------------------+

1 row in set (0.00 sec)

Now add a data / row to table books using INSERT statement:

mysql> INSERT INTO authors (id,name,email) VALUES(1,"Vivek","xuz@abc.com");


Output:

Query OK, 1 row affected (0.00 sec)

Add few more rows:

mysql> INSERT INTO authors (id,name,email) 


VALUES(2,"Priya","p@gmail.com");

INSERT INTO authors (id,name,email) VALUES(3,"Tom","tom@yahoo.com");
Now display all rows:

mysql> SELECT * FROM authors;

Output:

+------+-------+-------------------------+

| id   | name  | Email               |
+------+-------+-------------------------+

|    1 | Vivek |vkc@yahoo.com |
|    2 | Priya | perl@abcde.com |
|    3 | Tom   | tom@gmail.com |
+------+-------+--------------------------+

3 rows in set (0.00 sec)