mysql and changing data
I want to be able to change information on a table without having to do it one at a time. There are about 300+ records I need to change and don't know what would be the best way to do this.
The records consist of binary files as well as other info.
Here is a sample structure:
ID
Uploaded
Downloaded
FileSize
FileMD5
FileData
FileType
AddToGallery
KeepAround
Width
Height
Seen
Currently KeepAround is set at 0 (zero) which means at a given time the file will automatically be removed from the database. What I want to do is change this table to 1 for all the records.
I know I can do this one at a time via phpmyadmin but this will take forever. If I download the .sql file, its will show the binary characters of each file and will not work. (tried this already)
Is there a method to do this?
