新手提问：mysql 对account表insert 1000条数据

Question

account表就两个字段，id int，name char（20）. insert的记录是有规律的，第一条（1，‘test1’）第二条（2，‘test2’）以此类推，一共1000条，最好直接给我能在SQLyog里面使用的语句，一条一条插的不行，不现实。。新手求教了，谢谢

Answer 1

insert into account values
(1,'test1'),
(2,'test2'),
(3,'test3'),
(4,'test4'),
(5,'test5'),
(6,'test6'),
(7,'test7'),
(8,'test8'),
(9,'test9'),
(10,'test10'),
(11,'test11'),
(12,'test12'),
(13,'test13'),
(14,'test14'),
(15,'test15'),
(16,'test16'),
(17,'test17'),
(18,'test18'),
(19,'test19'),
(20,'test20'),
(21,'test21'),
(22,'test22'),
(23,'test23'),
(24,'test24'),
(25,'test25'),
(26,'test26'),
(27,'test27'),
(28,'test28'),
(29,'test29'),
(30,'test30'),
(31,'test31'),
(32,'test32'),
(33,'test33'),
(34,'test34'),
(35,'test35'),
(36,'test36'),
(37,'test37'),
(38,'test38'),
(39,'test39'),
(40,'test40'),
(41,'test41'),
(42,'test42'),
(43,'test43'),
(44,'test44'),
(45,'test45'),
(46,'test46'),
(47,'test47'),
(48,'test48'),
(49,'test49'),
(50,'test50'),
(51,'test51'),
(52,'test52'),
(53,'test53'),
(54,'test54'),
(55,'test55'),
(56,'test56'),
(57,'test57'),
(58,'test58'),
(59,'test59'),
(60,'test60'),
(61,'test61'),
(62,'test62'),
(63,'test63'),
(64,'test64'),
(65,'test65'),
(66,'test66'),
(67,'test67'),
(68,'test68'),
(69,'test69'),
(70,'test70'),
(71,'test71'),
(72,'test72'),
(73,'test73'),
(74,'test74'),
(75,'test75'),
(76,'test76'),
(77,'test77'),
(78,'test78'),
(79,'test79'),
(80,'test80'),
(81,'test81'),
(82,'test82'),
(83,'test83'),
(84,'test84'),
(85,'test85'),
(86,'test86'),
(87,'test87'),
(88,'test88'),
(89,'test89'),
(90,'test90'),
(91,'test91'),
(92,'test92'),
(93,'test93'),
(94,'test94'),
(95,'test95'),
(96,'test96'),
(97,'test97'),
(98,'test98'),
(99,'test99'),
(100,'test100'),
(101,'test101'),
(102,'test102'),
(103,'test103'),
(104,'test104'),
(105,'test105'),
(106,'test106'),
(107,'test107'),
(108,'test108'),
(109,'test109'),
(110,'test110'),
(111,'test111'),
(112,'test112'),
(113,'test113'),
(114,'test114'),
(115,'test115'),
(116,'test116'),
(117,'test117'),
(118,'test118'),
(119,'test119'),
(120,'test120'),
(121,'test121'),
(122,'test122'),
(123,'test123'),
(124,'test124'),
(125,'test125'),
(126,'test126'),
(127,'test127'),
(128,'test128'),
(129,'test129'),
(130,'test130'),
(131,'test131'),
(132,'test132'),
(133,'test133'),
(134,'test134'),
(135,'test135'),
(136,'test136'),
(137,'test137'),
(138,'test138'),
(139,'test139'),
(140,'test140'),
(141,'test141'),
(142,'test142'),
(143,'test143'),
(144,'test144'),
(145,'test145'),
(146,'test146'),
(147,'test147'),
(148,'test148'),
(149,'test149'),
(150,'test150'),
(151,'test151'),
(152,'test152'),
(153,'test153'),
(154,'test154'),
(155,'test155'),
(156,'test156'),
(157,'test157'),
(158,'test158'),
(159,'test159'),
(160,'test160'),
(161,'test161'),
(162,'test162'),
(163,'test163'),
(164,'test164'),
(165,'test165'),
(166,'test166'),
(167,'test167'),
(168,'test168'),
(169,'test169'),
(170,'test170'),
(171,'test171'),
(172,'test172'),
(173,'test173'),
(174,'test174'),
(175,'test175'),
(176,'test176'),
(177,'test177'),
(178,'test178'),
(179,'test179'),
(180,'test180'),
(181,'test181'),
(182,'test182'),
(183,'test183'),
(184,'test184'),
(185,'test185'),
(186,'test186'),
(187,'test187'),
(188,'test188'),
(189,'test189'),
(190,'test190'),
(191,'test191'),
(192,'test192'),
(193,'test193'),
(194,'test194'),
(195,'test195'),
(196,'test196'),
(197,'test197'),
(198,'test198'),
(199,'test199'),
(200,'test200'),
(201,'test201'),
(202,'test202'),
(203,'test203'),
(204,'test204'),
(205,'test205'),
(206,'test206'),
(207,'test207'),
(208,'test208'),
(209,'test209'),
(210,'test210'),
(211,'test211'),
(212,'test212'),
(213,'test213'),
(214,'test214'),
(215,'test215'),
(216,'test216'),
(217,'test217'),
(218,'test218'),
(219,'test219'),
(220,'test220'),
(221,'test221'),
(222,'test222'),
(223,'test223'),
(224,'test224'),
(225,'test225'),
(226,'test226'),
(227,'test227'),
(228,'test228'),
(229,'test229'),
(230,'test230'),
(231,'test231'),
(232,'test232'),
(233,'test233'),
(234,'test234'),
(235,'test235'),
(236,'test236'),
(237,'test237'),
(238,'test238'),
(239,'test239'),
(240,'test240'),
(241,'test241'),
(242,'test242'),
(243,'test243'),
(244,'test244'),
(245,'test245'),
(246,'test246'),
(247,'test247'),
(248,'test248'),
(249,'test249'),
(250,'test250'),
(251,'test251'),
(252,'test252'),
(253,'test253'),
(254,'test254'),
(255,'test255'),
(256,'test256'),
(257,'test257'),
(258,'test258'),
(259,'test259'),
(260,'test260'),
(261,'test261'),
(262,'test262'),
(263,'test263'),
(264,'test264'),
(265,'test265'),
(266,'test266'),
(267,'test267'),
(268,'test268'),
(269,'test269'),
(270,'test270'),
(271,'test271'),
(272,'test272'),
(273,'test273'),
(274,'test274'),
(275,'test275'),
(276,'test276'),
(277,'test277'),
(278,'test278'),
(279,'test279'),
(280,'test280'),
(281,'test281'),
(282,'test282'),
(283,'test283'),
(284,'test284'),
(285,'test285'),
(286,'test286'),
(287,'test287'),
(288,'test288'),
(289,'test289'),
(290,'test290'),
(291,'test291'),
(292,'test292'),
(293,'test293'),
(294,'test294'),
(295,'test295'),
(296,'test296'),
(297,'test297'),
(298,'test298'),
(299,'test299'),
(300,'test300'),
(301,'test301'),
(302,'test302'),
(303,'test303'),
(304,'test304'),
(305,'test305'),
(306,'test306'),
(307,'test307'),
(308,'test308'),
(309,'test309'),
(310,'test310'),
(311,'test311'),
(312,'test312'),
(313,'test313'),
(314,'test314'),
(315,'test315'),
(316,'test316'),
(317,'test317'),
(318,'test318'),
(319,'test319'),
(320,'test320'),
(321,'test321'),
(322,'test322'),
(323,'test323'),
(324,'test324'),
(325,'test325'),
(326,'test326'),
(327,'test327'),
(328,'test328'),
(329,'test329'),
(330,'test330'),
(331,'test331'),
(332,'test332'),
(333,'test333'),
(334,'test334'),
(335,'test335'),
(336,'test336'),
(337,'test337'),
(338,'test338'),
(339,'test339'),
(340,'test340'),
(341,'test341'),
(342,'test342'),
(343,'test343'),
(344,'test344'),
(345,'test345'),
(346,'test346'),
(347,'test347'),
(348,'test348'),
(349,'test349'),
(350,'test350'),
(351,'test351'),
(352,'test352'),
(353,'test353'),
(354,'test354'),
(355,'test355'),
(356,'test356'),
(357,'test357'),
(358,'test358'),
(359,'test359'),
(360,'test360'),
(361,'test361'),
(362,'test362'),
(363,'test363'),
(364,'test364'),
(365,'test365'),
(366,'test366'),
(367,'test367'),
(368,'test368'),
(369,'test369'),
(370,'test370'),
(371,'test371'),
(372,'test372'),
(373,'test373'),
(374,'test374'),
(375,'test375'),
(376,'test376'),
(377,'test377'),
(378,'test378'),
(379,'test379'),
(380,'test380'),
(381,'test381'),
(382,'test382'),
(383,'test383'),
(384,'test384'),
(385,'test385'),
(386,'test386'),
(387,'test387'),
(388,'test388'),
(389,'test389'),
(390,'test390'),
(391,'test391'),
(392,'test392'),
(393,'test393'),
(394,'test394'),
(395,'test395'),
(396,'test396'),
(397,'test397'),
(398,'test398'),
(399,'test399'),
(400,'test400'),
(401,'test401'),
(402,'test402'),
(403,'test403'),
(404,'test404'),
(405,'test405'),
(406,'test406'),
(407,'test407'),
(408,'test408'),
(409,'test409'),
(410,'test410'),
(411,'test411'),
(412,'test412'),
(413,'test413'),
(414,'test414'),
(415,'test415'),
(416,'test416'),
(417,'test417'),
(418,'test418'),
(419,'test419'),
(420,'test420'),
(421,'test421'),
(422,'test422'),
(423,'test423'),
(424,'test424'),
(425,'test425'),
(426,'test426'),
(427,'test427'),
(428,'test428'),
(429,'test429'),
(430,'test430'),
(431,'test431'),
(432,'test432'),
(433,'test433'),
(434,'test434'),
(435,'test435'),
(436,'test436'),
(437,'test437'),
(438,'test438'),
(439,'test439'),
(440,'test440'),
(441,'test441'),
(442,'test442'),
(443,'test443'),
(444,'test444'),
(445,'test445'),
(446,'test446'),
(447,'test447'),
(448,'test448'),
(449,'test449'),
(450,'test450'),
(451,'test451'),
(452,'test452'),
(453,'test453'),
(454,'test454'),
(455,'test455'),
(456,'test456'),
(457,'test457'),
(458,'test458'),
(459,'test459'),
(460,'test460'),
(461,'test461'),
(462,'test462'),
(463,'test463'),
(464,'test464'),
(465,'test465'),
(466,'test466'),
(467,'test467'),
(468,'test468'),
(469,'test469'),
(470,'test470'),
(471,'test471'),
(472,'test472'),
(473,'test473'),
(474,'test474'),
(475,'test475'),
(476,'test476'),
(477,'test477'),
(478,'test478'),
(479,'test479'),
(480,'test480'),
(481,'test481'),
(482,'test482'),
(483,'test483'),
(484,'test484'),
(485,'test485'),
(486,'test486'),
(487,'test487'),
(488,'test488'),
(489,'test489'),
(490,'test490'),
(491,'test491'),
(492,'test492'),
(493,'test493'),
(494,'test494'),
(495,'test495'),
(496,'test496'),
(497,'test497'),
(498,'test498'),
(499,'test499'),
(500,'test500'),
(501,'test501'),
(502,'test502'),
(503,'test503'),
(504,'test504'),
(505,'test505'),
(506,'test506'),
(507,'test507'),
(508,'test508'),
(509,'test509'),
(510,'test510'),
(511,'test511'),
(512,'test512'),
(513,'test513'),
(514,'test514'),
(515,'test515'),
(516,'test516'),
(517,'test517'),
(518,'test518'),
(519,'test519'),
(520,'test520'),
(521,'test521'),
(522,'test522'),
(523,'test523'),
(524,'test524'),
(525,'test525'),
(526,'test526'),
(527,'test527'),
(528,'test528'),
(529,'test529'),
(530,'test530'),
(531,'test531'),
(532,'test532'),
(533,'test533'),
(534,'test534'),
(535,'test535'),
(536,'test536'),
(537,'test537'),
(538,'test538'),
(539,'test539'),
(540,'test540'),
(541,'test541'),
(542,'test542'),
(543,'test543'),
(544,'test544'),
(545,'test545'),
(546,'test546'),
(547,'test547'),
(548,'test548'),
(549,'test549'),
(550,'test550'),
(551,'test551'),
(552,'test552'),
(553,'test553'),
(554,'test554'),
(555,'test555'),
(556,'test556'),
(557,'test557'),
(558,'test558'),
(559,'test559'),
(560,'test560'),
(561,'test561'),
(562,'test562'),
(563,'test563'),
(564,'test564'),
(565,'test565'),
(566,'test566'),
(567,'test567'),
(568,'test568'),
(569,'test569'),
(570,'test570'),
(571,'test571'),
(572,'test572'),
(573,'test573'),
(574,'test574'),
(575,'test575'),
(576,'test576'),
(577,'test577'),
(578,'test578'),
(579,'test579'),
(580,'test580'),
(581,'test581'),
(582,'test582'),
(583,'test583'),
(584,'test584'),
(585,'test585'),
(586,'test586'),
(587,'test587'),
(588,'test588'),
(589,'test589'),
(590,'test590'),
(591,'test591'),
(592,'test592'),
(593,'test593'),
(594,'test594');

