Foreign key constraint failed: cannot add or update child row (Error 1452)

I created the table in MySQLWorkbench as follows: ORDRE table: CREATETABLEOrdre(OrdreIDINTNOTNULL,OrdreDatoDAT...

From [MySQLdiscussion group] 2023-10-08 23:40:09 0  1  888

How to return response from async call?

How to return response/result from function foo which makes async request? I've tried returning a value from t...

From [MySQLdiscussion group] 2023-10-08 20:41:15 0  2  711

session_variables table does not exist in performance_schema

After upgrading MySQL to 5.7.8-rc version and logging into the server, I encountered the following error: Tabl...

From [MySQLdiscussion group] 2023-09-22 13:52:07 0  2  1328

Laravel sort by price with special price conditions

I have a table with the following columns (price, special offer, whether on sale). +-------+------+-----------...

From [MySQLdiscussion group] 2023-09-22 13:06:46 0  1  1224

Mysql: "The connection attempt failed because the connecting party did not respond properly after a period of time"

I have a project using AspNetMVC4.5.2 and Mysql database. For a few days, my project started getting errors fr...

From [MySQLdiscussion group] 2023-09-21 14:59:55 0  1  936

Prisma ORM has no Json string_contains method for base path

I'm trying to filter a json type field that contains strings because I want to search all json content this._p...

From [MySQLdiscussion group] 2023-09-21 13:41:24 0  1  693

How to match strings with appended parts using Python, but not match them if their appended parts are different

How to match strings with appended parts, but not match them if they have different appended parts? For exampl...

From [MySQLdiscussion group] 2023-09-20 19:02:23 0  1  777

How to retrieve rows in column with highest value using SQL [duplicate]

I have a table in a document (here is a simplified version): id to content 11...21...12...13... How to select ...

From [MySQLdiscussion group] 2023-09-20 13:44:50 0  2  741

Close: MySQL update query to increment specific value

How to update mysql column Id name with same value increment update A (expected) update B (expected) 1AAAAA112...

From [MySQLdiscussion group] 2023-09-19 18:36:24 0  1  679

MySQL multi-expression if statement

I want to execute multiple expressions in an if statement in a select statement like this: SELECTt.id,IF(id>...

From [MySQLdiscussion group] 2023-09-19 16:06:52 0  1  772

Codeigniter command line error - PHP fatal error: class 'CI_Controller' not found

After following the instructions in the user guide, I am unable to run the test script via the command line. M...

From [MySQLdiscussion group] 2023-09-18 22:52:11 1  2  997

mysqldump without specifying location

I used the mysqldump command to export the database without specifying the export location. mysqldump-uusernam...

From [MySQLdiscussion group] 2023-09-18 10:39:37 0  1  707

Unable to access MySQL, error code 1045 (28000): Access is denied for user 'bill'@'localhost' (using password: yes)

Let me first mention that I have looked at many of the suggested questions and found no relevant answers. Here...

From [MySQLdiscussion group] 2023-09-17 09:21:55 0  2  717

How to include a PHP variable in a MySQL statement

I'm trying to insert values ​​into a table of contents. It works fine if there are no PHP variables in VALUES....

From [MySQLdiscussion group] 2023-09-16 21:28:26 0  2  641

Update the contact_id column of each row with the same from_address to the maximum value

I have a database with a table called contacts that contains a list of customers, and a table called helpdesk_...

From [MySQLdiscussion group] 2023-09-16 17:40:45 0  1  687