Advertisement
Guest User

Untitled

a guest
May 4th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.79 KB | None | 0 0
  1. INSERT INTO samochody VALUES (ID,'Opel','Astra II',1999,Dostęp);
  2. INSERT INTO samochody VALUES (ID,'Opel','Astra III',2004,Dostęp);
  3. INSERT INTO samochody VALUES (ID,'Skoda','Octavia',2010,Dostęp);
  4. INSERT INTO samochody VALUES (ID,'Mercedes','S-klasa',2014,Dostęp);
  5.  
  6. INSERT INTO samochody VALUES (ID,200,160,100,154,46);
  7. INSERT INTO samochody VALUES (ID,300,240,150,231,69);
  8. INSERT INTO samochody VALUES (ID,400,320,200,308,92);
  9. INSERT INTO samochody VALUES (ID,500,400,250,385,105);
  10.  
  11. INSERT INTO naprawy VALUES (ID, 1, CURRENT_DATE, 400);
  12. INSERT INTO naprawy VALUES (ID, 1, CURRENT_DATE-2, 400);
  13. INSERT INTO naprawy VALUES (ID, 4, CURRENT_DATE, 1900);
  14. INSERT INTO naprawy VALUES (ID, 4, CURRENT_DATE-1, 1000);
  15.  
  16. INSERT INTO wypożyczenia VALUES (ID, 4,  CURRENT_DATE-1, NULL,  NULL, NULL);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement