Adding set values in mySql database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cgildenhuys
Forum Newbie
Posts: 8
Joined: Fri Feb 21, 2003 3:10 am

Adding set values in mySql database

Post by cgildenhuys »

I'm using phpAdmin and would like to know if there is an easier way to add many values to a table column that has the SET type. I'm here referring to the setup of my SET column not the actual values for each entry.
For example one entry can have many images. All the possible images get referanced by their ids and put in a SET column. But there are potentially hundreds of images in the my image table and I don't want to have to manually type in all the ids when I set up the table. Since phpAdmin seems to be very strict about how to add this I was wondering if there is not a mySql command that can input the values of a SET type column using something like "everthing between 0 to 1000" when creating the table.

thanks
Post Reply