I tried CREATE TABLE `valorant`.`abilities` ( `PlayerId` INT NOT NULL, `AgentName` VARCHAR(45) NOT NULL, `AbilityName` VARCHAR(45) NOT NULL, `KeyBind` VARCHAR(45) NULL, `Cost` INT NULL, PRIMARY KEY (`PlayerId`, `AgentName`, `AbilityName`)); CREATE TABLE `valorant`.`abilitystats` ( `PlayerId` INT NOT NULL, `AgentName` VARCHAR(45) NOT…
I am creating a "log" system and for this, trigger would be the best way to go I think. The thing is I have a header table (table1) and a line item table (table2). I created 2 new tables (table1log)…
We have a table called "subscriptions" that stores information about salon subscriptions. The table has the following columns: subscriptions id, start_date, end_date, subscription_plan_id, salon_id We want to write a query that provides the following information for each month: Date Total…
Supposing there's a portal that shows 10 products on a page. The desired goal is to show up to 3 randomly chosen "is_featured" products on the first page among other products if they exist. If not, show just 10 regular…
I'm trying to execute a spring batch made by one job and n step. The Job starts and execute correctly first steps, when it arrives on the 'X' step, it should execute a query on the source database (last 1…
we are dropping a column using mysql alter command but admin has set ndb_allow_copying_alter_table=OFF recently and now while running the alter query we are getting below error: ERROR 1846 (0A000): Implicit copying alter is not supported. Reason:ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to…
I have a table with the following structure: +------+--------------+--------------+ | SHOP | BUY_PROFIT | SELL_PROFIT | +------+--------------+--------------+ | A | 10 | 15 | +------+--------------+--------------+ I need to write select statement to make it look like this: +------+------+--------+ | SHOP…
hi everyone im submitting a form having two fields "time_in" and "time_out" and im trying to get the difference between the two dates using date_diff() i made sure that time_in in the database is in DATE formant and time_out DATE…
Table "skus": plant_species_ids 1,2,3,2,3,1 Table "plant_species" id name 1 Plant 1 2 Plant 2 3 Plant 3 The relevant part of my MySQL code: ... GROUP_CONCAT(plant_species.name SEPARATOR ', ') as plant_species_names ... LEFT JOIN plant_species ON FIND_IN_SET(plant_species.id, skus.plant_species_ids) > 0…
Please explain this situation: I have a mySQL database which is set to have its connection as latin1 and the character set of tables and columns to latin1. I send it UTF-8 encoded data (e.g. from a web form which…