I have this table using InnoDB as engine: create table if not exists Playlists( UserId bigint unsigned not null, Title varchar(50) not null, IsPublic bool not null, primary key (UserId, Title), foreign key (UserId) references Users(Id) on delete cascade on…
I'm trying to identify in my database which users are using other users' "IDs". MY DB: ID | NAME | CARDNUMBER | SHOPNUMBER 1 JO 1234 73839 2 ANDY 9876 79487 3 KARL 5432 87399 4 MIKE 1234 53637 I…
I wish to achieve something like this from a MYSQL SELECT query I wish to group the results from the select in 500 rows (per batch) and have a column called group (or anything) for the key to the group…
When I run this following select query on the command line in Mysql: SELECT date_sent FROM books; I get this sort of result (eg) | 2024-10-06 | but if I run the same select query from inside python: # Select…
I need to parse JSON using Oracle SQL select. Here is my JSON: {"result":[ { "field_name1":{"display_value":"TEST1","link":"https://test1.com","value":"abcd"}, "field_name2":{"display_value":"","link":"","value":""}, "field_name3":{"display_value":"TEST3","link":"https://test3.com","value":"efgh"}, "field_name4":{"display_value":"TEST4","link":"https://test3.com","value":"ijkl"} } ]} I want to get results as follows: field_name1:abcd field_name3:efgh field_name4:ijkl excluding those that have nulls in the value. How…
I unexpectedly executed the following query in MySQL and got a strange result: SELECT 'a' 'b' 'c' FROM dual; The result shows 'a' as the column name and 'abc' as the value. I am puzzled by this behavior. What is…
I'm able to create the table using CTE with select statement like below but it's not behaving like I want. with sorting(item_code, index) as ( select (10001, 1), (10002, 2) ) select * from sorting Table result : item_code|index |…
I want to loop through columns ['A', 'B', 'C'] and pass the column names to a select statement in SQL, such as SELECT * FROM table_name WHERE table_name.`A` IS NULL Thus each select statement would yield a result set based…
I am Working on project, where I am using two queries to get the result i wanted to process. Query 1 SELECT MID FROM PMS.MACHINE WHERE STATUS=1 AND MID !=0; Query 2 SELECT MID,COUNT(STATUS) AS QUEUE FROM PMS.QUEUE WHERE STATUS=0…
I have a result set of parent categories and subcategories. I want to exclude all parent categories if a subcategory exists in the results. What I would do is using a NOT IN in the query, but that requires a…