what's a better way to write this, inserting 250 id...?
i have to populate a table with 250 product ids, which are simply integers,
i just did this query which works....
"insert into products_addl_data (products_id) values (6), (7), (8), (9), (10)";
but that's just plain silly,..!,
i tried using keyword IN but i think that only for WHERE clause
also, i know i could loop in PHP but just wondering what the SQL would be.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)