SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE MY_VACATION ( number INT, amount DEC (6, 2), date_expense DATE not null, type_expense VARCHAR (255) not null, PRIMARY KEY (type_expense) ); Insert into MY_VACATION values (1, 370.00, '2022-08-20', 'tickets for travel'), (2, 110.00, '2022-08-22', 'food'), (3, 150.00, '2022-08-23', 'entertainments'), (4, 55.70, '2022-08-25', 'snecks'); Insert into MY_VACATION (amount, date_expense, type_expense) VALUES (0.00, '2022-08-30', 'aquapark'), (130.00, '2022-08-29', 'food1'); DELETE FROM MY_VACATION WHERE type_expense= 'food' or type_expense= 'food1'; SELECT *FROM MY_VACATION;