API tools faq
paste
Guest User

Untitled

a guest
Jan 16th, 2018
89
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.08 KB | None | 0 0
raw download clone embed print report
  1. Delete From LignesCde;
  2. Delete From Commande;
  3. Delete From Stock;
  4. Delete From Article;
  5. Delete From Categorie;
  6. Delete From Client;
  7.  
  8. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('STROZZI','Alexa', '11 bis rue Charrue', '84000', 'AVIGNON', '0490860206');
  9.  
  10. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('AUTRET','Carine', '1135 rte Roch Nivelen', '29470', 'PLOUGASTEL', '');
  11. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('GARNIER','Francois', '2 r Racine', '86000', 'POITIERS', '0549503110');
  12. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('ROBLOT','Christine', '12 imp Fernand Raynaud', '21800', 'CHEVIGNY', '0380466666');
  13. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('PERON','Herve', 'all Guigonniere', '69290', 'SAINT GENIS', '0877854504');
  14. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('KORN','Olivier', '18 r Vosges', '67600', 'SELESTAT', '0388825698');
  15. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('BRUYAT','Geraldine', '7 r Midi', '91700', 'ST GENEVIEVE', '0169511225');
  16. Insert Into Client (Nom, Prenom, Adresse, CodePostal, Ville, Tel) values ('DESJEANS','Pierre', '138 r Georges Clemenceau', '86190', 'VOUILLE', '0546852890');
  17. Insert Into Client (Nom, Prenom) values ('CCC','Delphine');
  18.  
  19. Insert Into Categorie (LibelleCat) values ( 'Micros Complets');
  20.  
  21. Insert Into Categorie (LibelleCat) values ( 'Composants');
  22. Insert Into Categorie (LibelleCat) values ( 'Accessoires');
  23. Insert Into Categorie (LibelleCat) values ( 'Peripheriques');
  24. Insert Into Categorie (LibelleCat) values ( 'Logiciels');
  25.  
  26.  
  27.  
  28. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('AB01','Multi-media',1285.00,1);
  29. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('AB21','Developpeur Multi-media',1500.00,1);
  30. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('CL06','Clavier français',20.00,4);
  31. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('CM14','Carte Mere',250.00,2);
  32. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('CR450','Carte Reseau',50.00,2);
  33. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('CS11','Carte Son SB',100.00,2);
  34. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('CV774','Carte Video SVGA',75.00,2);
  35. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('IMP41','Imprimante Laser',125.00,4);
  36. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('MON45','Moniteur Couleur',200.00,4);
  37. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('MS215','Windows Vista',100.00,5);
  38. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('MS685','Windows 2003 Server',150.00,5);
  39. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('PRC1','Processeur Celeron',200.00,2);
  40. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('PRC2','Processeur Athlon',250.00,2);
  41. Insert Into Article (RefArt, DesignationArt, PrixHTArt, CodeCat) values ('PRC4','Processeur Pentium IV',300.00,2);
  42.  
  43.  
  44.  
  45. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'AB01', 'D1', 20, 2, 50);
  46. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'AB01', 'D2', 5, 2, 20);
  47. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'AB01', 'D3', 10, 5, 50);
  48. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'AB01', 'D4', 10, 5, 100);
  49. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'CM14', 'D1', 30, 10, 100);
  50. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'CM14', 'D2', 10, 5, 50);
  51. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'CS11', 'D1', 50, 10, 100);
  52. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'CS11', 'D3', 60, 10, 300);
  53. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'MS685', 'D1', 20, 10, 200);
  54. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'MS685', 'D3', 50, 10, 350);
  55. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'PRC2', 'D4', 7, 5, 40);
  56. Insert Into Stock (RefArt, Depot, QteStock, StockMini, StockMaxi) values ( 'PRC4', 'D1', 6, 5, 50);
  57.  
  58.  
  59. Insert Into Commande (NumCde, DateCde, EtatCde, NumCli) values ( 1350, '1999/05/28', 'SO', 2);
  60. Insert Into Commande (NumCde, DateCde, EtatCde, NumCli) values ( 1351, '1999/06/13', 'SO', 2);
  61. Insert Into Commande (NumCde, DateCde, EtatCde, NumCli) values ( 1352, '2000/02/02', 'LI', 2);
  62. Insert Into Commande (NumCde, DateCde, EtatCde, NumCli) values ( 1353, '2000/04/23', 'LI', 1);
  63. Insert Into Commande (NumCde, DateCde, EtatCde, NumCli) values ( 1354, '2000/11/26', 'LI', 4);
  64. Insert Into Commande (NumCde, DateCde, NumCli) values ( 1355, '2001/05/11', 2);
  65. Insert Into Commande (NumCde, DateCde, TauxRemise, NumCli) values ( 1356, '2001/05/11', 5, 5);
  66. Insert Into Commande (NumCde, DateCde, NumCli) values ( 1357, '2001/12/13', 6);
  67. Insert Into Commande (NumCde, DateCde, TauxRemise, NumCli) values ( 1358, '2002/03/17', 2, 7);
  68. Insert Into Commande (NumCde, DateCde, NumCli) values ( 1359, '2002/07/06', 6);
  69. Insert Into Commande (NumCde, DateCde, TauxRemise, NumCli) values ( 1360, '2002/05/30', 3, 2);
  70.  
  71.  
  72. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1350, 1, 1, 'AB01');
  73. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1350, 2, 3, 'CL06');
  74. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1350, 3, 1, 'PRC1');
  75. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1351, 1, 2, 'IMP41');
  76. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1352, 1, 1, 'AB21');
  77. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1352, 2, 1, 'CR450');
  78. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1352, 3, 1, 'CS11');
  79. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1353, 1, 3, 'CL06');
  80. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1354, 1, 1, 'AB01');
  81. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1355, 1, 2, 'MON45');
  82. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1355, 2, 2, 'CV774');
  83. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1355, 3, 2, 'CR450');
  84. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1356, 1, 3, 'AB01');
  85. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1357, 1, 2, 'CV774');
  86. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1358, 1, 3, 'CS11');
  87. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1358, 2, 1, 'CR450');
  88. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1359, 1, 1, 'CM14');
  89.  
  90. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1359, 2, 1, 'PRC2');
  91.  
  92. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1359, 3, 1, 'MS215');
  93.  
  94. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 1, 1, 'AB01');
  95. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 2, 2, 'AB21');
  96.  
  97. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 3, 3, 'CL06');
  98. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 4, 2, 'CM14');
  99.  
  100. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 5, 2, 'CR450');
  101.  
  102. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 6, 2, 'CS11');
  103.  
  104. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 7, 2, 'CV774');
  105.  
  106. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 8, 2, 'IMP41');
  107. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 9, 2, 'MON45');
  108.  
  109. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 10, 2, 'MS215');
  110.  
  111. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 11, 4, 'MS685');
  112.  
  113. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 12, 1, 'PRC1');
  114. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 13, 1, 'PRC2');
  115.  
  116. Insert Into LignesCde (NumCde, NumLig, QteCde, RefArt) values (1360, 14, 3, 'PRC4');
Add Comment
Please, Sign In to add comment
Public Pastes
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!