今天学习的SQL数据库的各种操作
insert 操作是更新数据
DELETE FROM user1 WHERE userId = 2 删除 ID为2的数据
SELECT * FROM user1 查询所有
UPDATE user1 set username = 'uu' WHERE userId = 3 添加数据
SELECT username as 用户,password as 密码 from user1 修改别名
SELECT * FROM user1 where PASSWORD LIKE '_3%' 查询第二个字符威3,字符多余三个的,下划线代表字,百分号代表后面还有 %\%% 查询 含有%的数据 ,escape可以将%字符化, %\% escape ' w',就能查询 \
SELECT * from user1 WHERE userId not in(4,5) ORDER BY userId asc
SELECT * from user1 WHERE userId not in(4,5) ORDER BY userId DESC 升序和降序排列