SHARE
TWEET

Untitled

a guest Oct 21st, 2019 304 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create database `sklep`;
  2.  
  3. use `sklep`;
  4.  
  5. create table `promocje`(
  6. `idpromocji` int,
  7. `idksiazki` int,
  8. `rodzajpromocji` varchar(100),
  9. `cenawpromocji` float
  10. );
  11.  
  12. alter table `promocje`
  13. add primary key(`idpromocji`);
  14.  
  15. alter table `promocje`
  16. modify `idpromocji` int auto_increment;
  17.  
  18. INSERT INTO `promocje` (`rodzajpromocji`) values ('walentynkowa'),('swiateczna'),('urodzinowa');
  19.  
  20. update `promocje`
  21. set `cenawpromocji`='15.99', `rodzajpromocji`='swiateczna'
  22. where `idpromocji`='3';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top