数据库表操作练习题

#  1、创建数据库test03_company
CREATE DATABASE IF NOT EXISTS test03_company CHARACTER SET 'utf8';
#  2、创建表offices
USE test03_company;
CREATE TABLE offices(
officeCode INT,
city VARCHAR(30),
address VARCHAR(50),
country VARCHAR(50) ,
postalCode VARCHAR(25)
);
#  3、创建表employees
CREATE TABLE IF NOT EXISTS employees(
empNum INT,
lastName VARCHAR(50),
firstName VARCHAR(50),
mobile VARCHAR(25),
`code` INT ,
jobTitle VARCHAR(50),
birth DATA,
note VARCHAR(255),
sex VARCHAR(5)
);
#  4、将表employees的mobile字段修改到code字段后面
ALTER TABLE employees
MODIFY mobile VARCHAR(20) AFTER `code`;

#  5、将表employees的birth字段改名为birthday
ALTER TABLE employees
CHANGE birth birthday data;

#  6、修改sex字段，数据类型为char(1)
ALTER TABLE employees
MODIFY sex CHAR(1)
#  7、删除字段note
ALTER TABLE employees
DROP COLUMN note;
#  8、增加字段名favoriate_activity在sex后面，数据类型为varchar(100)
ALTER TABLE employees
ADD  favoriate_activity varchar(100) AFTER sex;

#  9、将表employees的名称修改为 employees_info
1.ALTER TABLE employees RENAME TO employees_info
2.RENAME TABLE employees TO employees_info