[Zope-DB] data type problems ZMySQLDA
Sun, 30 Mar 2003 13:22:58 +0100
You may also have a problem with the column name date since thats also a
reserved word in mysql. You might get away with it but you'll probably have
other problems later.
I tend to use datetime columns as well since they are easier to read from
the db itself (no extra formatting required).
----- Original Message -----
From: "Michele Marcionelli" <email@example.com>
To: "Josiah Peters" <firstname.lastname@example.org>; <email@example.com>
Sent: Saturday, March 29, 2003 11:33 PM
Subject: Re: [Zope-DB] data type problems ZMySQLDA
> Hello Joey!
> The correct syntax is:
> CREATE TABLE ezine_news (
> author varchar(x),
> name varchar(x),
> content text,
> date timestamp
> where "x" is the maximal length of the value, in this case "author" and
> "name", usually x=255. I think that x can be an integer from 1 to 255.
> ----- Original Message -----
> From: "Josiah Peters" <firstname.lastname@example.org>
> To: <email@example.com>
> Sent: Saturday, March 29, 2003 5:13 PM
> Subject: [Zope-DB] data type problems ZMySQLDA
> > I have been searching around and have not been able to find any
> > information on ZmysqlDA. For some reason when i enter the query:
> > CREATE TABLE ezine_news
> > (
> > author varchar,
> > name varchar,
> > content text,
> > date timestamp,
> > )
> > it will not accept it as a legal query making me unable to finish my
> > database stuff. Since I only have experience with MySQL and those
> > do not seem to be working.
> > thanks in advance.
> > Joey Peters
> > _________________________________________________________________
> > Add photos to your messages with MSN 8. Get 2 months FREE*.
> > http://join.msn.com/?page=features/featuredemail
> > _______________________________________________
> > Zope-DB mailing list
> > Zope-DB@zope.org
> > http://mail.zope.org/mailman/listinfo/zope-db
> Zope-DB mailing list