Advertisement
Thauma

Untitled

Jan 17th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.26 KB | None | 0 0
  1. Create table platnosci123 (
  2. id_zaplaty NUMBER(4) primary key,
  3. przelew NUMBER(4),
  4. przedplata NUMBER(4),
  5. pobranie NUMBER (4)
  6. );
  7.  
  8. INSERT INTO platnosci123
  9. values ('77','2','3','4');
  10.  
  11. update platnosci123
  12. set przelew = przedplata + pobranie
  13. where id_zaplaty=77;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement