Invalid input: WITH is not valid syntax in this context

So I have a request like WITHcustomers_in_usaAS(SELECTcustomerName,stateFROMcustomersWHEREcountry='USA')SELECT...

From [MySQLdiscussion group] 2023-10-23 11:59:56 0  1  478

Connect phpMyAdmin to MySQL server via SSL

I might be barking up the wrong tree... However, what I have is a MySQL server that only accepts connections f...

From [MySQLdiscussion group] 2023-10-23 08:57:18 0  2  875

How to synchronize development and production databases

Do you know of any application that synchronizes two databases - during development sometimes you need to add ...

From [MySQLdiscussion group] 2023-10-22 23:37:30 0  1  728

TypeLoadException: Method 'Create' not found in type 'MySql.Data.EntityFrameworkCore.Query.Internal.MySQLSqlTranslatingExpressionVisitorFactory'

I'm trying to add a new user to the database using the following code: publicasyncvoidSeedUsers(){intcount=0;i...

From [MySQLdiscussion group] 2023-10-22 20:34:52 0  1  557

Does field order matter in multi-column index in MySQL?

I know the importance of indexes and how join order changes performance. I've read a lot related to multi-colu...

From [MySQLdiscussion group] 2023-10-21 22:05:44 0  2  651

How to export partial rows of a MySQL table from WHERE clause?

How to export certain rows of MySQL table using where clause from PHP script? I have a MySQLsay test and I wan...

From [MySQLdiscussion group] 2023-10-21 11:41:17 0  2  672

Preventing SQL injection attacks in Java programs

I have to add a statement to my java program to update the database table: Stringinsert="INSERTINTOcustom...

From [MySQLdiscussion group] 2023-10-20 20:06:17 0  2  823

LoadError: Unable to load 'listening' gem (track 5)

I have an API mode Rails5 application that doesn't let me run rakepaths or railss. The error I get is: $rakero...

From [MySQLdiscussion group] 2023-10-20 12:50:56 0  2  530

How to remove duplicates in SQL table based on multiple fields

I have a gaming table with the following description: +---------------+-------------+------+-- ---+---------+-...

From [MySQLdiscussion group] 2023-10-20 12:01:14 0  2  642

Rewrite the title as: Get MySQL field names using variables

Is it possible to select a field with a string name? SELECT "FIELD NAME" FROM TABLE I need this trig...

From [MySQLdiscussion group] 2023-10-20 09:39:08 0  2  696

.NET Framework does not support character set 'utf8mb3': System.NotSupportedException

I'm trying to run a server with a MySQL database, but I keep getting this huge error and I don't know why. [21...

From [MySQLdiscussion group] 2023-10-19 17:44:27 0  2  987

PHP: Call MySQL stored procedure with input and output parameters (not "INOUT")

I want to call a stored procedure in MySQL from PHP. The procedure takes input and output parameters - not &qu...

From [MySQLdiscussion group] 2023-10-19 16:56:30 0  2  763

Restore table structure from frm and ibd files

I'm trying to restore the database in the PMA but can only access the frm and ibd files - not the ib_log file ...

From [MySQLdiscussion group] 2023-10-19 10:01:37 0  2  732

MySQL: Permanent solution to "Waiting for table metadata lock" issue

My MySQL database serves three web applications as a storage backend. However, I recently encountered the erro...

From [MySQLdiscussion group] 2023-10-18 21:53:32 0  1  753

Design multifunctional product tables with multiple parameters for various product types

I don't have much experience in table design. My goal is to create one or more product tables that meet the fo...

From [MySQLdiscussion group] 2023-10-18 17:44:13 0  2  885