I am using Cubecart for a customer website, and frustratingly they have used comma separated values to associate certain option IDs to products. I now need to create a custom table which gets all this information out into a useful…
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…
I have 2 tables, which represent one to many relationship CREATE TABLE a( id int, a_text varchar(255) ); And CREATE TABLE b( a_id int, b_text varchar(255) ); Where column b_text contains enum values. Table A: Id a_text 1 'text 1'…
I have two tables, both tables have a column with the same value. Table 1 |sn|Name |Age |Address |Date | |1 |Name 1|Age 1|Address 1|18-05-2023| |2 |Name 2|Age 2|Address 2|21-05-2023| |3 |Name 3|Age 3|Address 3|21-05-2023| |4 |Name 4|Age 4|Address 4|21-05-2023|…
my_tickets +-----------+---------+ | ticket_id | user_id | +-----------+---------+ | 186 | 2 | | 187 | 2 | | 188 | 2 | | 253 | 33 | | 254 | 33 | | 256 | 33 | | 261…
I'm getting an error while attempting to populate my table with the following query: INSERT INTO d_table SELECT category.name, film_category.film_id FROM category INNER JOIN film_category.film_id ON film_category.category_id = category.category_id It returns an error "relation film_category.film_id does not exist" These are…
As it is right now ->join() is a query builder so it wouldn't using Model that has SoftDelete, there is too many codes that used join in my project so I don't want to manually replace it all with eager…
I'm currently trying to find a way to return all rows in which there is at least one other row with the same values in any number of columns and unique values in any number of other columns. I want…
I have a table with orders (for each order (transaction_id) there are client_id and item_id and quantity) I need to find completely identical orders for a set of goods and their quantity in the order CREATE TABLE IF NOT EXISTS…
This does not solve my problem SQL Join to the latest record I want to join tables in such a way that it fetches only the latest record from one of the tables using MySQL and also count the read_reciept…