Is it possible to query data like this from SQL?
Issue I’ve made a Select Query with multiple Tables using Joins. In the database, I have some data that have…
Category: MySQL
WHERE before GROUP BY and HAVING after GROUP BY in MYSQL
Issue Which out of WHERE before GROUP BY and HAVING after GROUP BY is a better choice according to time…
Has anyone found that REGEX "\b" doesn't work in MYSQL?
Issue Has anyone found that REGEX “\b” doesn’t work in MYSQL? I have a nice piece of regex that matches…
group by ID and filter by condition – if something then mark them as something else
Issue On my query right now I’m receiving and ID that can be repeated and the status, so I want…
MySQL partitions based on last two digits of a column
Issue If i have a database of 100 million of records and would like to do search with less time…
Different database name in SELECT and connectionURL, does this matter?
Issue We have a custom Java code that connects to MySQL (8.0.23-14). Developers are using one database connection to trigger…
Mysqli code to fetch one result and return it
Issue I have a login site where users login with their emails. Each is assigned an auto-increment user_id. I want…
SQL: Columns are same except of one content
Issue I have the following Table: ID TIME AMMOUNT 1 x 5 2 y 1 2 y 3 3 z…
Cannot delete or update a parent row: a foreign key constraint fails
Issue When doing: DELETE FROM `jobs` WHERE `job_id` =1 LIMIT 1 It errors: #1451 – Cannot delete or update a…
Fetch data from same named two columns of two tables
Issue I am trying to fetch data from 2 tables with a join query. Here I have 2 columns in…