MySQL command prompt

First, MySQL Create data table

1. Create a MySQL database from the MySQL command window

2. Create MySQL data table from MySQL command window

3. View the details of the created data table through the MySQL command window

Second, MySQL delete data sheet

1. Delete the data in the table

2. Empty the data in the structure table without changing the Jiegou of the data table

3. Delete the entire data sheet

Third, MySQL insert data

1.Mysql inserting a single piece of data

2.Mysql inserting more than one piece of data

There is no need to add the value of ID, because the ID field was previously set to Auto_increment auto-increment property

Iv. WHERE clause of MySQL

Inquire

Update

Delete

Reading data

(Find all data in the Practice1 table that ends with a "good" word)

Attention:

'% good ' is data with good endings

' Good% ' is data with good start

'% good% ' is content that contains good data

MySQL command prompt