CREATE TABLE syntax error in mysql 6.3/python 3.5

Question

I'm using python to create a table in a mysql 6.3. The code worked great when using sqlite and is now throwing the following error.

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' tokyo REAL, primary key (rowid))' at line 1")

the code is

import pymysql
conn=pymysql.connect(host='localhost',user='root',password='password',db='testschema',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)
a=conn.cursor()
sql='''CREATE TABLE pressure (rowid INT AUTO_INCREMENT NOT NULL, date_time, 
    tokyo REAL, primary key (rowid));'''
a.execute(sql)

Any help is greatly appreciated!

... date_time - what is this supposed to be? add some type to it maybe? dev.mysql.com/doc/refman/5.7/en/datetime.html — user3012759
– user3012759, Commented Oct 24, 2016 at 15:20
Does the query work outside of your python script (against a MySQL instance not SQLite)? — Sevyns
– Sevyns, Commented Oct 24, 2016 at 15:20
I deleted the date_time column and it works great. Thanks!!!!!! — Hanley Soilsmith
– Hanley Soilsmith, Commented Oct 24, 2016 at 15:23

Moses Koledoye · Accepted Answer · 2016-10-24 15:23:24Z

1

You need to specify the datatype for the date_time column, say DATETIME:

sql='''CREATE TABLE pressure (rowid INT AUTO_INCREMENT NOT NULL, date_time DATETIME, tokyo REAL, primary key (rowid));'''

Reference:

Create Table syntax

answered Oct 24, 2016 at 15:23

Moses Koledoye

78.8k8 gold badges139 silver badges141 bronze badges

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

Comments

bushra banu · Accepted Answer · 2016-10-24 16:28:05Z

0

Type is not added to datetime column..

Change table creation syntax like below.

CREATE TABLE pressure (rowid INT AUTO_INCREMENT NOT NULL, date_time datetime , 
tokyo REAL, primary key (rowid));

edited Oct 24, 2016 at 16:28

user1361491

answered Oct 24, 2016 at 15:32

bushra banu

112 bronze badges

Collectives™ on Stack Overflow

CREATE TABLE syntax error in mysql 6.3/python 3.5

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related