I need to process a queue and MySQL for update is the goal for that. Everything is working fine, except the fact for update is locking joined tables too. I have
I need to calculate weekends of time range using MySQL. This is what I have so far(about calculate working days but i want to calculate weekends): select (f
i want to ask you how to select FOREIGN KEY (from "doa_id in "doas" table) when user create a new data (to the "notes table) in a form. This is my code : NoteCo
I've been struggling with this for a while but with no success. I have two tables that might have a relation but not necessarily. FIRST +----+-----------+------
I've been struggling with this for a while but with no success. I have two tables that might have a relation but not necessarily. FIRST +----+-----------+------
When working with data values, should I create a single table storing the hourly values, and also the aggregated daily/monthly values, or should I create separa
Question on the sql, any help is appreciated dataset: a_col b_col 1 null null 1 2 null null 2 expected output a_col b_col gro
I cannot understand why I keep getting an 1061 error for key duplicates on indexes when I dont have any duplicates. I've looked at other stackoverflow posts reg
I am using the latest version of django elasticsearch dsl and I am using the following command to index around 80 million documents: python manage.py search_ind
I have a Redshift datawarehouse that is pulling data in from multiple sources. One is my from MySQL and the others are some cloud based databases that get pulle
I am struggling to solve a problem in a CRUD working with MySQL (MariaDB). The situation is the following: I have a DB table called "tools" in this table I have
I am new to docker and I have recently been trying to setup my project on docker. I have successfully deployed the application on nginx and php and i have been
I have used following query to get below output from my exisiting database. select date(RaisedTime) as date, object,User,Count(*) as total from table1 where obj
I have a lambda function that runs SQL scripts using Python which works fine until I try to run scripts that create stored procedures. Does anyone know what the
I have a MySQL table: CREATE TABLE `test_table` ( `id` BIGINT, `json_config` JSON, ); json_config has a property called bookNames, whose value is a jso
I am a student trying to develop a music library just to try out new technologies. Currently I use NestJS together with TypeORM as my backend technologies (as w
<?php include ("../navbar.php"); ?> <?php include("../conn.php"); $query = "select * from semi_synthetic"; $result =
We have a peculiar situation. I have inherited some source code from the people who left the company. in docker file they are installing the mysql driver via ap
We have a peculiar situation. I have inherited some source code from the people who left the company. in docker file they are installing the mysql driver via ap
I have this query (mysql): SELECT `budget_items`.* FROM `budget_items` WHERE (budget_category_id = 4 AND ((is_custom_for_family = 0)