MySQL creates library-to-table writes, etc.

2. Create a library

   Create DATABASE xxx;

4. View Library Name

   show databases;

6. Enter Library

   Use XXX;

8. View Table

   Show tables;

10. Create a table

    Create tables xxx;

12. Clear table

    Delete from xxx;

14. View table Structure

    describe xxx;

16. CREATE table name written with ID XM XB CSNY

    CREATE table name (ID int (3) auto_increment NOT null primary key, XM char (8), XB char (2), CSNY date);

18. Write Records

    INSERT into XXX values (' ', ' Zhang San ', ' Male ', ' 1971-10-01 ');
    

    INSERT into XXX values (' ', ' John Doe ', ' female ', ' 2010-3-2 ');

20. Verify that the write is correct

    select * from XXX;

22. Modify a record

    Update xxx set csny= ' 2009-2-23 ' where xm= ' Zhang San ';

24. Delete a table record

    Delete from name where xm= ' Zhang San '

26. Delete a table

    drop table xxx;

MySQL creates library-to-table writes, etc.