How to change multiple columns to enum

[cinci_hal]

I imported an MS Access database table to phpMyAdmin and several of the table columns are INT. I want to change them to enum('0','1') with default of 0. I am new to phpMyAdmin and was wondering if there is a way to change them all at once?

[Altrea]

Hi cinci_hal (there is ALWAYS time for a short salutation. You are asking for help here on a community board and therefor it would be very polite to start with a hello),

I want to change them to enum('0','1') with default of 0.

For boolean values i would choose the column type Bit(1) or maybe Tinyint(1), but not Enum.

I am new to phpMyAdmin and was wondering if there is a way to change them all at once?

With phpmyadmin you can change the structure of a full data table.
To change all columns you have to write your orn custom SQL query.

best wishes,
Altrea

[cinci_hal]

Thanks for the welcome!

I have tried to write a query with no possitive results. I should have mentioned that I am also new to sql. I have been googling and I think I am close to figuring it out, but just need a little bit of help. 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.

If I could get some addition help on this it would be much appreciated.

[Altrea]

Thanks for the welcome!

That wasn't just a hello from me to you but also a hint that YOU should start a new thread with a salutation.

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.

No, UPDATE table is not the syntax you need.
What you need is ALTER table

best wishes,
Altrea