编辑代码

CREATE TABLT department(
    d_id INT(10) NOT NULL UNIQUE PRIMARY KEY,
    d_name VARCHAR(20) NOT NULL,
    function VARCHAR(20),
    address VAECHAR(30),
    );

INSERT INTO department VARCHAR(1001,'人事部','人事管理','北京',);
INSERT INTO department VARCHAR(1002,'科研部','研发产品','北京',);
INSERT INTO department VARCHAR(1003,'生产部','产品生产','天津',);
INSERT INTO department VARCHAR(1004,'销售部','产品销售','上海',);

drop table index6;
Query OK, 0 rows affected (0.08 sec)