I have a project developed with PHP and I want to move it inside a Docker container. I want to import database automatically inside Dockerfile. If I import the database after building the container all works fine (docker exec -it…
I have the following table create table summry( id varchar(12), Desc varchar(50), Qty decimal(25), code varchar(20), Date int, Days int) Days is calculated based on Date for that id and Code. For ex:if id-294 code-123 has Date 16/1 then Days…
I am currently working on a deployment script to backup my cluster resources and data. To test the script, I created a MySQL deployment and added data to the database to test if the resources and data are moved to…
I have created mysql instance v-8.4 in gcp with ssl. But it is not able to connect to app engine. When I connect to mysql using command line in google cloud shell, after that it connects with app engine as…
So I am dealing with a project where we have entities that have a name, and while multiple entities can have the same name only one of those entities can be active at a time. Therefore for every update/insert if…
The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query EmpID EmpName Department 1 John Accounting 2 Jenn Purchasing I…
I'm having a hard time understanding the behavior of my queries. Given following tables: CREATE TABLE messages ( id BINARY(16) NOT NULL PRIMARY KEY, chat_id VARCHAR(128) NOT NULL, author_id VARCHAR(128) NOT NULL, created_at BIGINT SIGNED NOT NULL, content VARCHAR(500) CHARACTER…
There is a request like this: SELECT * FROM `pet` WHERE (`unite_id` IS NULL) AND ((`status`=1) OR ((`status`=4) AND (`delete_reason` IN (1, 2, 5)))) AND ((`pet`.`latitude` BETWEEN '55.750958149654984' AND '55.76893750736974') AND (`pet`.`longitude` BETWEEN '37.416257858276374' AND '37.432994842529304')) ORDER BY `premium_on` DESC,…
I have these 3 tables: CREATE TABLE Fair( Title varchar(100), Year int, PRIMARY KEY(Titolo, Anno), ); CREATE TABLE Animal( ID int PRIMARY KEY, Species varchar(100), Name varchar(100), ); CREATE TABLE Participation( Fair_Title varchar(100), Fair_Year int, Animal_ID int, FOREIGN KEY(Fair_Title, Fair_Year)…
I have a situation where we are storing tags in a JSON array, and the client started using this as a key-value store. I now need to add a way to search this data case-insensitively. As an example, if the…