首页 > 代码库 > MySQL表操作之增删查改

MySQL表操作之增删查改

 

  01 插入数据 INSERT

    INSERT INTO `table_name` ( `column01_name` , `column02_name` , ... ) VALUES ( value01 , value02 ,  ...)

  02 查询数据 SELECT

    SELECT * FROM `table_name` WHERE `column01` = value01 and `column02` = value02 and ...

  03 修改数据 UPDATE

    UPDATE `table_name` SET `column01_name` = new_value01 , `column02_name` = new_value02 , ...

  04 删除数据 DELETE

    DELETE FROM `table_name` WHERE `column01_name` = value01 , `column02_name` = value02 , ...

 

2014-09-02 14:47:07 于BIT/#10/315

MySQL表操作之增删查改