Page 1 of 1

Adding set values in mySql database

Posted: Mon Mar 24, 2003 1:28 am
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