Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
--создаем таблицу с информаией о клиенте CREATE TABLE Clients (Ow_id NUMBER, Birth_dt DATE, Email_flg NUMBER, Mobile_app_flg NUMBER ); --наполняем ее даными INSERT ALL INTO Clients (Ow_id, Birth_dt, Email_flg, Mobile_app_flg) VALUES (123, '17.06.2022', 0, 1) INTO Clients (Ow_id, Birth_dt, Email_flg, Mobile_app_flg) VALUES (124, '25.06.2022', 1, 1) INTO Clients (Ow_id, Birth_dt, Email_flg, Mobile_app_flg) VALUES (142, '16.06.2022', 1, 1) INTO Clients (Ow_id, Birth_dt, Email_flg, Mobile_app_flg) VALUES (143, '17.06.2022', 0, 1) INTO Clients (Ow_id, Birth_dt, Email_flg, Mobile_app_flg) VALUES (144, '17.06.2022', 0, 0) INTO Clients (Ow_id, Birth_dt, Email_flg, Mobile_app_flg) VALUES (145, '29.06.2009', 0, 0) SELECT * FROM Clients;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear