Jump to content

MYSQL BOOL TYPE


Foser

Recommended Posts

Im trying to make a setion in my table, true or false, but when i try to make it i get an error.

 

this is what i do and the mistake they say i did. not totaly sure what it means, im using phpmyadmin:

SQL query:

ALTER TABLE `user_info` CHANGE `active` `active` BOOL( 5 ) NOT NULL

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(5) NOT NULL' at line 1 

 

 

thanks

Link to comment
https://forums.phpfreaks.com/topic/57705-mysql-bool-type/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.