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>
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

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/