mysql -h localhost -u root -p
与mysql连接后,可以进入库进行数据表的操作
use thinkphp(要有thinkphp这个库)
show tables;(要带分号)
desc tp_user;
insert操作
insert into tp_user (username,sex) values ('lili',1); (列与值要严格对应,可以少插入几列)
select * from tp_user;
也可以直接insert into tp_user values(4,'peter',0); 默认是全部的列都要有数值的。字符串必须加单引号
update操作
update tp_user set sex=0 where username='lili';
delete from tp_user where uid=4;删除
select * from tp_user where uid>=2;查找
select username from tp_user where uid>=2;