Re: MySQLdb Error

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsreader4.netcologne.de!news.netcologne.de!xlned.com!feeder5.xlned.com!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<python-python-list@m.gmane.org>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.000
X-Spam-Evidence	'H': 1.00; 'S': 0.00; 'subject:Error': 0.05; 'char': 0.07; 'corresponds': 0.09; 'defined.': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:80.91.229.12': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'received:lo.gmane.org': 0.09; 'bieber': 0.16; 'defaulting': 0.16; 'email addr:ix.netcom.com': 0.16; 'email name:wlfraed': 0.16; 'from:addr:ix.netcom.com': 0.16; 'from:addr:wlfraed': 0.16; 'from:name:dennis lee bieber': 0.16; 'message-id:@4ax.com': 0.16; 'received:wlfraed': 0.16; 'url:netcom': 0.16; 'url:wlfraed': 0.16; 'wulfraed': 0.16; 'syntax': 0.16; 'wed,': 0.17; 'wrote:': 0.18; 'jan': 0.19; 'appears': 0.19; 'url:home': 0.21; '>the': 0.23; 'int,': 0.23; 'optional': 0.23; 'received:166': 0.23; 'url:dev': 0.23; 'url:doc': 0.25; 'lee': 0.28; 'error': 0.29; 'server': 0.30; '+0200,': 0.30; 'character.': 0.30; 'skip:> 30': 0.30; 'version': 0.32; 'header:X-Complaints-To:1': 0.33; 'to:addr:python-list': 0.34; 'probably': 0.34; 'charset:us-ascii': 0.37; '"you': 0.37; 'received:org': 0.38; 'url:en': 0.39; 'to:addr:python.org': 0.40; 'your': 0.61; 'url:5': 0.63; 'maximum': 0.66; '2012': 0.67; 'dennis': 0.73
X-Injected-Via-Gmane	http://gmane.org/
To	python-list@python.org
From	Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject	Re: MySQLdb Error
Date	Wed, 11 Jan 2012 12:12:45 -0500
References	<CAOypoo7R8WZRg=oT0x2M2q4mQejYLqzUCYcsThCou2h+zXByGg@mail.gmail.com>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
X-Gmane-NNTP-Posting-Host	mobile-166-147-101-182.mycingular.net
X-Newsreader	Forte Agent 6.00/32.1186
X-No-Archive	YES
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.12
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.4656.1326302114.27778.python-list@python.org> (permalink)
Lines	18
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1326302114 news.xs4all.nl 6951 [2001:888:2000:d::a6]:42499
X-Complaints-To	abuse@xs4all.nl
Xref	x330-a1.tempe.blueboxinc.net comp.lang.python:18838

Show key headers only | View raw

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

Thread

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

csiph-web