I have a table that contains a customer_id, the product they purchased, the timestamp of the purchase, and the rank of the purchase order. I want to know if there is a way in SQL to get overall percentages for…
I'm learning blind SQLi from website "portswigger" and play labs there.Unfortunately, i don't understand, how SELECT "a" FROM users LIMIT 1 can return column "a", if there isn't any column, named "a"(may be i don understand something). And why is…
DELIMITER $$ USE `db_sp`$$ DROP FUNCTION IF EXISTS `bil`$$ CREATE DEFINER=`root`@`localhost` FUNCTION `bil`(num INT) RETURNS VARCHAR(7) CHARSET latin1 BEGIN DECLARE result VARCHAR(7); CASE num WHEN num > 0 THEN SET result = "Positive"; WHEN num < 0 THEN SET result…
I'm new to Python and stuck with simple task which is now looks not simple at all. So basically the idea is to provide an obfuscated MySQL dump to Dev team. The dump is full of INSERT statements with client…
We (almost) always add a general id column as a primary key while designing sql tables. If a table already contains a unique column, I wonder if we should designate that as the primary key and not use the id…
I have a table having below schema Item:Varchar Date:Date Quantity:Float trasactionid:int Sample Data: Item Date Quantity transactionid Part1 01-01-2023 10 3 Part1 01-01-2023 15 5 Part1 01-01-2023 17 2 Part1 01-01-2023 13 6 Part1 02-01-2023 13 7 Part1 02-01-2023 1…
My aim is to get the last price from a histoy table (History_price) and inject it in a parameter table (param_forex). I have defined the following function: mycursor.execute(f"UPDATE `param_forex` SET `Rate` = %s, `Update_Time` = CURRENT_TIME() WHERE `param_forex`.`Ticker` LIKE %s",…
i have table like this (each row represents an order): order_id date customer_id 11 '2023-01-01 00:03:43' 123 12 '2023-02-01 00:02:43' 456 13 '2023-02-01 00:03:44' 789 14 '2023-04-01 00:03:43' 1230 i tried this: SELECT DATE_FORMAT(date,'%Y-%m') , COUNT(distinct customer_id) as count FROM…
I have a mysql table named 'access' with 2 fields: 'owner_id' and 'date_created_id'. I have another table named 'usersx' with 2 fields: 'id', and 'last_name'. I would like to use a single query to get both last names from the…
I have a database with two tables, ships and officers. A ship has multiple officers. To search for a ship with a specific officer, I have a query like this: SELECT a.id FROM ships AS a LEFT JOIN bridge_officers AS…