How to create multiple mysql tables with MySQLdb in python?

Question

This is what i am trying to do:

cursor.execute("CREATE DATABASE testing")
cursor.execute("USE testing")
cursor.execute("CREATE TABLE Contract(mEnd varchar(7))")    
cursor.execute("CREATE TABLE User(uName varchar(15)")

When I run the python script using MySQLdb it only creates the first table and it ignores all the other lines of code.

iced · Accepted Answer · 2015-03-15 22:17:25Z

1

) is missing in your last statement. Though you really don't want to do it this way.

answered Mar 15, 2015 at 22:17

iced

1,5828 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

alecxe Over a year ago

If this is the reason, why Contract is not being created according to the OP?

lostprophet1 Over a year ago

@iced what would be a better approach?

iced Over a year ago

"but when I run the python script it only creates the first table and it ignores all the other lines of code." (c) (tm). and yes, this is the reason. As mysql isn't real database, virtually all libs are configuring autocommit by default.

iced Over a year ago

seems dead. well, anyway, statement's true - pick up any migration framework you fancy and use it.

alecxe Over a year ago

FYI, south is there specifically for django projects and it became a base for the Django migration framework introduced in 1.7 - which is why it is dying.

|

Minjun Kim · Accepted Answer · 2016-06-20 23:19:54Z

0

Try the following

execute = ["CREATE DATABASE testing","USE testing","CREATE TABLE Contract(mEnd varchar(7))","CREATE TABLE User(uName varchar(15))"]
for i in execute:
    cussor.execute(i)
    cussor.commit()

answered Jun 20, 2016 at 23:19

Minjun Kim

291 silver badge9 bronze badges

Collectives™ on Stack Overflow

How to create multiple mysql tables with MySQLdb in python?

2 Answers 2

6 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Related