Tag: mariadb

MYSQL codes not being read

mariadb mariadb-10.3 mariadb-10.4 mysql sql

When I input a code or anything into MySQL and hit “enter” it moves down and “->” appears. It is as if the code is not going through or the code is not being read. I have attempted to download “add-ons” but I am really not sure what I am doing. This is for school and I am having trouble

Optimising query with multiple selects as columns

indexing mariadb mysql performance sql

I have a query I made: The results table has 25000 entries and it takes around 7 seconds to do this query, which is far too long. The query is incredibly inefficient as each column I’m creating is searching again on the same table but with different conditions. I tried indexing the columns of interest in my where clause. This

How to SELECT two records for each unique column value as one row in MySQL?

greatest-n-per-group mariadb mysql sql

I have a MySQL table like this : +—-+—–+——-+——+——+——-+———————+ | ID | GID | Name | p1 | p10 | p100 | createdAt | +—-+—–+——-+——+——+—-…

How do I properly optimize this query?

mariadb mysql sql

I’m trying to optimize the following query. I’ve used EXPLAIN to troubleshoot but it keeps showing up in our logs as a non-indexed query. What am I missing? I’ve created indexes on all columns referenced, but it’s still showing up. Answer If you have a big table which contains millions of row, it would be the best to have where

SQL / Hibernate insert only if url not exists

hibernate java mariadb sql

I have a list of urls and a table that contains urls. I want to only insert if the url is not in the table. After the insert the Data-table should be contain: My current attempt is to have a method findByURL(url):List and a call this method for every URL in the list. If the returned list is empty I

Mariadb 10.4 Data truncated for column ‘column_name’ on insert but not on update

mariadb mysql sql

I have the following table (mariadb 10.4) called p: I currently have a couple of million rows on this table with the sources a, b, c, and d. Just recently we applied a migration to add source_e and we started getting the error ERROR 1265 (01000): Data truncated for column ‘source’ at row 1 when trying to inset a row

SQL count row where progres not done

mariadb sql

Need some help, dont know the keyword of this problem to search online I want to count some progres that isn’t done when progres has step3 then its not counted desired result from that example is 2, im trying to do it alone, and it doesnt work help is needed, Thanks Ahead Answer One method uses count(distinct) and filters in