Not a member yet? Why not Sign up today
Create an account  

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
mx3.fr database

#1

Please login or register to view this content

Reply

#2
(03-05-2024, 11:21 AM)letmein Wrote: mx3.fr database
Nutrition Sportive

format: sql
data: 02-2024
all rows: 33083432
size: 2.2 Gb
users: 3Ok

The .sql file is big, but many rows are not useful
so I "extract" a 33K file, with the more useful rows
data are mostly from 2018 to 2024

Sample:
Code:
INSERT INTO `ns_address` (`id_address`, `id_country`, `id_state`, `id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `alias`, `company`, `lastname`, `firstname`, `address1`, `address2`, `postcode`, `city`, `other`, `phone`, `phone_mobile`, `vat_number`, `dni`, `date_add`, `date_upd`, `active`, `deleted`) VALUES

(6, 8, 0, 5, 0, 0, 0, 'Mon adresse', '', 'DURANT', 'jean marc', '3 rue des acacias', '', '44000', 'NANTES', '', '', '0634642859', '', '', '2013-03-07 13:39:39', '2013-03-07 13:39:39', 1, 0),
(7, 8, 0, 6, 0, 0, 0, 'Mon adresse', '', 'MARIE', 'Pourias', '15 rue des acacias', '', '85000', 'LA ROCHE SUR YON', '', '0634645589', '', '', '', '2013-03-18 11:14:00', '2013-03-18 11:14:00', 1, 0),
(8, 8, 0, 7, 0, 0, 0, 'MAISON', '', 'RIVAL', 'ELISABETH', '16 IMPASSE DES COQUELICOTS', '', '85100', 'LES SABLES D OLONNE', '', '', '0607242067', '', '', '2013-03-21 10:48:28', '2013-03-21 10:48:28', 1, 0),
(57, 8, 0, 47, 0, 0, 0, 'Billing address', '', 'HENRIO', 'Erick', '3 rue du marronnier', '', '45390', 'BROMEILLES', NULL, '02.38.33.58.71', '', NULL, NULL, '2012-02-12 21:05:20', '2013-02-11 01:41:29', 1, 0),
(66, 8, 0, 55, 0, 0, 0, 'Billing address', '', 'REGLIN', 'Vincent', '18, Rue des Bouvreuils', '', '72000', 'LE MANS', '', '0243234337', '', '', '', '2013-01-16 16:10:42', '2018-07-22 17:11:17', 1, 1),
(78, 8, 0, 67, 0, 0, 0, 'Billing address', '', 'KINNEN', 'sylvain', '8 allée des historiens ', '', '59650', 'VILLENEUVE D\'ASCQ', NULL, '', '', NULL, NULL, '2011-01-30 01:14:52', '2013-02-27 01:57:01', 1, 0),
(106, 8, 0, 91, 0, 0, 0, 'Billing address', '', 'PAMBOUTZOGLOU', 'serge', 'Avenue Justin bec l\'orée de Montpellier', '', '34680', 'SAINT GEORGES D\'ORQUES ', '', '0689703214', '', '', '', '2012-08-29 16:08:00', '2018-03-07 10:39:52', 1, 0),
(107, 8, 0, 92, 0, 0, 0, 'Billing address', '', 'CORNEIN', 'louis', '8 rue de la colline ', '', '54360', 'MONT SUR MEURTHE', NULL, '', '', NULL, NULL, '2011-02-14 10:04:33', '2013-02-16 16:42:29', 1, 0),
(111, 8, 0, 95, 0, 0, 0, 'Billing address', 'DELPEYRAT FOIE GRAS', 'PUJOL', 'laurent', 'ZA LA TEOULERE BP 229', '', '40282', 'SAINT PIERRE DU MONT', '', '0661635526', '', '', '', '2016-02-11 13:45:00', '2018-03-07 12:56:33', 1, 0),
(119, 8, 0, 102, 0, 0, 0, 'Billing address', 'TERRENA', 'JONCHERE', 'Bruno', 'ZI ARROUET ', '', '49170', 'SAINT GEORGES SUR LOIRE', '', '0670039092', '', '', '', '2011-02-18 10:25:38', '2018-03-07 10:40:02', 1, 0),
(120, 8, 0, 102, 0, 0, 0, 'Shipping address', '', 'JONCHERE', 'Bruno', '9 RUE DU JUBILE ', '', '49170', 'SAINT MARTIN DU FOUILLOUX', '', '0670039092', '', '', '', '2011-02-18 10:28:35', '2018-03-07 10:40:10', 1, 0),
(127, 8, 0, 108, 0, 0, 0, 'PROFESSIONNEL', '', 'BOFFO', 'Franck', 'Zone d\'Activité SIRIUS - CD 47', '', '57360', 'AMNEVILLE', '', '0680573730', '0680573730', '', '', '2011-02-21 12:11:36', '2015-02-22 19:49:58', 1, 0),
(135, 8, 0, 115, 0, 0, 0, 'Billing address', '', 'LYON', 'Francois', '4 avenue de Toutevoie ', '', '60270', 'GOUVIEUX', '', '0614373465', '', '', '', '2011-02-25 12:55:25', '2014-01-18 18:30:21', 1, 0),
Reply



Forum Jump:


Users browsing this thread:
3 Guest(s)