MySQL commonly used additions and deletions to change the command (pure record.) The basic skills of ORM are gone. )

To update the table data:

Update table_name set xxx=where condition;

Add Field:

Alter Table Add field type other;e.g: Alter Table Add int (4default'0';

To delete a field:

ALTER TABLE DROP Field_name;

To increase the DROP index:

# Add Alter Table Add  Index index name (field name 1[, field name 2 ...) ]); # delete altertabledrop index index name;

Add Data:

Insert  into table_name (<field1>[]values (<  >[, (<value_n >]);

Delete data:

Delete  from where condition;

Modify Table Name:

Table  to Other_table_name;

To delete a data table:

Drop table table_name;

Reference:

Http://c.biancheng.net/cpp/html/1456.html

MySQL commonly used additions and deletions to change the command (pure record.) The basic skills of ORM are gone. )