MySQL增删改查

一、增

INSERT INTO 表明 VALUE（'数据1','数据2',... ...）;

eg. INSERT INTO books VALUE('0-672-31784-5','lixingqiao','mybook','56.90');

+---------------+----------------+---------------------------------------------------+-------+

| isbn          | author         | title                                             | price |

+---------------+----------------+---------------------------------------------------+-------+

| 0-672-31784-5 | lixingqiao     | mybook                                            | 56.90 |

+---------------+----------------+---------------------------------------------------+-------+

二、删

    DELETE FROM 表明 WHERE 列名='值';

    eg.DELETE FROM books WHERE author='lixingqiao';

    PS、一般来说删除数据库中的数据都是以主键为条件的，因为主键是不可重复的！

    2.1批量删除

DELETE FROM 表明 WHERE 列名 IN('值1','值2','值3',... ...);

三、改

UPDATE 表名 SET 列名='修改后的数据' WHERE 列名='被修改的数据';

eg.UPDATE books SET author='jhon' WHERE author='liujing';

+---------------+----------------+---------------------------------------------------+-------+

| isbn          | author         | title                                             | price |

+---------------+----------------+---------------------------------------------------+-------+

| 978-7-111-262 | jhon           | sdhkajhsdkf                                       | 34.60 |

+---------------+----------------+---------------------------------------------------+-------+

四、查

SELECT * FROM 表名;

eg.SELECT * FROM books;

+---------------+----------------+---------------------------------------------------+-------+

| isbn          | author         | title                                             | price |

+---------------+----------------+---------------------------------------------------+-------+

| 0-672-31509-2 | Pruitt, et al. | Teach Yourself GIMP in 24 Hours                   | 24.99 |

| 0-672-31697-8 | Michael Morgan | Java 2 for Professional Developers                | 34.99 |

| 0-672-31745-1 | Thomas Down    | Installing Debian GNU/Linux                       | 24.99 |

| 0-672-31769-9 | Thomas Schenk  | Caldera OpenLinux System Administration Unleashed | 49.99 |

| 978-7-111-262 | jhon           | sdhkajhsdkf                                       | 34.60 |

+---------------+----------------+---------------------------------------------------+-------+