mysql建库建表，导出表结构

//建库：
create database db_name character set =utf8;
/*建立库db_name，默认字符集为utf8*/

//建表：
create table tb_1 (id int auto_increment primary key, remark varchar(20)) engine=innodb default character set=utf8 auto_increment =100;
/*建立表tb_1，存储引擎为innodb,默认字符集为utf8，自增列开始值为100*/

create table tb_2 (id2 int auto_increment primary key, remark varchar(20)) engine=innodb default character set=utf8 auto_increment =100;

//删表
DROP TABLE IF EXISTS `A`;

//删库
drop database 库1

//内联接：
select * from t1 inner join t2 where t1.id=t2.id2;

//左联接：
select * from t1 left join t2 on t1.id=t2.id2;

//右联接：
select * from t1 right join t2 on t1.id=t2.id2;

//全联接：
select * from t1,t2 

 

另外导出数据库表结构：

mysqldump -uroot -p ugood_newspaper_db merchant_orders>aaa.sql;
ugood_newspaper_db数据库名，merchant_orders表名，aaa是导出文件名