1 2 3 4 5
| INSERT INTO type_produit(id_type,libelle_type) VALUES (1, 'Boisson'),(2, 'Produit Laitier');
INSERT INTO produit(id_produit,id_type, libelle_produit) VALUES (1,1, 'produit1'),(2,1, 'produit2'),(3,1, 'produit3'),(4,1, 'produit4');
INSERT INTO vente (id_vente, id_produit,quantite, dates) VALUES (1, 1, 3521, '2008-01-01 02:02:00'),(2, 1, 4325, '2008-02-01 02:02:01'),(3, 1, 3854, '2008-03-01 02:02:02'),(4, 1, 4002, '2008-04-01 02:02:03'),(5, 1, 4213, '2008-05-01 02:02:04'),(6, 1, 2856, '2008-06-01 02:02:05'),(7, 1, 3842, '2008-07-01 02:02:06'),(8, 1, 4125, '2008-08-01 02:02:07'),(9, 1, 3954, '2008-09-01 02:02:08'),(10, 1, 3845, '2008-10-01 02:02:09'),(11, 1, 3910, '2008-11-01 02:02:10'),(12, 1, 3601, '2008-12-01 02:02:11'),(13, 2, 3856, '2008-01-01 02:02:00'),(14, 2, 4232, '2008-02-01 02:02:01'),(15, 2, 4125, '2008-03-01 02:02:02'),(16, 2, 4102, '2008-04-01 02:02:03'),(17, 2, 3986, '2008-05-01 02:02:04'),(18, 2, 4025, '2008-06-01 02:02:05'),(19, 2, 3965, '2008-07-01 02:02:06'),(20, 2, 4023, '2008-08-01 02:02:07'),(21, 2, 3852, '2008-09-01 02:02:08'),(22, 2, 4015, '2008-10-01 02:02:09'),(23, 2, 4023, '2008-11-01 02:02:10'),(24, 2, 3803, '2008-12-01 02:02:11'),(25, 3, 2508, '2008-01-01 02:02:00'),(26, 3, 2325, '2008-02-01 02:02:01'),(27, 3, 3012, '2008-03-01 02:02:02'),(28, 3, 2931, '2008-04-01 02:02:03'),(29, 3, 2540, '2008-05-01 02:02:04'),(30, 3, 2451, '2008-06-01 02:02:05'),(31, 3, 2365, '2008-07-01 02:02:06'),(32, 3, 2802, '2008-08-01 02:02:07'),(33, 3, 2732, '2008-09-01 02:02:08'),(34, 3, 2412, '2008-10-01 02:02:09'),(35, 3, 2854, '2008-11-01 02:02:10'),(36, 3, 2812, '2008-12-01 02:02:11'),(37, 4, 3945, '2008-01-01 02:02:00'),(38, 4, 3651, '2008-02-01 02:02:01'),(39, 4, 3543, '2008-03-01 02:02:02'),(40, 4, 2968, '2008-04-01 02:02:03'),(41, 4, 3125, '2008-05-01 02:02:04'),(42, 4, 3025, '2008-06-01 02:02:05'),(43, 4, 3211, '2008-07-01 02:02:06'),(44, 4, 2985, '2008-08-01 02:02:07'),(45, 4, 2856, '2008-09-01 02:02:08'),(46, 4, 3012, '2008-10-01 02:02:09'),(47, 4, 2942, '2008-11-01 02:02:10'),(48, 4, 3215, '2008-12-01 02:02:11'),(49, 1, 3245, '2008-01-01 02:02:00'),(50, 1, 4124, '2008-02-01 02:02:01'),(51, 1, 4002, '2008-03-01 02:02:02'),(52, 1, 3845, '2008-04-01 02:02:03'),(53, 1, 4125, '2008-05-01 02:02:04'),(54, 1, 3120, '2008-06-01 02:02:05'),(55, 1, 3456, '2008-07-01 02:02:06'),(56, 1, 4021, '2008-08-01 02:02:07'),(57, 1, 4213, '2008-09-01 02:02:08'),(58, 1, 4036, '2008-10-01 02:02:09'),(59, 1, 3842, '2008-11-01 02:02:10'),(60, 1, 3752, '2008-12-01 02:02:11'),(61, 2, 3512, '2008-01-01 02:02:00'),(62, 2, 3965, '2008-02-01 02:02:01'),(63, 2, 4315, '2008-03-01 02:02:02'),(64, 2, 3956, '2008-04-01 02:02:03'),(65, 2, 4210, '2008-05-01 02:02:04'),(66, 2, 3965, '2008-06-01 02:02:05'),(67, 2, 4256, '2008-07-01 02:02:06'),(68, 2, 4162, '2008-08-01 02:02:07'),(69, 2, 3362, '2008-09-01 02:02:08'),(70, 2, 4102, '2008-10-01 02:02:09'),(71, 2, 3856, '2008-11-01 02:02:10'),(72, 2, 3967, '2008-12-01 02:02:11'),(73, 3, 2921, '2008-01-01 02:02:00'),(74, 3, 2723, '2008-02-01 02:02:01'),(75, 3, 3114, '2008-03-01 02:02:02'),(76, 3, 3124, '2008-04-01 02:02:03'),(77, 3, 2632, '2008-05-01 02:02:04'),(78, 3, 2745, '2008-06-01 02:02:05'),(79, 3, 2845, '2008-07-01 02:02:06'),(80, 3, 2965, '2008-08-01 02:02:07'),(81, 3, 2865, '2008-09-01 02:02:08'),(82, 3, 2563, '2008-10-01 02:02:09'),(83, 3, 2965, '2008-11-01 02:02:10'),(84, 3, 3012, '2008-12-01 02:02:11'),(85, 4, 4032, '2008-01-01 02:02:00'),(86, 4, 4012, '2008-02-01 02:02:01'),(87, 4, 4301, '2008-03-01 02:02:02'),(88, 4, 3501, '2008-04-01 02:02:03'),(89, 4, 3215, '2008-05-01 02:02:04'),(90, 4, 3145, '2008-06-01 02:02:05'),(91, 4, 3352, '2008-07-01 02:02:06'),(92, 4, 3102, '2008-08-01 02:02:07'),(93, 4, 4021, '2008-09-01 02:02:08'),(94, 4, 3521, '2008-10-01 02:02:09'),(95, 4, 3017, '2008-11-01 02:02:10'),(96, 4, 3452, '2008-12-01 02:02:11'); |
Partager