query " ALTER TABLE test_posts ADD sticky boolean NOT NULL default = false" = error

sql mysql alter-table
William picture William · Mar 14, 2010 · Viewed 27.1k times · Source

Whats wrong with my query?

 ALTER TABLE test_posts ADD sticky boolean NOT NULL default = false

#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 '=false' at line 2

Answer

Phil Ross picture Phil Ross · Mar 14, 2010

You need to remove the =:

ALTER TABLE test_posts ADD sticky boolean NOT NULL default false

Related questions

Alter a MySQL column to be AUTO_INCREMENT

I’m trying to modify a table to make its primary key column AUTO_INCREMENT after the fact. I have tried the following SQL, but got a syntax error notification. ALTER TABLE document ALTER COLUMN document_id AUTO_INCREMENT Am …

Read More
ALTER TABLE to add a composite primary key

I have a table called provider. I have three columns called person, place, thing. There can be duplicate persons, duplicate places, and duplicate things, but there can never be a dupicate person-place-thing combination. How would I ALTER TABLE to add …

Read More
ALTER table - adding AUTOINCREMENT in MySQL

I created a table in MySQL with on column itemID. After creating the table, now I want to change this column to AUTOINCREMENT. How can this be done using ALTER statements? Table definition: ALLITEMS (itemid int(10) unsigned, itemname varchar(50)) I …

Read More