--- Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Sujay Koduri wrote:
> > You havent specified the datatype for the column 'id'.
>
> Right, this should be fatal.
> But I also take issue with other parts:
>
> >
> > CREATE TABLE users (
> > id PRIMARY KEY,
> > priority integer NOT NULL DEFAULT '7',
> > policy_id integer unsigned NOT NULL DEFAULT '1',
>
> Even though this may work, it is wrong IMNSHO:
> You set character strings as default values for numeric columns!
> Your strings consist of digits only, so they can (and will) be
> converted
> to numbers, but IMO you should not make use of that.
I don't understand. I have integer there. Where is character strings?
__________________________________________________________
Find your next car at http://autos.yahoo.ca
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
