(1)创建表dept1
/*
name null? type
id int(7)
name varchar(25)
*/
CREATE DATABASE IF NOT EXISTS my_test;
USE my_test;
CREATE TABLE dept1(
id INT(7),
NAME VARCHAR(25)
);
(2)将表departments中的数据插入新表dept2中【departments表在myemployees库中】【dept2表在my_test库中】
复制表
CREATE TABLE dept2
SELECT manager_id, department_name FROM myemployees.departments;
(3)创建表emp5
/*
name null? type
id int(7)
first_name varchar(25)
last_name varchar(25)
dept_id int(7)
*/
CREATE TABLE emp5(
id INT(7),
first_name VARCHAR(25),
last_name VARCHAR(25),
dept_id INT(7)
);
(4)将列last_name的长度增加到50
ALTER TABLE emp5 MODIFY CO