mysql按条件导出数据
就是按条件导出数据sql
谢谢
详细说明
比如我用一个表a
--
-- 表的结构 `a`
--
CREATE TABLE IF NOT EXISTS `a` (
`id` int(50) NOT NULL AUTO_INCREMENT,
`tag` varchar(50) CHARACTER SET gb2312 NOT NULL,
`tag1` varchar(50) CHARACTER SET gb2312 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=12 ;
--
-- 转存表中的数据 `a`
--
INSERT INTO `a` (`id`, `tag`, `tag1`) VALUES
(8, '77', '777'),
(9, '77', '7777'),
(10, '77', '55555'),
(11, '77', '666666');
(10, '88', '55555'),
(11, '88', '666666');
我要生成sql到本地
条件是select * from a where tag='88';
如生成到c:/a.sql
里面内容是
INSERT INTO `a` (`id`, `tag`, `tag1`) VALUES
(10, '88', '55555'),
(11, '88', '666666');
mysqldump -uroot -p test cms_content3 --where "tid=1"> j:\zz\a.sql
mysqldump -uroot -p1234 dbname a --where "tag='88'"> c:\a.sql
mysqldump -uroot -p1234 dbname a --where "tag='88'" --no-create-info> c:\a.sql
