mysql revise

 

DATABASE

create database db_name;

use db_name;

alter database db_name;

drop database db_name;

show databases;

TABLE

 

 

for example:

----------------------------------

use db_name;

create table table_name(

cust_id int not ull auto_increment primary key,

subject varchar(200),

words varchar(100),

username varchar(50),

createtime datatime

);

 

show tables;

desc mysql_test.customes;

insert into mysql_test.customes values(901,'zhangsan','F','beijing');

delete from mysql_test.customes where cust_name='wangwu';

update from mysql_test.customes set cust_address='wuhan' where cust_name='zhangsan'