How to merge these 2 sql inserts?
Posted: Tue Jul 15, 2003 6:02 am
Hi all
i'm almost done building my polyphonic ringtone scripts
i only got 1 problem left
i build my script in these mysql inserts:
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100001,'Xavier Naidoo','Bevor Du Gehst',254,'2002-10-31');
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100002,'10cc','Dreadlock Holiday',252,'2002-11-7');
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100003,'Ace Of Base','All That She Wants',269,'2002-11-7');
Now i got to import an other sponsor that uses difrend tables
like this
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80414,'007 - You only live twice','2002-11-01',0,1);
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80634,'2 Unlimited - Get ready for this','2003-04-16',-178,9);
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80635,'2 Unlimited - No limits','2003-04-16',-934,9);
the name and description should be seperated the rest is ok
i got to see the type of ringtone in my admin
the first inserts are MM and the second Ringtonio
How can u make a import file that converts this to the right tables?
i'm almost done building my polyphonic ringtone scripts
i only got 1 problem left
i build my script in these mysql inserts:
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100001,'Xavier Naidoo','Bevor Du Gehst',254,'2002-10-31');
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100002,'10cc','Dreadlock Holiday',252,'2002-11-7');
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100003,'Ace Of Base','All That She Wants',269,'2002-11-7');
Now i got to import an other sponsor that uses difrend tables
like this
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80414,'007 - You only live twice','2002-11-01',0,1);
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80634,'2 Unlimited - Get ready for this','2003-04-16',-178,9);
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80635,'2 Unlimited - No limits','2003-04-16',-934,9);
the name and description should be seperated the rest is ok
i got to see the type of ringtone in my admin
the first inserts are MM and the second Ringtonio
How can u make a import file that converts this to the right tables?