0420-mysql keywords

1.show//view, show

2.use//Selection (Library/table)

3.DATABASE/S//library/All libraries

4.TABLE/S//table/All Tables

5.primary key//PRIMARY key: Non-repeatable, NOT NULL

6.unique key//Unique key: Non-repeatable, can be empty

7.primary key (ID,UID)//Federated primary key, two fields to form uniqueness

8.foreign key//foreign key: For example foreign key (ID2) references set_test (ID)

9.auto_increment//Self-growth: auto_increment = XX; Starting from XX self-growth

10.comment//Notes

11.engine = MyIsam//show CREATE TABLE tablename command look at the type of table. MyISAM, transaction not supported, InnoDB type supported.

12.charset//character encoding

13.default//Default value

14.delimiter//Set statement terminator such as delimiter*

0420-mysql keywords