[RESOLVED] MySQL what am I doing wrong?

Smeep

Take a look at this image

http://img.photobucket.com/albums/v463/Smeep/error.gif

and tell me what I'm doing stupidly wrong. Been a while now since I messed with databases, but moving of host brings much updateyness!

Drakla

a) You're not asking a question that anyone can make any sense of

b) You still might consider mysql to be a database topic, so that database section would be good for that.

rincewind456

You can't have a field length of more than 255 chars for INT fields

Smeep

Drakla wrote:
a) You're not asking a question that anyone can make any sense of

b) You still might consider mysql to be a database topic, so that database section would be good for that.

A) Fine, if you look at exibit A, the picture, you'll see that there is an error when trying to creat the table. How do I get rid of that error so that I can create that table?

😎 I'm a newbie, and this is the newbie section. It works. If someone wants it in the Databases section (IE a Mod) they can move it as they see fit. I have no problem with that. I just didn't want to go in to the Database section spouting out newb questions is all.

And I tried setting a smaller amount of charachters for the ID - but get the same error anyways 🙁

rincewind456

Well apart from changing the DATETIME default to "0000-00-00 00:00:00" and the id field length to 255, I can't see any reason why you can't create the table, I did, here is the sql

CREATE TABLE test (
  title varchar(100) NOT NULL,
  author varchar(100) NOT NULL,
  `text` blob NOT NULL,
  id int(255) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

You will also need to take into account that "text" and "date" are reserved words in mysql, so you will need to enclose them in backticks when building queries.

Smeep

Problem was that I had length values in the "blob" and "date" type fields.

Thanks for the help.

Will mark resolved.