Hello I have a DB Query like following select amount, date, denominations, user, time, branch from deposits; Now i see my database started growing up 500k +. Now if i add indexes to these columns in select query will the…
I am trying to set season ranges for specific dates coming from my DTBL_SCHOOL_DATES table. Below is my logic which works based on the year and its region to set the season per a given range. CASE WHEN RTRIM(dtbl_school_dates.local_school_year) =…
I have a server with nginx/fpm/mySQL and multiple WP installations, and I want to dockerize the whole installation; when it comes to WP, it's pretty much crystal clear, each website will be hosted on its own LAMP image, having traefik…
I am trying to connect the zoom api in my projects I install the both of these ( $ composer require firebase/php-jwt OR $ composer require guzzlehttp/guzzle) then i create traits and also create a controller and trying to create…
I have table rank and inside I have five different columns I want to fetch row record where I have maximun value for instance I have a column phd_ratio so I said: SELECT * FROM rank HAVING max(phd_ratio) Meaning I…
I am having a table in my database in which there's a field that holds data in a json format. How can I query records that have/don't have a specific key-value pair in their json? Something like this in pseudo…
I have a table structure like this: Table Name: tbl_inventory_stock id, INT, Primary Key product_id, INT store_id, INT inventory_stok FLOAT The value of a record that I want to update is like this: id: 622 product_id: 2364 store_id: 6 inventory_stok:…
We are trying to use mysql as source db and redis as sink to build an ETL I have specified the sink as redis using following properties debezium.sink.type=redis debezium.sink.redis.batch.size=500 debezium.sink.redis.address=redis:6379 debezium.sink.redis.message.format=compact But starting the debezium is throwing the error that…
So I have two tables : Film : id | title | year | Director Casting : id | title | year | actors So What I am trying to do is to find all the actors that have the…
I have two table 'affiliate_stats' and 'transaction', 'affiliate_stats' have column 'affiliate_sales' varchar(2000) (child table), and 'transaction' have column '_id' varchar(100) primary key (parent table) when I add foerign key to 'affiliate_sales' referenced to '_id' by ALTER TABLE affiliate_stats ADD CONSTRAINTfk_affili_sales…