mysql> select version(); 查看MySQL的版本号
mysql> select current_date(); 查看MySQL的当前日期
mysql> select version(),current_date(); 同时查看MySQL的版本号和当前日期
mysql> show databases; 显示当前存在的数据库
mysql> USE mysql 选择使用数据库(USE和QUIT命令不需要分号结束)
Database changed
mysql> select database(); 显示当前选择的数据库
mysql> show tables; 显示当前数据库中存在的表
mysql> select * from db; 显示表(db)的内容 
mysql> describe mytable; 显示表的结构

mysql> select
-> user()
-> \c
mysql>

mysql> select
-> USER()
-> ,
-> now()
->;
mysql> Select (20+5)*4;
mysql> Select (20+5)*4,sin(pi()/3);
mysql> Select (20+5)*4 AS Result,sin(pi()/3); (AS: 指定假名为Result)

mysql> show processlist;

mysql> CREATE DATABASE abccs; 创建一个数据库 
mysql> USE abccs 选择使用数据库
mysql> drop database 数据库名; 删除数据库

mysql> CREATE TABLE mytable
-> (
-> name VARCHAR(20),
-> sex CHAR(1),
-> birth DATE,
-> birthaddr VARCHAR(20)
-> );

mysql> select * from mytable;

mysql> insert into mytable 
-> values
->(
->'abccs',
->'f',
->'1977-07-07',
->'china'
->);

abccs f 1977-07-07 china 
mary f 1978-12-12 usa
tom m 1970-09-02 usa

mysql> Load data local infile "mytable.txt" into table mytable;

mysql> update mytable set birth = "1973-09-02" where name = "tom";

mysql> delete from mytable where id=10; //删除掉所有id=10的记录;
mysql> delete from mytable where id=10 limit 1; //限制删除掉1条id=10的记录;
mysql> delete from mytable //删除一个表的全部记录;
mysql> DELETE FROM t1 WHERE C>10;
mysql> drop table tablename1,tablename2,…; //删除整一个表或多个表，小心使用。

mysql> alter table t1 rename t2;

mysql> describe mytable; 或用show columns from 表名；

mysql> alter table tablename modify id int(10) unsigned auto_increment primary key not null

mysql> alter table tablename alter id default 0

mysql> alter table tablename add primary key(id);

alter table tablename drop primary key;
drop primary key on tablename;

mysql> alter table tableName ENGINE = MyISAM (InnoDB);

mysql> alter table mytable add column single char(1);
mysql> ALTER TABLE table ADD field INT(11) UNSIGNED NOT NULL

mysql> alter table t2 drop column c;

ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);

ALTER TABLE t2 ADD d TIMESTAMP;

ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a);

ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT,ADD INDEX (c);

CREATE INDEX part_of_name ON customer (name(10));

mysqldump --opt school > school.sql

mysqldump --opt school teacher student > school.teacher.student.sql

mysql
mysql>create database school;
mysql>use school;
mysql>source school.sql;

mysqldump --databases db1 db2 > db1.db2.sql

mysql < db1.db2.sql

mysql
mysql>drop database a;
mysql>