10 statements for MySQL entry

1. Look under the current server, what are those libraries (database)?

Answer: show databases;

2. How can I create a database?

A: The database name is the last face of the create, and the semicolon ends

3. Select a database

When you make a table, row, select the database

A: Use behind the Write database name; Select the appropriate database this is a strange one, no semicolons.

4. To select a database to see how the table looks at all the tables below the library?

Answer: show tables;

5. How to delete a database

A: Drop database to write the last name;

6. Modify the Database

Can I modify the name of the database

Answer: No.

phpMyAdmin seems to have this function? He was building a new library and copying all the tables to the new library, which was done by deleting the old library.

7. How to create a table in a database??? To build a table, you first select the database

A: The name of the CREATE table last written

Case: Building a simple table

CREATE TABLE Class (

ATU int,

Name varchar (20),

Age int,

Area varchar (20)

);

8. How to modify the table name??????

Answer: Rename table name to the new table name;

9. How do I delete a table???

Answer: drop table name;

10. How to view the results of a table?????? Description can be abbreviated as DESC

A: Desc table name;

10 statements for MySQL entry