Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.5]

100 questions
0
votes
1 answer

function that waits until condition to return

I have barely any experience with proper SQL but I've been trying to write a database function that waits until a condition is met and then releases the thread so I can call that function whenever I want to wait until that condition is met. The…
lenny
  • 734
  • 2
  • 15
  • 43
0
votes
1 answer

Understanding of difference between MariaDB and SQL Server for a query

I am using MS SQL Server Version 2008 and MariaDB 10.5. My table and data : Following is the query i am running on both the databases. select distinct distributor from market order by city Found this query is failing in MS SQL Server database…
Developer
  • 150
  • 2
  • 12
0
votes
0 answers

mysqld fails to start due to InnoDB

I did install MariaDB on MX Linux, my system info below : System: Kernel: 5.10.0-9-amd64 x86_64 bits: 64 compiler: gcc v: 10.2.1 parameters: BOOT_IMAGE=/boot/vmlinuz-5.10.0-9-amd64 root=UUID= ro quiet splash …
chepakwak
  • 1
  • 3
0
votes
1 answer

mysql query to join two tables of closing ,opening stock and recived stock

need help with MySQL query to join one table has closing & opening stock and another table has received the stock. what I want is to join column recvd_value from table recived which stock purchase values to table sales which has an opening and…
gopal
  • 99
  • 1
  • 9
0
votes
0 answers

Can MariaDB return incomplete data?

I am using MySQL Connector to connect to a MariaDB server. A function in my program periodically retrieves all entries in a table (with a select * from ... without any wheres, limits, etc.). After it gets the data, it checks if these rows (using an…
vatolo7858
  • 1
0
votes
0 answers

Asp net core 6 with remote mariaDB database

I need to connect with a mariaDB database which is hosted online with entity framework core 6. here my connection string: "ConnectionStrings": { "DBConnection": "Server=148.163.126.69;Port=3306;Database=dbname;Uid=db_admin;Pwd=pass;connect…
Mahdi Benaoun
  • 67
  • 1
  • 8
0
votes
0 answers

Maria DB AWS Create Update After trigger

I would like to update processed value when the update happens on a row. If the processed <> 0 then update processed=1 else processed=0 Syntax error... SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds…
Novák Róbert
  • 27
  • 6
0
votes
0 answers

Why does this query error with illegal collation mix error but the second one doesn't?

Recently I installed MariaDB 10.5.9 from the Rocky Linux 8 @appstream repo. After configuring the database server to use utf8mb4_unicode_ci for everything, I hit a strange error with my database client tool. The error was reproducible on the command…
jamieburchell
  • 761
  • 1
  • 5
  • 18
0
votes
0 answers

SQL - Returning row on 'select * where id =' where id is substring of string passed

I have a database query where I am passing in a string to select where either an int (id) or string (name) match. For example: id (int) name (varchar) 13 this_is_a_name I am passing in because I want to be able to find in either…
Deggy
  • 36
  • 4
0
votes
0 answers

Connect to MariaDB by using PDO with accept server cert

I can connect the database with Maria client with --ssl options on application server: mariadb -h [Address] -P [Port] -u [DB admin user] -p --ssl But tried to connect the same database on same server with PHP PDO, we got the error message…
Min
  • 1
  • 1
0
votes
0 answers

Error when using union and putting column into variable

I am using Mariadb (10.5.12-MariaDB-1build1) on Ubuntu. I had created an insert trigger on a table; that uses union statement to check for previous records. It work fine in previous version (10.3.31-MariaDB-0ubuntu.20.04.1) but throw error in this…
Adeel Raza Azeemi
  • 571
  • 5
  • 16
0
votes
1 answer

Wordpress - Plesk - Mysql , strange setups and versions, huge bottleneck

I'm writing this after about 3 days of researches without ending in a solution that has sense. I had several setups to host Wordpress sites, using Apache directly and using Plesk, everything hosted on AWS. Recently I setup a new Plesk installation…
Leonardo Bernardini
  • 1,076
  • 13
  • 23
0
votes
0 answers

Load data into Mariadb with files containing (((

I'm completely new to import CSV into MariaDB I have a CSV with the following columns that I am trying to import into a new…
mikeldub
  • 1
  • 1
0
votes
1 answer

RPM package conflict between remi-safe and mariadb repo

I am running Centos 7 with additional repositories remi-safe and mariaDB-10.5. Everything worked fine for several months, now I get a package conflict when running yum update: Error: Package: libzip5-1.8.0-2.el7.remi.x86_64 (remi-safe) Required:…
Benedikt
  • 155
  • 1
  • 14
0
votes
1 answer

Mariadb 10.3 -10.5 join on 2 conditions fails on occasion / if is evaluated differently then on or where

The query was reduced to the least number of parts that still produce the error. Just for explanation purposes. SELECT s.Saison, t.Saison, IF(s.Saison = t.Saison,'gleich','unterschiedlich') FROM tbl_spielplan s LEFT JOIN …
Hauke
  • 1
1 2 3 4
5
6 7