we are not able to install Shopware v6.5.4.0 (PHP 8.2.8) with MariaDb. Tested with version: 10.5.22-MariaDB-1:10.5.22+maria~ubu2004 mit PHP-Erweiterung MySQLi and also 10.6.15. Tables are generated in the database, but the installation failed with an error in step 510 from 606:…
I have a table with the following schema: `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `bookingDate` date NOT NULL, PRIMARY KEY(`id`) I need to get all dates of the current month where there's less than 5 bookings. (meaning where less than…
Receiving the below error message when trying to connect to MariaDB using ODBC connection on Ubuntu 6.2 OS. I've tried just about everything but it's not working Error: Can't open lib '/usr/lib64/libmaodbc.so' : file not found Operating System: Linux ubuntu…
We use SQLBase for our development in various versions, including 12.2. Our main application is a Team Developer application (Version 7.5) that utilizes SQLBase as its database. In addition to Team Developer, we program in C# (.NET Core). We're quite…
I have this table, in the left there is the sample input table and on the right desired output How to calculate the number of status per empid basis using SQL on MySQL.
If I have a table A with 1000 rows, and a structurally identical table B but this time with 1000000 rows, will an ALTER TABLE (for example to add two new columns) take longer for table B? If so will…
Using FreeBSD freebsd 13.2-RELEASE-p2 FreeBSD 13.2-RELEASE-p2 GENERIC amd64 as ec2 instace(t2.xlarge) and mariadb104-server-10.4.28: mysql Ver 15.1 Distrib 10.5.20-MariaDB, for FreeBSD13.2 (amd64) using EditLine wrapper Trying to figure out why query: select v.id, b.book_number, b.title, v.question_ocr from version v join solution…
I have a main table called pics that has an ID number and the origin site from which it was pulled from. I also have another table called tags that has a list of all the tags that were also…
I have this table in my sql: 1 user1 2023-07-10 2 user1 2023-06-25 3 user2 2023-06-21 4 user3 2023-06-27 5 user3 2023-07-11 6 user4 2023-07-14 7 user2 2023-07-16 8 user1 2023-07-17 9 user4 2023-07-15 10 user5 2023-03-06 I need to…
I've a simple query that is taking way to much time to process, the query is very simple and the WHERE clause has just simple comparators but the query takes between 15 to 20 secs to process in a 256gb…