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;

)