查询语句,查询指定的字段,带条件查询,排序查询
---恢复内容开始---
SELECT id,username,PASSWORD FROM USER; -- 查询
-- 带条件的查询
SELECT * FROM USER WHERE username = 'h黄灵'
![](https://img2018.cnblogs.com/blog/1443671/201907/1443671-20190725113905742-1232701195.png)
INSERT INTO `testdb`.`user` (`username`, `password`)
VALUES
('侯慧聪', '888888')
VALUES
('侯慧聪', '888888')
SELECT * FROM USER ORDER BY id DESC -- 降序
SELECT * FROM USER ORDER BY username ASC -- 升序