MySQLdb Error

[Emeka]

Thanks.

Regards,
Janus

On Wed, Jan 11, 2012 at 7:12 PM, Dennis Lee Bieber <wlfraed at ix.netcom.com>wrote:

> On Wed, 11 Jan 2012 09:57:43 +0200, Emeka <emekamicro at gmail.com> wrote:
>
>
> >_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL
> >syntax; check the manual that corresponds to your MySQL server version for
> >the right syntax to use near '  street_number int,  country_name varchar,
> > street_name char(40) , user_name ch' at line 1")
> >*
> >
>
>        Per http://dev.mysql.com/doc/refman/5.1/en/create-table.html and
> http://dev.mysql.com/doc/refman/5.1/en/char.html VARCHAR fields
> /require/ the maximum length of the field to be defined. Length appears
> optional for CHAR -- probably defaulting to 1 character.
> --
>        Wulfraed                 Dennis Lee Bieber         AF6VN
>        wlfraed at ix.netcom.com    HTTP://wlfraed.home.netcom.com/
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>



-- 
*Satajanus  Nig. Ltd


*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20120111/4a953ce6/attachment-0001.html>