MySQLDb Insert Syntax

MySQL database connector for Python programming

Brought to you by: adustman

MySQLDb Insert Syntax

Forum: Help

Creator: cmnorton

Created: 2010-03-03

Updated: 2012-09-19

cmnorton - 2010-03-03

What is the syntax for a single row insert?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Andy Dustman - 2010-03-03

Same as for any other SQL database.

http://dev.mysql.com/doc/refman/5.0/en/insert.html

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

cmnorton - 2010-03-03

What is the syntax for building an INSERT command using MySQLDB. All that's in
the documentation is multi-row. I'm looking for examples of single row
inserts.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Andy Dustman - 2010-03-03

Just use cursor.execute(your_insert_query, tuple_of parameters)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

cmnorton - 2010-03-03

Thanks for confirming I'm using the correct syntax.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.