SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE users( id BIGINT PRIMARY KEY, first_name VARCHAR(64) NOT NULL, last_name VARCHAR(64) NOT NULL, email VARCHAR(128) NOT NULL ); INSERT INTO users(id, first_name,last_name,email) VALUES (1, 'Denis', 'Cherv', 'denuska@mail.ru'); INSERT INTO users(id, first_name,last_name,email) VALUES (2, 'Denchik', 'Ch', 'denuska450@mail.ru'); INSERT INTO users(id, first_name,last_name,email) VALUES (3, 'kek', 'lol', 'denuols@mail.ru'); SELECT id, first_name, last_name, email FROM public.users; UPDATE users SET email = 'anything@mail.ru' WHERE id = 1; SELECT id, first_name, last_name, email FROM users WHERE id = 1;