MySQL multi-table operations and batch processing methods (3) _ MySQL-mysql tutorial

MySQL multi-table operations and batch processing methods (3) 3. add Records

We have already discussed how to add a record to repeat this record for ease of viewing:

　　

Mysql> insert into mytable
-> Values ('ABC', 'F', '1966-08-17', 'China', 'n ′);
Query OK, 1 row affected (0.05 sec)

Check it out:

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 |
+ ---------- + ------ + ------------ + ----------- + -------- +

4. delete records

Run the following command to delete a record in the table:

Mysql> delete from mytable where name = 'abc ′;

DELETE: DELETE a record from the table that meets the conditions given by where.

The result is displayed as follows:

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 |
+ ---------- + ------ + ------------ + ----------- + -------- +

5. delete a table:

Mysql> drop table ***** (name of table 1), and *** name of table 2;

You can delete one or more tables with caution.