MySQL Basics Summary

1. Declaration cursor: DECLARE cursor

2. Use the Fulltext child statement of the Creat table statement to enable full-text search when creating the base table

3. Undo the existing table s in the database, using: drop table S

4. Lookup table structure by: DESC

5, to get the last sentence select query to the total number of rows, with Found_rows

6. The actions you can complete on a view are: querying, defining new views, updating views

7. The function of unique unique indexes is to ensure that the values of each row on the index must not be duplicated

8. The command used to write the transaction to the database is: Commit

9, the establishment of the primary key has 3 methods

10. In SQL statements, subqueries are: Query statements embedded in another query statement

11. Implementing Entity Integrity: setting foreign keys

MySQL Basics Summary