[thelist] MySQL - multiple insert queries on the same line?
Canfield, Joel
JCanfield at PacAdvantage.org
Fri Jun 9 18:28:59 CDT 2006
our phone system exports its backup of the call records with each table
like this:
INSERT INTO `acdgroup` VALUES
(-1585203793663993506,'Voice.Mail','1050',1),(-1585203794846805934,'CSD'
,'1001',10),(-1585203795369082352,'DefaultAA','201',2),(-158520379340556
8896,'Test_Queue','1010',10),(-1585203795083014178,'Cobra','1004',10),(-
1585203795319765793,'Requal','1007',10),(-1585203794922340506,'test123',
'1010',10),(-1585203793301737617,'Quotes(BSU)','1002',10),(-158520379408
6479285,'AccountManagers(BSU)','1011',3),(-1585203794267004170,'Complian
ceOverflow','1012',3),(-1585203793522005390,'PlusProductsInc.','901',2);
that's one 'insert into [tablename] values (group of values), (another
group of values)
etc. all on one line.
when I run this as a query in the MySQL query GUI, it only inserts the
first record.
which is normal behaviour? I'm used to one 'insert into tablename values
(stuff to insert)' for each insert.
I'm confused, or the backup part of this phone software is misbehaving.
eh?
thanks
joel
More information about the thelist
mailing list