Modify and backup, the batch sometimes we want to modify and delete database tables and databases, you can implement: 1, add a column: Add a column in the MyTable table in the previous example, indicate whether single Single: MySQL> ALTER TABLE MyTable Add Column Single Char (1); 2, modified record modified the SINGLE record of ABCCS to "Y": mysql> Update myTable set single = 'y' where name = 'abccs'; now come and see what happened: mysql > select * from mytable; ---------- ---- ---------- ----------- -------- | Name | SEX | BIRTH | BIRTHADDR | SINGLE | ---------- ------ --------- - ----------- ------ | Abccs | f | 1977-07-07 | China | Y | | Mary | F | 1978-12-12 | USA | NULL | | Tom | M | 1970-09-02 | USA | NULL | ---------- ------ ---------- ----------- -------- 3, before adding the record, how to add a record, for easy view, repeat and this: mysql> Insert Into MyTable -> Values ('ABC', 'F', '1966-08-17', 'CHINA', 'N'); Query Ok, 1 ROW Affected (0.05 sec) check: mysql> select * from myTable; --- ------- ------ ---------- ---------- -------- | Name | SEX | BIRTH | BIRTHADDR | SINGLE | ---------- ---- ---------- -------- - -------- | Abccs | f | 1977-07-07 | China | Y | | Mary | F | 1978-12-12 | USA | NULL | | Tom | M | 1970-09-02 | USA | NULL | | ABC | F | 1966-08-17 | China | N | ---------- ---- --- -------------------- -------- 3, delete records Use the following command to delete a record in the table: mysql> delete from MyTable Where name = 'abc'; delete removes a record that satisfies the conditions given by WHERE from the table.
