查询语句，查询指定的字段，带条件查询，排序查询

---恢复内容开始---

SELECT id,username,PASSWORD FROM USER;   -- 查询

 

-- 带条件的查询

SELECT * FROM USER WHERE username = 'h黄灵'

 

 

INSERT INTO `testdb`.`user` (`username`, `password`)
VALUES
  ('侯慧聪', '888888') 

SELECT * FROM USER ORDER BY id DESC      -- 降序

SELECT * FROM USER ORDER BY username ASC  -- 升序