MySQL database table management (add and revise)

table field Management

1. Add to end

ALTER TABLE name add field name data type;

2 Add to start

ALTER TABLE name add data type first;

3. Add to the specified location

ALTER TABLE name add new field name data type after original field name;

4. Delete a field

ALTER TABLE name drop field name;

5. Modifying data Types

ALTER TABLE name modify field name new data type;

6. Modify the field name

ALTER TABLE name change old name new name data type;

7. Modify the table name:

ALTER TABLE name rename new table name;

Table Records Management

1. Update table Records

Update table name set field name = value 1, field name = value 2,...;

2. Delete Table Records

Delete from table name where= condition;

Delete must add a where condition, otherwise all records will be deleted

MySQL database table management (add and revise)