Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- conn = mysql.connector.connect(user="root",password='password',
- host='localhost',database='library',port='3306')
- cur = conn.cursor()
- def create_table():
- cur.execute("CREATE TABLE IF NOT EXISTS store
- (id INT PRIMARY KEY, item VARCHAR(25), quantity INT, price REAL);")
- conn.commit()
- conn.close()
- def insert(id, item, quantity, price):
- cur.execute("INSERT INTO store (id, quantity, price, item)
- VALUES (%s, %s, %s, %s)" % (id, item, quantity, price))
- conn.commit()
- conn.close()
- insert(50, 'test', 20, 10)
- Traceback (most recent call last):
- File "C:Program FilesPython36libsite-
- packagesmysqlconnectorconnection_cext.py", line 392, in cmd_query
- raw_as_string=raw_as_string)
- _mysql_connector.MySQLInterfaceError: Unknown column 'test' in 'field list'
- During handling of the above exception, another exception occurred:
- Traceback (most recent call last):
- File "C:UsersAcerDesktopRemastered.py", line 128, in <module>
- insert(50, 'test', 20, 10)
- File "C:UsersAcerDesktopRemastered.py", line 109, in insert
- cur.execute("INSERT INTO store (id, quantity, price, item) VALUES (%s, %s, %s, %s)" % (id, item, quantity, price))
- File "C:Program FilesPython36libsite-packagesmysqlconnectorcursor_cext.py", line 266, in execute
- raw_as_string=self._raw_as_string)
- File "C:Program FilesPython36libsite-packagesmysqlconnectorconnection_cext.py", line 395, in cmd_query
- sqlstate=exc.sqlstate)
- mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column 'test' in 'field list'
- [Finished in 0.8s with exit code 1]
Add Comment
Please, Sign In to add comment