mysql°´Ìõ¼þµ¼³öÊý¾Ý

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