Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
kendall
- Forum Regular
- Posts: 852
- Joined: Tue Jul 30, 2002 10:21 am
- Location: Trinidad, West Indies
-
Contact:
Post
by kendall »
Hello,
i am trying to create a table with a
Code: Select all
ALTER TABLE online_classifieds MODIFY Description blob(65535) NOT NULL
is there any reason why i would get a
You have an error in your SQL syntax near '(65535) NOT NULL ' at line 1
Kendall
-
twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Post
by twigletmac »
Try running the change without the size definition for the blob, IIRC, that is not needed for BLOBs.
Mac
-
kendall
- Forum Regular
- Posts: 852
- Joined: Tue Jul 30, 2002 10:21 am
- Location: Trinidad, West Indies
-
Contact:
Post
by kendall »
Twiglet,
I did that as well too and it got a syntax saying i need to specify a length
Kendall
-
twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Post
by twigletmac »
That's really strange, I ran a test on a table of my own just to check and
Code: Select all
ALTER TABLE results_answers MODIFY question_id blob NOT NULL
worked fine, however,
Code: Select all
ALTER TABLE results_answers MODIFY question_id blob(65535) NOT NULL
gave the same error you initially posted.
Mac