How to use variables in SQL statements in Python?

I have the following Python code: cursor.execute("INSERTINTOtableVALUESvar1,var2,var3,") where var1 ...

From [MySQLdiscussion group] 2023-08-20 17:35:10 0  2  507

Duplicate entry '1' results in error code 1062: Conflict on primary key 'PRIMARY'

I'm having trouble with this error message when I try to do this: INSERTINTO`PROGETTO`.`UFFICIO-INFORMAZIONI`(...

From [MySQLdiscussion group] 2023-08-20 16:59:40 0  2  553

How to reset or change MySQL's root password: MySQL Password Reset Guide

How to change MySQL root password and username on Ubuntu server? Do I need to stop the mysql service before ma...

From [MySQLdiscussion group] 2023-08-20 15:35:51 0  2  522

Rewrite the title as: Display the data in the MySQL database table as an HTML table on the web page

I want to retrieve values ​​from a database table and display them in a page as an html table. I've searched b...

From [MySQLdiscussion group] 2023-08-20 14:48:09 0  2  591

"The non-aggregated columns in the SELECT statement do not appear in the GROUP BY clause and are incompatible with sql_mode=only_full_group_by"

I'm using MySQL5.7.13 with WAMP server on my Windows PC My problem is when executing this query SELECT*FROM`tb...

From [MySQLdiscussion group] 2023-08-20 13:44:52 0  2  525

Retrieve the last record of each group using MySQL

There is a table called messages which contains data like this: IdNameOther_Columns-------------------------1A...

From [MySQLdiscussion group] 2023-08-20 11:48:53 0  2  550

How to solve PHP error display problems

I've checked my PHPini file (php.ini) and display_errors is set and error reporting is also E_ALL. I have rest...

From [MySQLdiscussion group] 2023-08-20 11:45:59 0  2  591

How to find where Mysql functions are used

I'm using Mysql8. In one of the views I'm working on, there is a function called calculateGP. I want to modify...

From [MySQLdiscussion group] 2023-08-18 16:46:18 0  2  520

SQL comparison between boolean values ​​can lead to unexpected results

Why do most (all?) SQL databases give the following result: SELECTFALSE

From [MySQLdiscussion group] 2023-08-18 16:25:41 0  1  574

Bring rows in a database table that have data in all columns to the front

In MySQL5.7 I have a column with 28 columns and 4000 rows. I want to get all the rows that have data first or ...

From [MySQLdiscussion group] 2023-08-18 15:48:44 0  1  564

MySQL runs automated scripts

I have a MySQL database with two tables: drivers and devices. The drivers table has a field called expirationd...

From [MySQLdiscussion group] 2023-08-18 11:24:32 0  2  466

Example of many-to-many relationship

I haven't found any examples of MYSQL many-to-many relationships either here or on Google. I would like to see...

From [MySQLdiscussion group] 2023-08-18 11:04:20 0  2  693

Delete from multiple tables in one statement

Using MySQL, I'm trying to delete multiple records from multiple tables at once. Initially I thought I could d...

From [MySQLdiscussion group] 2023-08-18 10:28:49 0  1  534

How to specify custom column types in Prisma?

Prisma does not currently support geospatial columns. I need to add a column of type MySQLGEOMETRY to my datab...

From [MySQLdiscussion group] 2023-08-18 10:18:26 0  1  518

Get employees who have not clocked in for 11 consecutive days

I am trying to get the employees who have not marked attendance for 11 consecutive days from the database, for...

From [MySQLdiscussion group] 2023-08-18 09:31:19 0  1  486