MySQL Common commands

1. show databases; View database

2. Use database name; switch using the specified database

3. Show tables; View tables present in the current database

4. Create a table with a simple example as follows:

CREATE TABLE person (ID int. NOT NULL, name varchar (a), age int);

5. Add the object to the table:

Insert into the person values (' 1 ', ' Smith ', ' 17 ');

6. drop table name; Delete Table

7. Change the table structure:

To add a property:

ALTER TABLE table name Add field name fields type;

To modify the properties of an attribute:

ALTER TABLE name modify column name new data type

MySQL Common commands