ДЗ№2
Ярослав
CREATE TABLE publishers(
publisher_id INT NOT NULL AUTO_INCREMENT,
publisher_name VARCHAR(20) NULL,
publisher_rate TINYINT DEFAULT 0,
publisher_email VARCHAR(30) NOT NULL,
PRIMARY KEY(publisher_id)
);
CREATE TABLE genres(
genre_id INT NOT NULL AUTO_INCREMENT,
genre_name VARCHAR(20) NOT NULL,
genre_age_restrictions TINYINT DEFAULT 16,
genre_email VARCHAR(30),
PRIMARY KEY(genre_id)
);
CREATE TABLE prices(
price_id INT NOT NULL AUTO_INCREMENT,
prices_dollar VARCHAR(20),
prices_euro TINYINT,
prices_uah VARCHAR(30),
PRIMARY KEY(price_id)
);
DROP TABLE prices;
CREATE TABLE prices(
price_id INT NOT NULL AUTO_INCREMENT,
prices_dollar SMALLINT,
prices_euro SMALLINT,
prices_uah SMALLINT,
PRIMARY KEY(price_id)
);
SHOW TABLES;
INSERT INTO
genres (genre_name, genre_age_restrictions, genre_email)
VALUES
('cards', 11, 'cards@gmail.com'),
('cards', 11, 'cards@gmail.com'),
('cards', 10, 'cards@gmail.com'),
('cards', 14, 'cards@gmail.com'),
('cards', 15, 'cards@gmail.com'),
('cards', 127, 'cards@gmail.com');
DELETE
FROM genres
WHERE genre_name = 'cards' AND genre_age_restrictions>80;
Have a good day=)