I have a table where I want to find the average value of column1 and column2, but in some cases there may be null values in either columns. In that case, I just want to be shown the value that…
I used CPanel elevate to update my CentOS 7 system to Almalinux. The database was upgraded from MySql to MariaDb 10.x The database queries are taking 10x of the time they used to take, specifically those queries where WHERE is…
In MySQL 5.7.25 and MariaDB 10.6.15, using InnoDB by default to create below table create table t1( id serial, employee_id int not null, name varchar(20), status tinyint, created_at datetime(3) not null, updated_at datetime(3) not null, event CHAR not null, primary…
We're experiencing issues when using Amazon DMS for ongoing replication of a MySQL/MariaDB database. The issue specifically happens with TIME columns, whose values get garbled like this: 13:22:31 becomes 112:16:02 13:23:59 becomes -911:43:62 (which is actually below the documented minimum…
I have a mysql database that contains data collected from various weather sensors and the like. All the data is easy to handle apart from the raw rain fall which is by nature incremental but can be reset to zero…
I have problem when i want start express server, i got the following error Unable to connect to the database: ConnectionError [SequelizeConnectionError]: (conn:3, no: 45025, SQLState: 08004) Client does not support authentication protocol 'auth_gssapi_client' requested by server. at ConnectionManager.connect (F:CodeWebapr-tsbackendnode_modulessequelizelibdialectsmariadbconnection-manager.js:100:17)…
I'm working on a Laravel application with a jobs table containing job data in the payload column. The payload is a JSON string similar to this: {"displayName":"App\Jobs\V1\ProcessOrdersPendingCourier"} I want to fetch records where the displayName key in the JSON payload…
CREATE TABLE t (j LONGTEXT); INSERT INTO t (j) VALUES ('{"a":"1"}'); INSERT INTO t (j) VALUES ('{"b":"2"}'); INSERT INTO t (j) VALUES ('{"c":"0", "d":"0"}'); INSERT INTO t (j) VALUES ('{"c":"1", "d":"1"}'); SELECT JSON_KEYS(j) FROM t; +--------------+ | JSON_KEYS(j) | +--------------+…
Following a bunch of automatic server updates MariaDB keeps crashing and will not restart. Pasted below are the last 100 lines of the mysqld log but I don't know what I am looking for here... Then I try to restart…
I have such query in my program: SELECT customer.Id, customer.FirstName, customer.LastName, SUM(PeriodHours) AS SUMPeriodHours, PeriodDay FROM ( (SELECT CustomerId, (UNIX_TIMESTAMP(taskinterval.EndDateUtc) - UNIX_TIMESTAMP(taskinterval.StartDateUtc)) / 3600 AS PeriodHours, date(taskinterval.StartDateUtc) as PeriodDay FROM taskinterval WHERE StartDateUtc > @STARTDATE and StartDateUtc<@ENDDATE ) AS tmptbl…