problem enterin field in DB

[popcop]

im tryin to add a image field in my table through PHPMYADMIN

THIS IS THE QUERY

ALTER TABLE 'test' ADD 'image' LONGBLOB BINARY NOT NULL AFTER story

Can you see anything wrong with it ???

[ZibingsCoder]

Should be:

ALTER TABLE test ADD image...

You can't use quotes on field names, it has to be the lil doohickey under the tilde.

[popcop]

im gettin this now

Error

SQL-query :

ALTER TABLE test ADD image LONGBLOB BINARY NOT NULL AFTER story

[ZibingsCoder]

Heh...my bad! Take out the "BINARY" part and it'll work. A "blob" field is already binary data.