Create table error in my sql connector python

Question

mysql.connector.errors.ProgrammingError: 1064 (42000): 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 'int primary key, name varchar(100), salary int, doj date)' at line 1

import mysql.connector as mysql
con=mysql.connect(host='localhost',user='root',password='mysqltables',database='school')
cur=con.cursor()
table='INSERT INTO pyStudent(id int primary key, name varchar(100), salary int, doj date)'
cur.execute(table)
for i in range (1,2):
    inpt_id=int(input('Enter employee id',i,'= ' ))
    inpt_name=input('Enter employee name',i,'= ' )
    inpt_sal=int(input('Enter employee salary',i,'= ' ))
    inpt_doj=input('Enter employee joining date',i,'= ' )

    sql = "INSERT INTO pyStudent (id, name, salary, doj) VALUES (%s, %s,%s, %s,%s, %s)"
    val = (inpt_id,inpt_name,inpt_sal,inpt_doj)
    cur.execute(sql, val)
showw='select * from pyStudent'
cur.execute(showw)
temp=cursor.fetchall()
for row in temp:
    print (row)
cur.execute('commit')

INSERT INTO pyStudent(id int primary key don't you mean CREATE TABLE pyStudent(id int primary key? — HoneyBadger
– HoneyBadger, Commented Oct 26, 2020 at 9:38

Victor Raboshchuk · Accepted Answer · 2020-10-26 10:06:49Z

0

You adding to many values to your SQL query.

Use (%s, %s, %s, %s) instead of (%s, %s,%s, %s,%s, %s)

answered Oct 26, 2020 at 10:06

Victor Raboshchuk

11 bronze badge

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

2 Comments

Devesh Excite Over a year ago

thanks for that correction but i think the error comes due to some different reason 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 'int(10), name varchar(100), salary int, doj date)' at line 1

Victor Raboshchuk Over a year ago

Listen, you need to specify values that you are inserting. Here is an example: INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

Collectives™ on Stack Overflow

Create table error in my sql connector python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related