Unable to insert values into a table using MySQL in Python -

-

i want update table values created in python script in mysql database. here line problem:

dbcursor.execute("insert solution (problemname, tourlength, date, author, algorithm, runningtime, tour) values ('%s', '%d', '%s', '%s', '%s', '%d', '%s')" % (sys.argv[1], bestdist, "foo bar", "curdate()", "greedy + 2-opt", timeallowed, bestroute)) dbconnection.commit()

it generating error: 

pymysql.err.internalerror: (1136, "column count doesn't match value count @ row 1")

i've tried googling problem , searching website solution, none of ones i've found match mine. fixes have not solved problem because of this. not sure can @ point. can see, of column names match values , formatted variables.

what causing problem?

create table if not exists solution (   solutionid int(11) not null auto_increment,   problemname varchar(32) not null,   tourlength double not null,   date date default null,   author varchar(32) default null,   algorithm varchar(32) default null,   runningtime int(11) default null,   tour mediumtext not null,   constraint spk primary key (solutionid),   constraint solpname foreign key (problemname) references problem (name) on delete cascade );

the problem in formatting sql query % operator. in particular, need escape parameters , curdate() shouldn't quoted.

that said, it's better rely on db driver interpolate query parameters. that, pass them tuple cursor.execute() this:

sql = (     "insert solution (problemname, tourlength, date, author, algorithm, "     " runningtime, tour) values (%s, %s, curdate(), %s, %s, %s, %s)") print(sql) dbcursor.execute(sql, (sys.argv[1], bestdist, "foo bar", "greedy + 2-opt",                        timeallowed, bestroute))

Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more