Answer 2

insert into account values
(595,'test595'),
(596,'test596'),
(597,'test597'),
(598,'test598'),
(599,'test599'),
(600,'test600'),
(601,'test601'),
(602,'test602'),
(603,'test603'),
(604,'test604'),
(605,'test605'),
(606,'test606'),
(607,'test607'),
(608,'test608'),
(609,'test609'),
(610,'test610'),
(611,'test611'),
(612,'test612'),
(613,'test613'),
(614,'test614'),
(615,'test615'),
(616,'test616'),
(617,'test617'),
(618,'test618'),
(619,'test619'),
(620,'test620'),
(621,'test621'),
(622,'test622'),
(623,'test623'),
(624,'test624'),
(625,'test625'),
(626,'test626'),
(627,'test627'),
(628,'test628'),
(629,'test629'),
(630,'test630'),
(631,'test631'),
(632,'test632'),
(633,'test633'),
(634,'test634'),
(635,'test635'),
(636,'test636'),
(637,'test637'),
(638,'test638'),
(639,'test639'),
(640,'test640'),
(641,'test641'),
(642,'test642'),
(643,'test643'),
(644,'test644'),
(645,'test645'),
(646,'test646'),
(647,'test647'),
(648,'test648'),
(649,'test649'),
(650,'test650'),
(651,'test651'),
(652,'test652'),
(653,'test653'),
(654,'test654'),
(655,'test655'),
(656,'test656'),
(657,'test657'),
(658,'test658'),
(659,'test659'),
(660,'test660'),
(661,'test661'),
(662,'test662'),
(663,'test663'),
(664,'test664'),
(665,'test665'),
(666,'test666'),
(667,'test667'),
(668,'test668'),
(669,'test669'),
(670,'test670'),
(671,'test671'),
(672,'test672'),
(673,'test673'),
(674,'test674'),
(675,'test675'),
(676,'test676'),
(677,'test677'),
(678,'test678'),
(679,'test679'),
(680,'test680'),
(681,'test681'),
(682,'test682'),
(683,'test683'),
(684,'test684'),
(685,'test685'),
(686,'test686'),
(687,'test687'),
(688,'test688'),
(689,'test689'),
(690,'test690'),
(691,'test691'),
(692,'test692'),
(693,'test693'),
(694,'test694'),
(695,'test695'),
(696,'test696'),
(697,'test697'),
(698,'test698'),
(699,'test699'),
(700,'test700'),
(701,'test701'),
(702,'test702'),
(703,'test703'),
(704,'test704'),
(705,'test705'),
(706,'test706'),
(707,'test707'),
(708,'test708'),
(709,'test709'),
(710,'test710'),
(711,'test711'),
(712,'test712'),
(713,'test713'),
(714,'test714'),
(715,'test715'),
(716,'test716'),
(717,'test717'),
(718,'test718'),
(719,'test719'),
(720,'test720'),
(721,'test721'),
(722,'test722'),
(723,'test723'),
(724,'test724'),
(725,'test725'),
(726,'test726'),
(727,'test727'),
(728,'test728'),
(729,'test729'),
(730,'test730'),
(731,'test731'),
(732,'test732'),
(733,'test733'),
(734,'test734'),
(735,'test735'),
(736,'test736'),
(737,'test737'),
(738,'test738'),
(739,'test739'),
(740,'test740'),
(741,'test741'),
(742,'test742'),
(743,'test743'),
(744,'test744'),
(745,'test745'),
(746,'test746'),
(747,'test747'),
(748,'test748'),
(749,'test749'),
(750,'test750'),
(751,'test751'),
(752,'test752'),
(753,'test753'),
(754,'test754'),
(755,'test755'),
(756,'test756'),
(757,'test757'),
(758,'test758'),
(759,'test759'),
(760,'test760'),
(761,'test761'),
(762,'test762'),
(763,'test763'),
(764,'test764'),
(765,'test765'),
(766,'test766'),
(767,'test767'),
(768,'test768'),
(769,'test769'),
(770,'test770'),
(771,'test771'),
(772,'test772'),
(773,'test773'),
(774,'test774'),
(775,'test775'),
(776,'test776'),
(777,'test777'),
(778,'test778'),
(779,'test779'),
(780,'test780'),
(781,'test781'),
(782,'test782'),
(783,'test783'),
(784,'test784'),
(785,'test785'),
(786,'test786'),
(787,'test787'),
(788,'test788'),
(789,'test789'),
(790,'test790'),
(791,'test791'),
(792,'test792'),
(793,'test793'),
(794,'test794'),
(795,'test795'),
(796,'test796'),
(797,'test797'),
(798,'test798'),
(799,'test799'),
(800,'test800'),
(801,'test801'),
(802,'test802'),
(803,'test803'),
(804,'test804'),
(805,'test805'),
(806,'test806'),
(807,'test807'),
(808,'test808'),
(809,'test809'),
(810,'test810'),
(811,'test811'),
(812,'test812'),
(813,'test813'),
(814,'test814'),
(815,'test815'),
(816,'test816'),
(817,'test817'),
(818,'test818'),
(819,'test819'),
(820,'test820'),
(821,'test821'),
(822,'test822'),
(823,'test823'),
(824,'test824'),
(825,'test825'),
(826,'test826'),
(827,'test827'),
(828,'test828'),
(829,'test829'),
(830,'test830'),
(831,'test831'),
(832,'test832'),
(833,'test833'),
(834,'test834'),
(835,'test835'),
(836,'test836'),
(837,'test837'),
(838,'test838'),
(839,'test839'),
(840,'test840'),
(841,'test841'),
(842,'test842'),
(843,'test843'),
(844,'test844'),
(845,'test845'),
(846,'test846'),
(847,'test847'),
(848,'test848'),
(849,'test849'),
(850,'test850'),
(851,'test851'),
(852,'test852'),
(853,'test853'),
(854,'test854'),
(855,'test855'),
(856,'test856'),
(857,'test857'),
(858,'test858'),
(859,'test859'),
(860,'test860'),
(861,'test861'),
(862,'test862'),
(863,'test863'),
(864,'test864'),
(865,'test865'),
(866,'test866'),
(867,'test867'),
(868,'test868'),
(869,'test869'),
(870,'test870'),
(871,'test871'),
(872,'test872'),
(873,'test873'),
(874,'test874'),
(875,'test875'),
(876,'test876'),
(877,'test877'),
(878,'test878'),
(879,'test879'),
(880,'test880'),
(881,'test881'),
(882,'test882'),
(883,'test883'),
(884,'test884'),
(885,'test885'),
(886,'test886'),
(887,'test887'),
(888,'test888'),
(889,'test889'),
(890,'test890'),
(891,'test891'),
(892,'test892'),
(893,'test893'),
(894,'test894'),
(895,'test895'),
(896,'test896'),
(897,'test897'),
(898,'test898'),
(899,'test899'),
(900,'test900'),
(901,'test901'),
(902,'test902'),
(903,'test903'),
(904,'test904'),
(905,'test905'),
(906,'test906'),
(907,'test907'),
(908,'test908'),
(909,'test909'),
(910,'test910'),
(911,'test911'),
(912,'test912'),
(913,'test913'),
(914,'test914'),
(915,'test915'),
(916,'test916'),
(917,'test917'),
(918,'test918'),
(919,'test919'),
(920,'test920'),
(921,'test921'),
(922,'test922'),
(923,'test923'),
(924,'test924'),
(925,'test925'),
(926,'test926'),
(927,'test927'),
(928,'test928'),
(929,'test929'),
(930,'test930'),
(931,'test931'),
(932,'test932'),
(933,'test933'),
(934,'test934'),
(935,'test935'),
(936,'test936'),
(937,'test937'),
(938,'test938'),
(939,'test939'),
(940,'test940'),
(941,'test941'),
(942,'test942'),
(943,'test943'),
(944,'test944'),
(945,'test945'),
(946,'test946'),
(947,'test947'),
(948,'test948'),
(949,'test949'),
(950,'test950'),
(951,'test951'),
(952,'test952'),
(953,'test953'),
(954,'test954'),
(955,'test955'),
(956,'test956'),
(957,'test957'),
(958,'test958'),
(959,'test959'),
(960,'test960'),
(961,'test961'),
(962,'test962'),
(963,'test963'),
(964,'test964'),
(965,'test965'),
(966,'test966'),
(967,'test967'),
(968,'test968'),
(969,'test969'),
(970,'test970'),
(971,'test971'),
(972,'test972'),
(973,'test973'),
(974,'test974'),
(975,'test975'),
(976,'test976'),
(977,'test977'),
(978,'test978'),
(979,'test979'),
(980,'test980'),
(981,'test981'),
(982,'test982'),
(983,'test983'),
(984,'test984'),
(985,'test985'),
(986,'test986'),
(987,'test987'),
(988,'test988'),
(989,'test989'),
(990,'test990'),
(991,'test991'),
(992,'test992'),
(993,'test993'),
(994,'test994'),
(995,'test995'),
(996,'test996'),
(997,'test997'),
(998,'test998'),
(999,'test999'),
(1000,'test1000');

Answer 3

EXCEL中生成以上数据仅需要2分钟。