MySQL Command Line Client

显示mysql的版本
select version();
显示日历
select now();
显示所有数据库
show databases;
创建名为suq的数据库
create database suq;
create database suq2 default character set utf8 collate utf8_general_ci
删除名为suq数据库
drop database suq;
drop database if exists suq;
选择数据库suq
use suq;
当前选择数据库
select database();
显示所选数据库所有表
show tables;
创建表名为info的数据表
有id、name、sex、age、introduce
create table info2(
id int(4) not null primary key auto_increment,
name char(20) not null,
sex int(4) not null default'0',
age int(4) not null,
introduce varchar(100)
);
删除数据表
drop table info2;
显示info表结构(字段)
show columns from info;
插入info表一条记录
insert into info values(0,'suqiang','0','24','I am a IT man');
insert into info (name,sex,age,introduce) values('苏强','0','20','我是个IT男');
显示info表所有记录
select * from info;
查询语句
select * from info where id = 2;
select name from info;
select name from info where id = 1;
删除语句
delete from info where id = 3;
修改语句
update info set name = 'xiaoheima' where id=3;
info表中增加字段phonenum
alter table info add phonenum varchar(11) default'0';
修改原字段名及类型(info表中age改成idcard,int类型改成varchar)
alter table info change age idcard varchar(18);
修改表名
rename table info to infoma;