Article View: pl.comp.lang.python
Article #27138Re: Python i MySQL BLOB
From: Daniel Mróz
Date: Tue, 05 Jan 2010 16:00
Date: Tue, 05 Jan 2010 16:00
21 lines
1594 bytes
1594 bytes
On 05.01.2010, królewna <krolewna@ee.pl> wrote:
>> pick = pickle.dumps("alamakota")
>> cur.execute("INSERT INTO test VALUES(10, %s, 3);", (pick,))
> A gdybym chciała zrobić coś w stylu:
>
> cur.execute("INSERT INTO %s VALUES(10, %s, 3);", (nazwa_tabeli,pick))
>
> to ten sposób znowu zawodzi i pojawia się błąd podobny do poprzedniego.
cur.execute("""INSERT INTO %s VALUES(10, %%s, 3)""" % nazwa_tabeli, (pick,))
nie zadziała?
Pozdrawiam
Beorn
--
Daniel 'Beorn' Mróz <beorn@alpha.pl> http://127.0.0.1/beorn
[GIT d s:- a-@ C++++ UL++++$ P+ L++++ E--- W+ N+++ o? K- w---]
[O- M- V! PS+ PE++ Y+ PGP++ t- 5 X R !tv b+ DI D++ G++ e h*]
[ r++ y+ ]
Technical Details
Message-ID:
<slrnhk6q4e.6d2.beorn@pino.cyberdeck.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!newsfeed.atman.pl!not-for-mailReferences:
<hhvlil$cso$1@achot.icm.edu.pl> <e40b5499-a692-4d1d-bd6d-8dd80f5ae900@c3g2000yqd.googlegroups.com> <hhvp29$gld$1@achot.icm.edu.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!newsfeed.atman.pl!not-for-mail From: Daniel Mróz <beorn@alpha.pl> Newsgroups: pl.comp.lang.python Subject: Re: Python i MySQL BLOB Date: Tue, 5 Jan 2010 16:00:40 +0000 (UTC) Organization: A tak se walimy młotkami d:-/ Lines: 21 Message-ID: <slrnhk6q4e.6d2.beorn@pino.cyberdeck.pl> References: <hhvlil$cso$1@achot.icm.edu.pl> <e40b5499-a692-4d1d-bd6d-8dd80f5ae900@c3g2000yqd.googlegroups.com> <hhvp29$gld$1@achot.icm.edu.pl> NNTP-Posting-Host: fw2.itvp.pl Mime-Version: 1.0 X-Trace: node1.news.atman.pl 1262707240 32049 217.17.39.4 (5 Jan 2010 16:00:40 GMT) X-Complaints-To: usenet@atman.pl NNTP-Posting-Date: Tue, 5 Jan 2010 16:00:40 +0000 (UTC) User-Agent: slrn/0.9.8.1pl2.1 (Linux) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit