K
I have 3 tables
User
Book
UserBooks (it's a relation betwen User and Books)
I need to know wich books is not related to a given userId

Size: a a a
K

YZ
YZ
YZ
LN
LN
AI
LN
YZ
YZ
YZ
YZ
LN
YZ
LN
tarifes (`id` INTEGER NOT NULL auto_increment , ident INTEGER, name VARCHAR(255), createdAt DATETIME NOT NULL, updatedAt DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;tarifespod_tarifes (`id` INTEGER NOT NULL auto_increment , price DECIMAL, name VARCHAR(255), tarifId INTEGER, createdAt DATETIME NOT NULL, updatedAt DATETIME NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (`tarifId`) REFERENCES tarifes (`id`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB;pod_tarifesLN
LN
YZ
CREATE TABLE IF NOT EXISTS tarifes(
`id` INTEGER NOT NULL auto_increment,
ident INTEGER, name VARCHAR(255),
createdAt DATETIME NOT NULL,
updatedAt DATETIME NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
SHOW INDEX FROM tarifes;
CREATE TABLE IF NOT EXISTS pod_tarifes(
`id` INTEGER NOT NULL auto_increment ,
price DECIMAL, name VARCHAR(255),
tarifId INTEGER,
createdAt DATETIME NOT NULL,
updatedAt DATETIME NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`tarifId`) REFERENCES tarifes (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB
YZ
YZ