I'm trying to delete multiple duplicate rows/data, but the problem is MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near…
I have 4 tables (names are in italian and english in parenthesis for better comprehension): IMPORTANT!: Database is MariaDB-10.8 Passaggi (steps): CREATE TABLE `passaggi` ( `id` int(11) NOT NULL, `tipo_procedura_id` int(11) DEFAULT NULL, `passaggio` varchar(255) NOT NULL, `ordine` int(11) NOT…
I'm trying to connect to my Mariadb database that's inside a Docker container. I've looked at Microsoft's documentation and searched on Google to find out why I'm getting an error message saying that there's nothing to retrieve from the database.…
I have a product filter based on data from multiple tables. I make query using IN 2 and more times in one query. This works great and only selects products that have and needed attributes and needed options and needed…
I have a complex query. The following below is the most basic example of what I want to do. SELECT match_by_color AS match_type, t1.* FROM t1 WHERE ( t1.color LIKE 'color%') -- match_by_color OR (t1.type in (select type from t2))…
The information found in the official MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html does not match the information shown in the manual at https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html for version 8. First link says that the 64kb limit was dropped, the 2nd link says it exists. It…
I have a table with a column with repeating values, and I want to add another column that has unique values for each distinct value in the first column.Here is a sample: temp Postal 1 42420 2 90032 3 60610…
I am trying to write a stored procedure in MariaDB/MySQL that will return table names, if any, within the schema that matches a pattern provided by the parameters. Guessing this is accomplished by querying the information_schema table, but any advice…
I have a table that includes an int column named row_number. This worked fine until I upgraded Debian from 11 to 12 which upgraded MariaDB from 10.5 to 10.11. I now get errors when using SQLAlchemy. I've tracked down where…
Attempting to create a golang mysql multi container app. Similar to docker example https://docs.docker.com/get-started/07_multi_container/ I do not understand why connection is refused. dial tcp 127.0.0.1:3306: connect: connection refused Here is my docker-compose.yaml version: '3.7' services: api: # api service starts…