MySQL CREATE database, build table operation process

First, Create a database

Creare database superdatabase; Create a database superdatabase

Use Superdatabase; Use the database

With the above statement, you do not have to specify the database name used in each SQL statement. By default, MySQL will use the last specified database as the current database.

Drop database superdatabase; Delete Database superdatabase

Second, about user authorization

Third, the establishment of the table

Show tables; List current database table information

Describe table (table name); Display information for the corresponding table

For database case-sensitive issues, see the following address:

http://blog.163.com/pursue100%40yeah/blog/static/165732158201101641221182/

MySQL CREATE database, build table operation process