MySQL

I encountered error message (INVALID SYNTAX) and have no idea why it happensPlease help to figure it out

From a table named 'review', I want to find the maximum count among the two conditions

I try to change a ddev database password for a single project

i have a problem with doing parameterized upsert commands over odbc

I'm trying to make a register pageWhen I enter the data that needs to be registered, it shows up on the console followed by Error: ER_EMPTY_QUERY

My ruby ​​version is 26

Currently I'm working on a project where a person can import an excel file (containing stock quantity) into a DataGridView and then export it into a MySQL tableWhen exporting to MySQL, I want to take the stock quantity in the file away from another table in MySQL (like if you were moving stock)

I am trying to update a table on a purchase event so a admin gets an task depending on what is purchasedthe products have codes with an catagory range between them which makes it easy because its an small shop

I have this df in R with various columns such as ID, Name, Prod, and other stuff which is not importantThe only important thing is the IDs

I have two databases, both with two tables, and want to move one set of the tables into the other set through some methodThe problem I am having is the tables have linked ids, and the ids should be unique, but duplicates are found upon migration

how to connect Embedded system c with MYSQL where the system read some values from sensors and then send it to the MYSQL database there is some tutorials explaine it but for C code only and not work in any cross Compiler for example this code

I have a set of data as below:

Want to improve this question? Update the question so it can be answered with facts and citations by editing this post

Using Python, I am trying to put data that is sequentially incremented by 1 in the newly added 'legendary' column to the existing data

In a table there is a column data(jsonb) and json array like this

A table of about 200 rows, 15 of which will have a numeric value rankClass (1-15)The rest will have NULL values

Good day, everyoneHope you're doing well

I wrote a program about finding products sold in both France and GermanyOn the other hand, I'm not happy with my subqueries

I have a code that is updating a few mySQL tables with the data that is coming from a Sybase databaseThe table structures are exactly the same

A customer notifies me that the search of an application we have developed for him is not working properlyThe search is based on queries on Full-Text Search indexes on InnoDB tables in MySQL 5

I'm trying to set up an exception where if a user enters a city that already exists in my database, then they get a message stating the city already exists

Hi if I use mysql itself I can see my tables and databases and I checked the port on the MySQL variables and it was the same as 3306

Is there a way to achieve this in MySQL (using pseudocode):

I'm moving a prestashop 16