I use MySQL, why MariaDB in the error message? I'm trying to load some data from my databasetable into my table but I'm having this error, even though I did use prepared statements to call executeQuery without passing any parameter…
I have a Wordpress Database with two tables with this structure Table 1 "location" id, postID, address 1, 123, park ave 2, 234, washington ave 3, 345, wall st 4, 456, park ave 5, 567, wall st Table 2 "posts"…
I have small web/mail server with apache/mariadb. Last week we changed some of the WWW code and to make it work I changed in php.ini line : max_input_vars to 5000 (now 4000, it was 1000 at the start) And it…
My query: SELECT * FROM outlets INNER JOIN users ON outlets.owner=users.id; The result is an array in which the indexes from one table match those of another table. Is it possible to somehow make such a request that owner =…
I have a "simple" query how takes 0.7678 seconds or more to be executed with MariaDB. Here is the query: select `referenceNumber` from `invoice` where `groupId` = 3550 and `referenceNumber` >= 301 order by `referenceNumber` desc limit 1; These columns…
I've got following tables: Supplier idSupplier Name Product idProduct idSupplier EAN Now I want to select all values from both tables. I'm using this Query: SELECT Supplier.*, Product.* FROM Supplier INNER JOIN Product ON Supplier.idSupplier = Product.idSupplier The issue is,…
I am having performance issues with a query, I have 21 million records across the table, and 2 of the tables I'm looking in here have 8 million each; individually, they are very quick. But I've done a query that,…
More detailed question. I have a table called CALCS with the structure: code is the record identifier (not unique) value1, value2, value3,value4 are different values to sum price is the cost of work I must return price+value1+value2+value3+value4 for all records.…
I am running this command: docker run --net mynet --ip IP -p 3306:3306 --mount source=database,target=/var/lib/mysql -e MYSQL_ROOT_PASSWORD=XXXX mariadb:10.5.17 I get the following error: Unknown/unsupported storage engine: InnoDB When I google, I find that I have to remove certain log files…
MariaDB 10.3.36 i need to calculate the timediff in sec between the date row and create a new column like diff_sec