Re: MySql
- From: "John Machin" <sjmachin@xxxxxxxxxxx>
- Date: 27 Jul 2006 01:12:01 -0700
mik...@xxxxxxxxxxxxxxx wrote:
John Machin wrote:
miker2@xxxxxxxxxxxxxxx wrote:
HI,
I'm having trouble writing to a MySql db using python and the MySQLdb
module. Here is the code:
import MySQLdb
base = MySQLdb.connect(host="localhost", user="blah", passwd="blah",
db="test_py")
cursor = base.cursor()
cursor.execute("INSERT INTO table (field) VALUES (int)")
I've never used MySQL but they're all much the same --
"table" is a reserved word. What is "int" supposed to be? That's not
valid SQL AFAIK. Is that exactly what you typed? Or are you coyly
obfuscating?
Try this:
cursor.execute("INSERT INTO tablename (fieldname) VALUES (42)")
or better,
somevar = 42
cursor.execute("INSERT INTO tablename (fieldname) VALUES (?)",
(somevar,))
even better, read the docs and look at the examples :-)
this does not work
... and the error message was ... what? If it's not a state secret, how
about divulging it?
but the interesting thing is, there is an
AUTO_INCREMENT
field. Now say i had a couple of entries in there already:
auto table
1 | 90
2 | 32
and then i run my py script 3 times, the data is not entered but if i
add
another entry from mysql the auto increment field will have counted the
python entries:
auto table
1 | 90
2 | 32
6 | 47
Evidently it's committed the auto increment before it decides that it
doesn't like your SQL or whatever. Read the warranty card that came
with the autoincrementer gizmoid; you won't find "continuous" or "no
gaps" mentioned anywhere.
please tell me what i am doing wrong.
Inter alia, not giving enough clear unambiguous info about what your
problem really is.
Cheers,
John
sorry guys...
forget about the auto incrementer for a second.
the entry is not being recorded. that is my problem. the script does
not work. thanks.
OK we've forgotten about the auto incrementer.
Now tell us what "does not work" means.
Show us an actual suitably-cut down script that "does not work".
If you get an error message, tell us what the error message was.
If you didn't get an error message, bloody well tell us that you
didn't.
BTW, if the script doesn't contain
base.commit()
somewhere, take yourself out to the back lane and give yourself a good
thumping :-)
Then come back in and read the docs about transactions and commit and
autocommit etc.
HTH,
John
.
- Follow-Ups:
- Re: MySql
- From: Sibylle Koczian
- Re: MySql
- Prev by Date: Re: Newbie Q: Class Privacy (or lack of)
- Next by Date: Re: MySql
- Previous by thread: Re: MySql
- Next by thread: Re: MySql
- Index(es):
Relevant Pages
|
