Quote Originally Posted by joeyramirez View Post
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);