摘要:使用SQL查询所有数据库名和表名 MySQL中查询所有数据库名和表名 查询所有数据库 show databases; 1 1 查询指定数据库中所有表名 select table_name from information_schema.tables where table_schema='datab
阅读全文
摘要:select * from student order by id drop table student select * from oracletest create table student( idcard varchar2(18), name varchar2(20), sex int, h
阅读全文
摘要:select * from ( selectclass 班级,subject,avg(grade) avg_gradefrom student_score group by class,subject) pivot (sum(avg_grade) for subject in ('语文', '数学'
阅读全文