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)
in my database there are 2 tables : posts, room Posts tables include ID and Title columns and includes many rooms and hotels titles and IDs. In the room table t
In SSIS, I have a data flow task which uses a data flow task to get data from SQL and save it in CSV file( using flat file connection manager). In this, I have
please help in this matter. So my scenario is that I have driver app (flutter) that fetch ongoing orders that needed to be delivered. I would like to fetch orde
Using php 8.0.2 and Laravel 8.37.0, I am running tests where for every test the database data should be refreshed, since there is conflicting data per test (due
In mySQL I have a table: id name code1 code2 code3 1 Jim aaa aaa a 2 Ryan bb bbb b 3 Ted c c
I am a beginner when it comes to PHP and it is not my specialty, I am rather in the front end and I have a big problem. I need to edit one of the tables after a
When i use GetReportData from the Package ‘RGoogleAnalytics’, the data stop being fetched after sometime. E.g If the data to be fetched has 100,000
SELECT id, ( 6371 * ACOS( COS( RADIANS( db_latitude ) ) * COS( RADIANS( $user_latitude ) ) * COS( RADIANS( $user_longitude ) -
I currently use Mysql Workbeanch and I want to move to DBeaver as it is an all in for multiple databases. However I use a function to import a CSV from Amazon
My OS: Centos 7 + CLOUDLINUX 7.7 When I Try To Login Mysql From Server [root@server3 ~]# Mysql -u root -h localhost -P 3306 Working ok [root@server3 ~]# Mys
I'm going to rename a MySQL 8.0 table via Flyway SQL script: RENAME TABLE aaa TO bbb; and it's supposed to be run on env many times - but such the script is no
elasticsearch-query