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
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。