我需要在mysql数据库的一个表中插入大约500-1000行
INSERT INTO `jtbillingtest`.`at_user`
(`clientGuid`,
`clientFirstName`,
`clientMiddleName`,
`clientLastName`,
`gender`,
`clientAddress`,
`clientMobileNumber`,
`clientEmailID`,
`clientTypeCode`,
`active`)
VALUES
(
<{clientGuid: }>,
<{clientFirstName: }>,
<{clientMiddleName: }>,
<{clientLastName: }>,
<{gender: }>,
<{clientAddress: }>,
<{clientMobileNumber: }>,
<{clientEmailID: }>,
<{clientTypeCode: }>,
<{active: Yes}>
);
我的桌子结构是
CREATE TABLE `at_user` (
`clientGuid` int(11) NOT NULL AUTO_INCREMENT,
`clientFirstName` varchar(45) DEFAULT NULL,
`clientMiddleName` varchar(45) DEFAULT NULL,
`clientLastName` varchar(45) DEFAULT NULL,
`gender` varchar(10) DEFAULT NULL,
`clientAddress` varchar(45) DEFAULT NULL,
`clientMobileNumber` varchar(45) NOT NULL,
`clientEmailID` varchar(45) DEFAULT NULL,
`clientTypeCode` varchar(2) DEFAULT NULL COMMENT 'Client Type code will determine whether it is a sales customer ,purchase customer ,employee or store owner.',
`active` varchar(45) NOT NULL DEFAULT 'Yes',
PRIMARY KEY (`clientGuid`),
UNIQUE KEY `UK_CLIENTMNILENUMBER` (`clientMobileNumber`),
UNIQUE KEY `clientGuid_UNIQUE` (`clientGuid`),
UNIQUE KEY `UK_CLIENTEMAILID` (`clientEmailID`),
KEY `IX_CLIENTGUID` (`clientGuid`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='THis Table is used to store the user details'$$
请有人能帮助我插入这些行使用任何脚本或任何其他更简单的方式?
最佳答案
请尝试使用以下链接,它将帮助您:
http://www.electrictoolbox.com/mysql-insert-multiple-records/
INSERT INTO example
(example_id, name, value, other_value)
VALUES
(100, 'Name 1', 'Value 1', 'Other 1'),
(101, 'Name 2', 'Value 2', 'Other 2'),
(102, 'Name 3', 'Value 3', 'Other 3'),
(103, 'Name 4', 'Value 4', 'Other 4');
关于php - 需要任何脚本/技术在mysql表中插入多行,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/19081806/