mysql
显示数据库列表
show databases
创建数据库
create databases test3
删除数据库
drop database test3
选择数据库
use test1
显示数据库中的表
show tables
显示表结构
desc city
创建表
create table test4( a int, b int ,c int)
查看表结构
desc tables;
删除表
drop table test4;
复制表
create table test5 like countrylanguage
insert into test5 select * from countrylanguage limit 5
查询数据
select * from test5 where countrycode='abw' limit 2 offset 1
模糊查找
select * from test5 where countrycode='%a'
插入数据
insert into test5 (countrycode,laguage) values('AAA','aaa');
修改数据
update test5 set percentage=0.1;
删除数据
delete from test5;
统计条数
select count(*) from test5
导出表数据
mysqldump -uroot -p world test5>test5.txt
导入备份
use world
source test5.txt
pymysql
import pymysql
db = pymysql.connect("localhost","testuser","test123","TESTDB" )
cursor = db.cursor()
sql=’select * from test5’
res=cursor.execute(sql)
result=cursor.fetchall()
db.close()