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