MySQL Database operations

1. Use the show statement to find out what database currently exists on the server:
Mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| MySQL |
| Test |
+----------+
3 Rows in Set (0.00 sec)

2. Create a database Abccs
mysql> CREATE DATABASE Abccs;
Note the sensitivity of the different operating systems to the case.

3. Select the database you created
Mysql> Use Abccs
Database changed
At this point you have entered the database Abccs you just created.

4, the display table of the knot structure:
Mysql>describe mytable;

5. Load data into a database table in text mode
Mysql>load DATA LOCAL INFILE "Mytable.txt" into TABLE pet;

MySQL Database operations