mysql.txt

来自「python_MySQL之间的几个小例子。对于python连接的数据库」· 文本 代码 · 共 27 行

drop database if exists xpower;
create database if not exists  xpower;

DROP TABLE IF EXISTS `pinYin`;
create table pinYin(
   id int primary key auto_increment not null,
   hanZi varchar(2) not null,
   pinYin varchar(10) not null,
   shengDiao tinyint default 1,
   priority float default 1.0)
   TYPE=MyISAM;

DROP TABLE IF EXISTS `cihui`;
create table cihui(
 id int primary key auto_increment not null,
 ciHui varchar(50) not null,
 Len tinyint not null,
 ciXing char(1),
 priority float default 1.0)
 TYPE=MyISAM;

select * from pinyin into outfile "d:\pinyin.txt";
select * from pinyin into outfile "d:\pinyin.txt";

mysqldump -uroot -p xpower > db.sql

mysqldump  -uroot   -p -e --opt   --default-character-set=latin1 --result-file=d:\cihui\xpower.sql  xpower