MySQL Simple SQL statement

1. Modify the encoding of the database alter test character set UTF8

2. Create a new table:

CREATE TABLE TEXT4 (ID int () NOT NULL PRIMARY key auto_increment,username varchar (pwd char (32))

Where: Primary key primary key, auto_increment self-increment.

3. add field [i.e. modify ALTER TABLE]

Alter ADD command format: ALTER TABLE name add field type other;
For example, a field passtest is added to table MyClass, the type is int (4), and the default value is 0:
Mysql> ALTER TABLE MyClass add passtest int (4) default ' 0 ';

4. Create a partition when building a table

1) Range partition

Create

MySQL Simple SQL statement