create database test1;
show databases;
use mysql;
show tables;
desc user;
select * from user;
select Host, User, Password from user;
create user 'test'@'%' identified by '1234';
select Host, User, Password from user;
grant all privileges on test1.* to 'test'@'%';
flush privileges;
use test1;
create table member(
idx int(11) not null auto_increment,
id varchar(100) not null default '',
pwd varchar(100) not null default '',
name varchar(20) not null default '',
birth varchar(10) not null default '',
reg_dt datetime not null default '1900-01-01',
primary key(idx)
);
show tables;
desc member;
alter table member add mod_dt datetime not null default '1900-01-01';
desc member;
alter table member add phone varchar(20) null default '' after birth;
desc member;
alter table member add test int(11) not null;
desc member;
alter table member drop test;
desc member;
alter table member change name nm varchar(20);
desc member;
show columns from member;
alter table member modify nm varchar(20) not null default '';
create table goods(
idx int(11) not null auto_increment primary key,
name varchar(20) not null default '',
reg_dt datetime not null default '1900-01-01'
);
show tables;
drop table goods;
show tables;
alter table member rename customer;
show tables;
alter table customer rename member;
show tables;
rename table member to customer;
show tables;
rename table customer to member;
)