1.创建表
例子:
CREATE TABLE EMPLOYEE_PAY_TBL
(
EMP_ID VARCHAR(9) NOT NULL primary key,
POSITION VARCHAR(15) NOT NULL,
DATE_HIRE DATE,
PAY_RATE DECIMAL(4,2),
DATE_LAST_RAISE DATE,
SALARY DECIMAL(8,2),
BONUS DECIMAL(6,2),
CONSTRAINT EMP_FK FOREIGN KEY (EMP_ID) REFERENCES EMPOYEE_TBL(EMP_ID)
);
2.删除表
drop talbe table_name;
3.使用某个数据库:
use learnsql;
4.显示数据库中有哪些表:
show tables;
5.列出每个表的全部字段和他们的属性:
describe employee_tbl;