I have created two tables, animation_companies and cartoon_characters. I am given a "document to simulate a request from a supervisor to insert information into a database I have created. The data reads as follows: The Animation_Companies table will contain only…
I'm using Prisma with a MySQL database. This is my code: const thisYear = Number("2023") const newYear = thisYear + 1 const startDate = format(new Date(thisYear, 6, 1), 'yyyy-MM-dd HH:mm:ss') const endDate = format(new Date(newYear, 5, 30), 'yyyy-MM-dd HH:mm:ss') console.log("startDate,…
BOUNTY EDIT: The aspect from rowVersion data type that is important to me is the automatic generation on create and automatic incrementation on update. I don't want to handle the incrementation logic manually in the code side whenever I update…
I'm trying to union two tables and then create one line of information for both of then. My code is: with cte as ( select id, dt_month_transaction, dt_first_transaction, transaction_total, null as dt_month_redemption, null as redemption_total from tb_transaction union select id,…
I'm new to stackoverflow, so in case of any error of formatting, or whatsoever, please let me know. I'm a newbie in SQL so please bare with me. I have two tables: CREATE TABLE Users ( idUser INT NOT NULL…
I'm not able to quite figure out how to capture the changes over time. I have the following: db<>fiddle CREATE TABLE term_changes (load_id int, merchant_id int, load_date date, terms varchar(50)); INSERT INTO term_changes (load_id, merchant_id, load_date, terms) VALUES (1, 1,…
I have an array type column subscription in my table with columns Sample Table +-------+--------+----+----------+ |user_id| Subscription|Activity | +-------+-------------+----------+ |111 |[A,C,B] |20 | |-------+-------------+----------+ |222 |[C,A] |10 | |-------+-------------+----------+ |333 |[B] | 5 | +-------+-------------+----------+ I want to change my…
I'm curious why the following two expressions have a different result -- one NULL and the other TRUE: postgres=# select array[1,null]=array[1,null]; ?column? ---------- t (1 row) postgres=# select (1,null)=(1,null); ?column? ---------- (1 row) What's the reasons for this? And in…
I have a table containing several references to the same posts, themselves containing several references to the same languages like so : postId language name value 1 en title Post 1 title 1 en body This is the content for…
I have designed a PurchaseOrder table - with partioning on CreatedDate column - In Visual Studion Data Tool as follow: CREATE TABLE [dbo].[PurchaseOrder] ( [IdGlobal] UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), [IdLocal] BIGINT NOT NULL, [CreatedDate] DATE DEFAULT (getdate()) NOT NULL,…