Advertisements The code is calling a database and producing a table, this function is calling what is selected and running a sql query to swap the exceptions int and move it around in the tables, this works when hard coded into it def selectedRow(): # Get the currently active tab active_tab = tab_control.tab(tab_control.select(), "text") if… Read More python mysql.connector, not running sql code

Advertisements I’am working on flask application, and I want to initilize the db when i start the application, so i create a schema file: schema.sql file contains: — Drops DROP TABLE IF EXISTS `article`; DROP TABLE IF EXISTS `book`; DROP TABLE IF EXISTS `settings`; — Article CREATE TABLE `article` ( `id` int NOT NULL AUTO_INCREMENT,… Read More Error: CMySQLCursor.executemany() missing 1 required positional argument: 'seq_params'

Advertisements I’m trying to get my user id and write it into mysql db. The problem occurs at the moment when I try to write this data (31-34). It writes random id into db (2147483647), but i need to write my user id (1003694956919148625). Any ideas? class MyModal(discord.ui.Modal): def __init__(self, *args, **kwargs) -> None: super().__init__(*args,… Read More How to fix MySQL-Connector INSERT Bug?

Advertisements this is the code of the following function Function: def dishID(): query = ‘select count(*), max(DishID) from Dish’ cur.execute(query) fetch = cur.fetchall() for i in fetch: if i[0] == 0: return 1 else: return (int(i[1]) + 1) Error code dishname = input(‘Enter Dish Name: ‘) dishprice = input(‘Enter Dish Price: ‘) dishid = str(dishID())… Read More NameError: name 'dishID' is not defined. Did you mean: 'dishid'?

Advertisements I have added secure-file-priv = "" to my nano /etc/my.cnf file for mysql and now I’m not able to remove it.When I remove that line and try to save it, it’s asking me to write to a file and the changes are not saved I tried to uninstall and install mySQL but due to… Read More I have written a line in nano /etc/my.cnf file and how I'm not able to remove it

Advertisements So I am trying to build a database in MySQL using python. I already created the database and created the table I want to use. it’s called ‘alliances‘. Now this table only has two columns, an ID column and a alliance_name column. The ID’s auto increment , and the names I already have them… Read More MySQL Python connector error while inserting

Advertisements I’m working on sql project in python and I having some problem here seeking for help. I have a list variable and I want to insert the datetime into sql module: mysql-connector , IDE: vscode here’s the variable data_lst =[[‘2020-12-13 13:00:00′,2,3,4,5]] dttime = str(data_lst[z][0]) here’s the code #dttime is in datetime format insert_data =… Read More SQL syntax error when passing datetime into execute code

Advertisements it is showing me no record after writing the 1, I have data on my database for 1 can someone please help me to know where I am wrong here! def searchDB(): try: sqlCon = mysql.connect(host="localhost",user="root",password="*********",database="mydatabase") cur =sqlCon.cursor () cur.execute ("select categoryname from category where "+ str(searchby.get())+ "Like ‘%" + str(search.get()) + "Like ‘%’")… Read More Not Working filter search using python and mysql

Advertisements I’m doing a web scraping project and now I’m trying to store my data into a MySQL database (remote server). I’m sure the DB config is done write, but I keep getting this error: Traceback (most recent call last): File "C:**\main.py", line 14, in <module> cnx.commit() File "C:**\mysql\connector\connection_cext.py", line 406, in commit self._cmysql.commit() _mysql_connector.MySQLInterfaceError:… Read More update query python mysql.connector