How to correct the following error?

Question

0.00/5 (No votes)

See more:

File "<ipython-input-16-fbff936e9c99>", line 37
sql_create_projects_table = CREATE TABLE IF NOT EXISTS ACTOR {
^
SyntaxError: invalid syntax

when I write:

sql_create_projects_table = CREATE TABLE IF NOT EXISTS ACTOR {
                                    aid integer PRIMARY KEY,
                                    fname text NOT NULL,
                                    lname text NOT NULL,
                                    gender text NOT NULL
                                };


sql_create_tasks_table = CREATE TABLE IF NOT EXISTS ACTOR {
                                aid integer PRIMARY KEY,
                                fname text NOT NULL,
                                priority integer,
                                "status_id integer NOT NULL,
                                "project_id integer NOT NULL,
                                lname text NOT NULL,
                                gender text NOT NULL
                                "FOREIGN KEY (project_id) REFERENCES projects (id)
                                };

What I have tried:

I have tried a lot to correct this error
When I write:

sql_create_projects_table = """CREATE TABLE IF NOT EXISTS ACTOR {
                                    aid integer PRIMARY KEY,
                                    fname text NOT NULL,
                                    lname text NOT NULL,
                                    gender text NOT NULL
                                };"""


sql_create_tasks_table = """CREATE TABLE IF NOT EXISTS ACTOR {
                                aid integer PRIMARY KEY,
                                fname text NOT NULL,
                                priority integer,
                                "status_id integer NOT NULL,
                                "project_id integer NOT NULL,
                                lname text NOT NULL,
                                gender text NOT NULL
                                "FOREIGN KEY (project_id) REFERENCES projects (id)
                                };"""

everything remains fine but """ means comments and no table generated in the db file.

Posted 31-May-20 20:06pm

A. B. Dinshaa

Updated 31-May-20 20:35pm

v2

Add a Solution

Comments

A. B. Dinshaa 1-Jun-20 2:32am

File "<ipython-input-21-16e265b393f1>", line 37
sql_create_projects_table = CREATE TABLE IF NOT EXISTS ACTOR {
^
SyntaxError: invalid syntax

The ^ symbole is on TABLE not in the start

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-05-31T20:36:00

Solution 1

Shouldn't that be a string? It's trying to process your SQL command as Pyuthon code ...

Posted 31-May-20 20:36pm

OriginalGriff

Comments

A. B. Dinshaa 1-Jun-20 2:47am

Do you mean we have to write SQL command in these """ quotes?
Eg: """SQL command"""

This way no table is getting generated in db file. What to do with it?

A. B. Dinshaa 1-Jun-20 4:07am

Indentation is also involved everywhere

# create a database connection
conn = create_connection(database)

# create tables
if conn is not None:
# create ACTOR table
create_table(conn, sql_create_ACTOR_table)

# create MOVIE table
create_table(conn, sql_create_MOVIE_table)

When I add one table the program is giving no error. When I add two tables the program is giving following error

near ")": syntax error

How to correct this syntax error?

Are the people answering are bots or humans?

A. B. Dinshaa 4-Jun-20 3:50am

Such errors were coming on spyder IDE not on jupyter notebook so I stopped using spyder IDE the only problem is jupyter is not giving any output at all which I am trying to figure out and if I require I am going to disturb you later for the above mentioned purpose.
Secondly jupyter is considered as better and latest as it is browser based and what I know is everything is getting browser based fast.