啥也不是。敬自己

show databases
use shujuku_name
show table
show columns from table_name
select name from table_name
select name,age from table_name
select name,age,workyear form table_name
select name as 姓名 from table_name
select name as 姓名,age as 年龄, workyear as 年限 from table_name
select from table_name
select distinct age form table_name
select id,name form table_name limit 10
select id,name from table limit 10,15
select id,name from table_name order by id deac limit 10,10
select name,workyear from table order by workyear
select name,workyear from table order by age
select name,age,workyear from table order by age,workyear
select distinct age from table_name order by age desc limit 3
select id,name from table_name orderby id desc
select name,python_score from score where python_score >= 60
select name,python_score from score where python_score = 90
select name,python_score from score where python_score between 90 an 100 order by python_score desc
select name,python_score from score where python_score
select name,python_score from score where not python_score >= 60
select * from score where python_score >=60 and sql_score >=60
select * from score where python_score >=60 or sql_score >=60
select * from score where test >=60 and (python >=60 or sql >=60)
select * from score where python_score in (80,90,100)
select * from score where name like "zhang%"
select * from score where name like "zhang%" or name like "wang%" or name like "li%" or name like "zhao%"
select * from score where name like "wang"
select * from score where not name like "wang&" and not name like "li%"
select concat (name,"",python_score,"",sql_score,"_",test_score) from score
select name,python,sql,python+sql as 总成绩 from score
select name,python,sql,test,python+sql+test as 总成绩 from score where python+sql+test >=250 order by 总成绩 desc limit 3
select count(name) from score where python >=60 or sql >=60
select max(product_price) from orders
select product_name from orders where product_price = (select max(product_price) from order)
select product_name from orders group by product_name
select product_name,count(product_name),sum(product_name) from orders where order_time like "2020-11-05%" group by product_name
select max(product_price) from orders
select product_price = (select max(product_price) from orders)
select sum(product_price
product_order_num) from orders where product_name in (select product_name from orders where product_price = (select max(product_price) from orders))
select s_no,s_name from students1107 where s_no in (select s_no from course1107 where classdate = "2020-11-07"
select s.s_no,s.s_name,c.classdate from students1107 course1107 where course1107.classdate = "2020-11-07" and course1107.s_no=students1107.s_no
select c.c_name,s.s_name,t.t_name from s,t,c where c.classdate = "2020-11-07" and s.s_no = c.s_no and t.t_no = c.t_no
select s.s_no,s.s_name,count(c.s_no) as 上课次数 from s,c where s.s_no = c.s_no group by c.s_no,s.s_name order by 上课次数 desc
select fanmao45.wechat_id from fanmao45 inner join fanmao46 on 45.id = 46.id

posted @ 2020-11-12 18:34  货拉拉拉不拉拉布拉多  阅读(52)  评论(0)    收藏  举报