0

MySQL练习2

• Z 发布于
• 收藏

USE offcnoa;SELECT * FROM emp WHERE sal>2000;SELECT * FROM emp WHERE job != 'manager';SELECT * FROM emp WHERE sal>2000 AND sal<3000;SELECT * FROM emp WHERE sal<2000 OR sal>3000;...

0

MySQL练习

• Z 发布于
• 收藏

CREATE DATABASE a;USE a;SHOW CREATE DATABASE a;SHOW DATABASES;CREATE TABLE students( num INT, sname VARCHAR(20), sex VARCHAR(20)) DROP DATABASE a;INSERT INTO students(sname) VARCHAR('张三');INSE...