SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE test_tbl ( u_name varchar NOT NULL, u_color varchar NULL ); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'PERFECT'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'PERFECT'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'PERFECT'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'RED'); select * from test_tbl;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear