Originally Posted by joeyramirez
How do I split this values 1, 3, 4, 5 to be inserted like INSERT INTO tbltest (pid) VALUES ('1),('3'),('4'),('5');
If the data is string data then the VALUES should have single quotes (') around them (the first one is missing its end quote).
If the data is numeric it should not have quotes around it: INSERT INTO tbltest (pid) VALUES (1),(3),(4),(5);
Andrew Wasson | www.lunadesign.org
Principal / Internet Development