表结构如下 CREATE TABLE `info` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ReporterName` varchar(50) NOT NULL,
`ReporterIP` varchar(15) NOT NULL,
`query` varchar(150) DEFAULT NULL,
`ItemID` varchar(32) NOT NULL,
`SellerName` varchar(50) NOT NULL,
`SellerID` varchar(32) DEFAULT NULL,
`BucketID` varchar(3) DEFAULT NULL,
`ReportTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Category` varchar(30) DEFAULT NULL,
`SpamType` varchar(200) DEFAULT NULL,
`Detail` varchar(200) DEFAULT NULL,
`fromsite` varchar(20) DEFAULT NULL,
`UserType` int(11) DEFAULT NULL,
`SelledCount` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
) ENGINE=MyISAM DEFAULT CHARSET=gbk 如何只导出UserType=1的数据,并且只导出前三个字段,也就是id,ReporterName,ReporterIP三个字段
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ReporterName` varchar(50) NOT NULL,
`ReporterIP` varchar(15) NOT NULL,
`query` varchar(150) DEFAULT NULL,
`ItemID` varchar(32) NOT NULL,
`SellerName` varchar(50) NOT NULL,
`SellerID` varchar(32) DEFAULT NULL,
`BucketID` varchar(3) DEFAULT NULL,
`ReportTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Category` varchar(30) DEFAULT NULL,
`SpamType` varchar(200) DEFAULT NULL,
`Detail` varchar(200) DEFAULT NULL,
`fromsite` varchar(20) DEFAULT NULL,
`UserType` int(11) DEFAULT NULL,
`SelledCount` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
) ENGINE=MyISAM DEFAULT CHARSET=gbk 如何只导出UserType=1的数据,并且只导出前三个字段,也就是id,ReporterName,ReporterIP三个字段
mysql -u root -pZWTL -e "SELECT id,ReporterName,ReporterIP from `info` where UserType=1">123.txt;
mysql -uroot -p12345 -e "SELECT id,ReporterName,ReporterIP from `info` where UserType=1 INTO OUTFILE 'c:/test/aa.dat'"
这样导出的是数据,可是我要的是包含insert语句的sql脚本,
不然我怎么导回到另一个新表中呢