PDA

View Full Version : MySQL Version?


gference
12-9-08, 11:59 PM
Can anyone tell me what the exact version the MySQL server is? I am trying to use the 'bit' data type but it is not show as an option when creating tables. The 'bit' data type became available in version 5.0.3. Nevermind, I just found it. It is 5.0.45. Now that leads me to a new question. How can you select the 'bit' data type in phpMyAdmin?

gference
12-10-08, 12:19 AM
I solved my own problem. Click the SQL tab to run an SQL query and use the following command. ALTER TABLE table_name MODIFY column_name BIT(64). This defines the column to a 64 bit data type. Bit data type can be 1 to 64 bits.