|
-
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
IN (6,7,8,9,10,11)
also, i know i could loop in PHP but just wondering what the SQL would be.
thanks!
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Bookmarks