新手小白创建SQL数据库，增删查改，升序，降序，不足之处望海涵

-- 创建数据表CREATE TABLE users(id INT PRIMARY KEY,name VARCHAR(50) NOT NULL,id_card VARCHAR(18) NOT NULL,phone VARCHAR(11) NOT NULL,address TEXT,password VARCHAR(50) NOT NULL);-- 添加数据INSERT INTO school.users VALUES(1,gaga,622723190102214,176906673,甘肃,123)INSERT INTO school.users VALUES(2,guoxiumei,62272319780632,152936095,甘肃,1234)INSERT INTO school.users VALUES(4,guoxiumei,62272319780632,15293609,甘肃,1234)INSERT INTO school.users VALUES(3,yangjingan,6227231964025,18671354,甘肃,12345)-- 修改数据UPDATE users SET name yangli WHERE id 4UPDATE users SET id_card 12345 WHERE id 1UPDATE users SET name zhiqiang WHERE ID 1-- 删除数据DELETE FROM users WHERE id 1DELETE FROM users WHERE id 2-- 查询数据select * from users;select id,name from users;-- 查看版本信息select version()--查看当前使用的数据库名select database()select * from school.users where address 甘肃select * from users where id 3select * from users where name yangjingan and id 3select * from users where name yangjingan and id 4select * from users where name yangjingan or id 4select * from users where id 3-- 模糊查询select * from users where name like yangliselect * from users where name like y%-- order by 字段select * from school.users order by idselect * from school.users order by id descselect * from school.users order by 4-- union 查询select * from usersunion select 1,2,3,4,5,6select name ,id from usersunionselect id,address from users