SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table test_w (cnt int, empl varchar(50), id int); ------------------------------------------------------ insert into test_w values (20, 'Слесарь', 2); insert into test_w values (30, 'Монтажник', 2); insert into test_w values (20, 'Монтажник', 3); insert into test_w values (50, 'Уборщик', 3); insert into test_w values (20, 'Директор', 1); ------------------------------------------------------ select t1.* from test_w t1; ------------------------ update test_w tw set tw.cnt = 10, tw.empl = 'директор 1' where tw.id = 1; ------------------------------------------------------ select t1.* from test_w t1;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear