sql - lixidaydayup/plan GitHub Wiki

select

select name,age from person where id = 5;

select name from person where age > 20;

select person.name, person.age, address.street from person left out join address on person.address_id = address.address_id 

insert

insert into person(name,age) values ("lixi",23);

delete

delete from person where name = 'lixi';

update

update person set age=23, name='lixi' where age=24 and name='lixi2';