Advertisement
sanjiisan

Untitled

Apr 14th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. <?php
  2. //Zapisz w poniższej zmiennej kod zapytań SQL
  3. $query1 = 'UPDATE Cinemas SET address=\'Stadion Narodowy\' WHERE address LIKE \'%Z\';';
  4. $query2 = 'SELECT * FROM Payments WHERE date < (select DATE_SUB(CURDATE(),INTERVAL 4 DAY));';
  5. $query3 = 'UPDATE Movies SET description=\'To Long...\' WHERE AVG(description) > 40;';
  6. $query4 = 'UPDATE Tickets SET price=price*2 WHERE quantity>10;';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement