摘要:
select count(*) from users where status = 0 as:select count(*) as sb from users where status = 0select usename as sb ,password as zz from users 阅读全文
摘要:
-- select * from users -- order by排序 -- desc降序 -- 升序 由小到大 -- 下列两条都是升序,其中asc加不加都可以,因为他们是等价的 -- select * from users order by status -- select * from use 阅读全文
摘要:
where语句的运算符 -- where子句的演示 -- 根据条件查询 -- select *from users where id >= 2 -- select * from users where id = 1 -- select * from users where usename !='李四 阅读全文