mysql增、删、改、查语句
mysql增、删、改、查语句例子:创建表:create;table;tutorials_tbl(
;;;id;INT;NOT;NULL;AUTO_INCREMENT,
;;;title;VARCHAR(100);NOT;NULL,
;;;author;VARCHAR(40);NOT;NULL,
;;;date;DATE,
;;;PRIMARY;KEY;(;id;));语句:添加:;insert;into;ba_user(`username`,`password`)VALUES('张三',MD5('123456'));
查询:select;*;from;ba_user;
修改:UPDATE;ba_user;SET;username='小里';WHERE;id=9;
删除:DELETE;FROM;ba_user;WHERE;id=9;