I have a table ` table VALUES from UNSIGNED INT to UNSIGNED INT value VARCHAR(2) ` example of filling 0,100000,good 100001,200000,better 200001,300000,best --- etc. I need to query a value by number, e.g. 100 (is between 0 and 100000), should…
I have a list of blog posts, people can leave comments and I reply to them This is how the structure looks like table structure Is there a way, with a single query, to get all posts where I'm not…
i have a nested function calls to update some data in database , the column im going to update is unique in database and it may be updated with a duplicate value in that case i want to flag that…
I am using laravel and vue for a project, I want to pass the user id to the table if the user is authenticated, but for some reason the authenticated user's id is not passed to the query giving this…
On one system I have MariaDB installed via Homebrew and I can manipulate its DBs with Beekeeper Studio. Setting up a new system in what (as far as I can remember) is the same way, I find that no applications…
Task: I develop messenger, and I'm trying to find only users who don't share rooms with user X. I need this to offer users new chats. Problem: I can't to write right SQL query. I was only able to get…
I have an issue when i tried to put a date into a date row in MySQL resulting in this error: But my code is this: DateTime tomarIngreso = dateTimePicker_FechaDeIngreso_Agregar.Value; DateTime tomarPlazo = dateTimePicker_FechaPlazo_Agregar.Value; string plazoFormat = tomarPlazo.ToString("yyyy-MM-dd"); string ingresoFormat…
I have this query which selects the users for a given branch. SELECT u.first, u.last, u.id, (SELECT u1.user_type FROM users_branches AS u1 WHERE u.id = u1.user_id AND u1.branch_id = @foo LIMIT 1) FROM users AS u WHERE EXISTS (SELECT 1…
We are using AWS Aurora MySQL(8.0.mysql_aurora.3.04.0) InnoDB engine with large instance(16GB RAM). One particular “SELECT” query running against one large table (250GB - not partitioned) in the "reader" instance which does some calculations including min,max,window functions, group by, etc. This…
I have 2 Tables Like these: region Table: +----------+-------------+ |region_id | region_name | +----------+-------------+ |1 | RN1 | |2 | RN2 | |3 | RN3 | +----------+-------------+ and role Table: +----------+-------------+ |role_id | role_name | +----------+-------------+ |1 | admin |…