cinci_hal wrote:I want to change them to enum('0','1') with default of 0.
cinci_hal wrote:I am new to phpMyAdmin and was wondering if there is a way to change them all at once?
cinci_hal wrote:Thanks for the welcome!
cinci_hal wrote:I think the query will look something like this:[
UPDATE project_type SET Type = enum('0','1') Default = 0
WHERE record_id = `COL 5`, `COL 6`, etc.
Users browsing this forum: No registered users and 3 guests