python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - mariadb

SQL 'IS NOT NULL' fails to filter rows and return an emtpy set

Obviously the title is provocative, but this is where I'm stuck. I have an SQL query with a JOIN that returns a single row (even though the result set is empty) because of the count(r.sid) function on...
test-img

mxmanghi

sql

mariadb

Votes: 0

Answers: 1

Latest Answer

Try this select COUNT(r.sid) ,c.code,c.created,c.cid from conference as c left join registrations as r on r.cid=c.cid where c.code = 'not_existing_code' and c.code is NOT NULL Group by c.code,c.cr...
test-img

Himanshu

Error 1366: Incorrect string value when inserting strings into MariaDB

I have MariaDB table that has index VARCHAR(10) NOT NULL COLLATE 'utf8mb3_general_ci' type. I have a string in Go that I cut to 10 characters, if it is longer, to insert into/update this table. I cut ...
test-img

user17644273

mysql

go

mariadb

Votes: 0

Answers: 1

Latest Answer

which makes me believe the cutting of the string somehow makes the string indigestible for the database? Cutting strings by sub-slicing as value[:10] (and measuring length with len for that matter) ...
test-img

blackgreen

Reactive driver for MariaDB

I'm using Quarkus + Munity + Reactive Driver for MariaDB. I have a question to understand how reactive driver is working. I want to process 20_000_000 entries stored in my database. For that, I want t...
test-img

Malys

mariadb

quarkus

vert.x

reactive

Votes: 0

Answers: 1

Latest Answer

The Reactive Client for MySQL will fetch all rows if you execute a query or prepared query. For large amounts of rows, it's better to use the streaming API: Multi<Row> rows = connection.prepare(...
test-img

tsegismont

Are Objects inside of other objects being saved to the database?

I hope someone understands, what I mean by this question. I try to explain it as good as possible: I want to save an object, which is a JPA-entity to the database, by using accountRepository.save(acc...
test-img

Z-100

java

database

spring-boot

jpa

mariadb

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs