CREATE TABLE user (
id INT NOT NULL,
video_id INT NOT NULL,
KEY(id));
CREATE TABLE videos (
id INT NOT NULL,
name varchar(100) NOT NULL DEFAULT '',
KEY(id))

with connection.cursor() as cursor:
    for statement in script.split(';'):
        if len(statement) > 0:
             cursor.execute(statement + ';')

textfield varchar(255) default 'yes;no;undefined'

If multi is set to True, execute() is able to execute multiple statements specified in the operation string. It returns an iterator that enables processing the result of each statement. However, using parameters does not work well in this case, and it is usually a good idea to execute each statement on its own.