mysql woe

mysql> alter table users add column admin BOOL DEFAULT false;

ERROR 1064 (42000): 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 ‘admin BOOL DEFAULT false’ at line 1

mysql> alter table users add column admin BOOL;

 

meant “in mysql 8 admin is now a reserved keyword” 😐

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.