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;