mysql -u root -p                     以root权限登录，默认密码为空

 show databases;            　　　　　　列出所有数据库

 drop table if exists hst;        　　 如果存在表hst则先删除

 create database hst;                 创建数据库

 use hst;                    　　　　　 进入数据库

 create table student(

 id int auto_increment primary key,

 name varchar(50),

 sex varchar(20),

 date varchar(50),

 content varchar(100)

 )default charset=utf8;        　　　　创建表

 drop table student;            　　　 删除表

 describe student;        　　　　　　　查看表结构(desc student;)

 insert into student values(null,'aa','男','1988-10-12','.....');    插入数据

 select * from student;

 select id,name from student;         　　　　查询id，name列

 update student set sex='男' where id=4;    修改id为4的行性别为男

 delete from student where id=5;        　　删除id为5的行

 select * from student where date>'1988-1-2' and date<'1988-12-1';    and、or

 select * from student where date between '1988-1-2' and '1988-12-1';    between            

 import pymysql

 db = pymysql.connect("localhost", "root", "", "test")  连接test数据库

 cursor=db.cursor()

 cursor.execute(sql语句)

 db.commit()

 db.close()

 #!/user/bin/python

 #-*-coding:UTF-8 *-*

 import pymysql

 import random,string,uuid

 def generateN(len, count, cursor, db, database):

     getChars = lambda: string.ascii_letters+string.digits

     generate = lambda len: "".join(random.sample(getChars(), len))

     for i in range(count):

         sql = "insert into {0} (id,value) values ({1},'{2}')".format(database,"null", generate(len))

         cursor.execute(sql)

         db.commit()

 #generateN(10, 20)

 db = pymysql.connect("localhost", "root", "", "hst")

 cursor = db.cursor()

 cursor.execute("drop table if exists generateCodes")

 sql = "create table generateCodes(id int auto_increment primary key, value varchar(50))"

 cursor.execute(sql)

 cursor.execute("show tables");

 generateN(10, 20, cursor, db, "generateCodes")

 db.close()

 select * from generateCodes;