mysql-python

how to select all date exclude 30 days before today

by

SELECT * FROM table WHERE INVOICE_DATE …..(30 days have passed since today)….. example: today = 2021-11-05 2021-11-04 non select 2021-10-07 non select 2021-10-04 select 2021-09-27 select Answers: Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as … Read more

raise errors.InterfaceError(ERR_NO_RESULT_TO_FETCH) mysql.connector.errors.InterfaceError: No result set to fetch from

by

I’m trying to make a simple tkinter program where there’s entries to put your username, email, and password and I am trying to make it check if there a username already exists and it gives me this error. I know there has been other questions about it on stackoverflow but those did not help me out.

Dynamic SQL Queries with Python and mySQL

by

I have multiple tables that are updated after a value is changed in a grid. These tables don’t always have the same keys or columns so I cannot explicitly name the columns or formats. The only thing that is ever the same, is the column where the keys reside. I know the way I am currently doing this is not correct and leaves me open to injection attacks.

Flask mysql data replacement. (UPDATE Statement)

by

The problem is this: When the command runs, it does not replace the data in the database. I looked at countless pages but found no solution to the problem. But it doesn’t give an error. Script: @app.route(‘/profil’, methods=[‘GET’, ‘POST’]) def profil(): if ‘loggedin’ in session: cursor = mysql.connection.cursor(MySQLdb.cursors.DictCursor) cursor.execute(‘SELECT * FROM users WHERE id = … Read more