Guest Posted February 14, 2003 Share Posted February 14, 2003 Hi, Can't seem to get past the sable changes bit. products_head_title_tag varchar 50 goes in fine, but the next 2:- products_head_desc_tag longtext 300 products_head_keywords_tag longtext 300 both come up with :- ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT (300) not null MySQL said: You have an error in your SQL syntax near '(300) not null ' at line 1 Any idea what I'm doing wrong? regards len Link to comment Share on other sites More sharing options...
Kent C Posted February 15, 2003 Share Posted February 15, 2003 Ref: http://www.mysql.com/doc/en/BLOB.html I remember that I also had problems since MySQL-Front wouldn't let me do this. I eventually created the 2 fields as lontext not null I did not find any references that stated that I could not specify the field length. HTH Link to comment Share on other sites More sharing options...
Guest Posted February 15, 2003 Share Posted February 15, 2003 hi kent, thanks a lot, will give it a try regards len Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.