Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #18838 > unrolled thread

Re: MySQLdb Error

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: MySQLdb Error Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-01-11 12:12 -0500

#18838 — Re: MySQLdb Error

On Wed, 11 Jan 2012 09:57:43 +0200, Emeka <emekamicro@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@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web