Advertisement
sergAccount

Untitled

Feb 13th, 2021
924
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.38 KB | None | 0 0
  1. INSERT INTO person ("name") VALUES('Name1');
  2. INSERT INTO person ("name") VALUES('Name2');
  3.  
  4. INSERT INTO person ("name") VALUES('Name3');
  5.  
  6. select id, name from person order by name
  7. select id, name from person order by name desc
  8. select id, name from person where id = 4
  9.  
  10. DELETE FROM person WHERE id=1
  11. DELETE FROM person WHERE id=?
  12. UPDATE person SET name='NEW NAME ' WHERE id= 4
  13.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement