I wrote a SQL query that outputs a list of clan ids and their positions. SET @n := 0; SELECT id, @n := @n + 1 AS position FROM ( SELECT clans.id, SUM(clans_members.xp) AS xps FROM clans INNER JOIN clans_members…
I'm working on MySQL workbench and I would like to find the top-selling products by types of buyers. First I categorized customers based on their buying activity. If a person made a purchase only on 1/1, it's a first-time buyer.…
I'm try to get the output of How many times each location is used for clus meetings, trainings, and competitions for my database. I figured out how to do each separately but am having trouble combining them into one output…
Hi i have the next SP: CREATE DEFINER=`admin`@`%` PROCEDURE `get_products_id`(IN column_name VARCHAR(50)) BEGIN SET @column_name = column_name; SET @query = CONCAT('SELECT `p`.`id` AS `id`, `p`.`image` AS `image`, `p`.`globalClasification` AS `globalClasification`, `p`.`itemId` AS `itemId`, `p`.`code` AS `code`, `p`.`providerCode` AS `providerCode`, `p`.`description`…
I'm very much a newbie to programming. I am trying to update my table column labelled 'bonus' with a new value of 505.99 if two conditions are met: if the givenname is Mary and their bonus is currently 155.99, or…
I need to select a value from a column in the table as a name of the another column in mysql for ex :: select column AS (select column from table where id = 1) from table; it give me…
I did setup of a MySQL database on AWS free instance t2 micro by following the link: https://towardsdatascience.com/running-mysql-databases-on-aws-ec2-a-tutorial-for-beginners-4301faa0c247 Now I am able to connect to database using MySql Workbench and SSH with pem file. But What should be the connection…
I need to write a SQL trigger whenever (engage_step_user_response) table (response_json) column updated, I need to increase no of retakes by one in the retakes column. I have tried to write a SQL trigger referencing some details. But it doesn't…
I have a quick question regarding migrating large data sample sets from my local device to an Amazon Aurora RDS (no DMS approach). So basically I am working on a Proof of Concept and I need to populate an Amazon…
this is myTable clientId, itemId, sellId primary is on clientId and there is also btree index no uniqe on sellId now i have part of very slow query LEFT OUTER JOIN myTable wl ON wl.itemId= ld.itemId and wl.clientId= @clientId question…