create database test01_office character set 'utf8';
use test01_office;
create table dept01(
id int(7),
name varchar(25),
);
create table dept02
as
select *
from atguigudb.departments;
create table emp01(
id int(7),
first_name varchar(25),
last_name varchar(25),
dept_id int(7)
);
alter table emp01
modify last_name varchar(50);
create table emp02
as
select *
from employees;
drop table emp01;
rename table emp02 to emp01;
alter table dept01
add test_column varchar(10);
alter table emp01
add test_column varchar(10);
alter table emp01
drop column department_id;
create database if not exists test02_market character set 'utf8';
use test02_market;
create table customers(
c_num int,
c_name varchar(50),
c_contact varchar(50),
c_city varchar(50),
c_birth date);
select *
from customers;
desc customers;
show create table customers;
alter table customers
modify c_contact varchar(50) after c_birth;
alter table customers
modify c_name varchar(70);
alter table customers
change c_contact c_phone varchar(50);
alter table customers
add c_gender char(1) after c_name;
desc customers;
rename table customers to customers_info;
alter table customers_info
drop c_city;