python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - mysql-python

Error creating table in MYSQL using Python

I am trying to create a MySQL table using python but it keeps giving me this error: Error while connecting to MySQL 1064 (42000): You have an error in your SQL syntax; check the manual that correspond...
test-img

Shully

python

mysql

mysql-python

mysql-connector

Votes: 0

Answers: 1

Latest Answer

It is because there is no such data type as smalldatetime. You probably meant to say: cursor.execute("CREATE TABLE tickersymbol (id INT AUTO_INCREMENT PRIMARY KEY, smalldatetime datetime, close F...
test-img

Andrej Prsa

None type object has no attribute "tosql"

df.to_sql('newcmc', con = engine, if_exists='append',index = False) While running the above code it is showing None type object has no attribute "to_sql"
test-img

Aparna Yadav

python

mysql

python-2.7

mysql-python

mysql-connector

Votes: 0

Answers: 1

Latest Answer

As all of the comments are (correctly) asserting. The variable df is none. And in particular, this comes from df=df.to_excel("newcmc.xlsx",index=None) which is giving a None. this would work...
test-img

D.L

Always getting this kinda error... 'mysql.connector.errors.InternalError: Unread result found'

" I'm working on a little project which connnects MYSQL and PYTHON. If I succeed in this then one can use the whole MYSQL server via PYTHON! ** But the thing is that I get raised by mysql.connect...
test-img

SARATHY B

python

mysql

python-3.x

mysql-python

mysql-connector

Votes: 0

Answers: 1

Latest Answer

You are re-using the cursor before the all the results from the execution of "SHOW DATABASES" has been consumed. The simplest solution is to fetch all the results and then iterate over them...
test-img

snakecharmerb - on strike

How to have a pointer to a table from a table entry?

Imagine we have 100 IoT devices collecting data every 5 seconds. We have a central table with 100 entries -- one per IoT device. The entries have columns such as name, battery, longitude, latitude. I ...
test-img

Ninja Bug

sqlalchemy

mariadb

mysql-python

Votes: 0

Answers: 1

Latest Answer

You should not create separate table for each device. You need to create single table for all measurements: create table devices ( id int unsigned primary key auto_increment, name varchar(64),...
test-img

Slava Rozhnev

Posts

Questions

Blogs

Jobs