Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #18838
| From | Dennis Lee Bieber <wlfraed@ix.netcom.com> |
|---|---|
| Subject | Re: MySQLdb Error |
| Date | 2012-01-11 12:12 -0500 |
| References | <CAOypoo7R8WZRg=oT0x2M2q4mQejYLqzUCYcsThCou2h+zXByGg@mail.gmail.com> |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.4656.1326302114.27778.python-list@python.org> (permalink) |
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/
Back to comp.lang.python | Previous | Next | Find similar | Unroll thread
Re: MySQLdb Error Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-01-11 12:12 -0500
csiph-web