[sql] ArinaTest
Viewer
- CREATE DATABASE `1plus1`;
- CREATE TABLE firm_name(
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- name CHAR(100) NOT NULL,
- advertise CHAR(100) NOT NULL,
- budget INT NOT NULL
- )
- CREATE TABLE advertising(
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- TYPE CHAR(100) NOT NULL,
- TIME INT NOT NULL,
- DAY CHAR(40) NOT NULL
- )
- CREATE TABLE day_time(
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- part CHAR(100) NOT NULL,
- price INT NOT NULL,
- )
- INSERT INTO firm_name (name, advertise, budget) VALUES ("Rozetka", "firm", "1000")
- INSERT INTO firm_name (name, advertise, budget) VALUES ("Моршинська","product", "1500")
- INSERT INTO firm_name (name, advertise, budget) VALUES ("LOREAL", "firm", "500")
- INSERT INTO firm_name (name, advertise, budget) VALUES ("GLOVO", "firm", "250")
- INSERT INTO advertising (TYPE, TIME, DAY) VALUES ("Short", "First part","12-15")
- INSERT INTO advertising (TYPE, TIME, DAY) VALUES ("Short", "Second part", "15-21")
- INSERT INTO advertising (TYPE, TIME, DAY) VALUES ("Long", "Second part", "21-04")
- INSERT INTO advertising (TYPE, TIME, DAY) VALUES ("Long", "First part" , "04-08")
- INSERT INTO day_time (part, price) VALUES ("First part", "300")
- INSERT INTO day_time (part, price) VALUES ("Second part", "150")
- SELECT FROM 'firm_name' ORDER BY 'name' ASC
Editor
You can edit this paste and save as new: