1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
| --------------
SET AUTOCOMMIT = 0
--------------
--------------
START TRANSACTION
--------------
--------------
DROP DATABASE IF EXISTS `base`
--------------
--------------
CREATE DATABASE `base`
DEFAULT CHARACTER SET `latin1`
DEFAULT COLLATE `latin1_general_ci`
--------------
--------------
DROP TABLE IF EXISTS `en_per_ext`
--------------
--------------
CREATE TABLE `en_per_ext` (
PER_TYPE_LB varchar(255) NOT NULL,
PER_CIVILITE_LB varchar(255) NOT NULL,
PER_USAGE_LB varchar(255) NOT NULL,
PER_PAT_LB varchar(255) NOT NULL,
PER_MARI_LB varchar(255) NOT NULL,
PER_PRENOM_LB varchar(255) NOT NULL,
PER_NAISSANCE_DT varchar(255) NOT NULL,
PER_LIEU_NAISSANCE_LB varchar(255) NOT NULL,
PER_DPT_NAISSANCE_LB varchar(255) NOT NULL,
PER_NATIONALITE_LB varchar(255) NOT NULL,
PER_SITUATION_FAM_LB varchar(255) NOT NULL,
PER_ENFANTS_NB varchar(255) NOT NULL,
PER_TYPE_FORM_LB varchar(255) NOT NULL,
PER_ANNEE_ENTREE_ENFA_NB varchar(255) NOT NULL,
PER_GRADE_LB varchar(255) NOT NULL,
PER_SECTION_LB varchar(255) NOT NULL,
PER_NATURE_LB varchar(255) NOT NULL,
PER_OPTION_LB varchar(255) NOT NULL,
PER_OBS_LB varchar(255) NOT NULL,
PER_ADR_FAM_LB varchar(255) NOT NULL,
PER_CP_FAM_LB varchar(255) NOT NULL,
PER_VILLE_FAM_LB varchar(255) NOT NULL,
PER_TEL_FAM_LB varchar(255) NOT NULL,
PER_FAX_LB varchar(255) NOT NULL,
PER_EMAIL_LB varchar(255) NOT NULL,
PER_ADR_FORM_LB varchar(255) NOT NULL,
PER_CP_FORM_LB varchar(255) NOT NULL,
PER_VILLE_FORM_LB varchar(255) NOT NULL,
PER_TEL_FORM_LB varchar(255) NOT NULL,
PER_RIB_ETAB_LB varchar(255) NOT NULL,
PER_RIB_GUICHET_LB varchar(255) NOT NULL,
PER_RIB_COMPTE_LB varchar(255) NOT NULL,
PER_RIB_CLE_LB varchar(255) NOT NULL,
PER_RIB_DOMICILIATION_LB varchar(255) NOT NULL,
PER_TEL_URG_LB varchar(255) NOT NULL,
ETA_NUM_CDN1 varchar(255) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=`utf8` COLLATE=`utf8_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
LOAD DATA INFILE 'E:\\22.MySql\\1.Exercices\\Ex_20\\export_gestdep.csv'
INTO TABLE en_per_ext
CHARACTER SET utf8
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(PER_TYPE_LB, PER_CIVILITE_LB, PER_USAGE_LB, PER_PAT_LB, PER_MARI_LB, PER_PRENOM_LB, PER_NAISSANCE_DT, PER_LIEU_NAISSANCE_LB, PER_DPT_NAISSANCE_LB, PER_NATIONALITE_LB, PER_SITUATION_FAM_LB, PER_ENFANTS_NB, PER_TYPE_FORM_LB, PER_ANNEE_ENTREE_ENFA_NB, PER_GRADE_LB, PER_SECTION_LB, PER_NATURE_LB, PER_OPTION_LB, PER_OBS_LB, PER_ADR_FAM_LB, PER_CP_FAM_LB, PER_VILLE_FAM_LB, PER_TEL_FAM_LB, PER_FAX_LB, PER_EMAIL_LB, PER_ADR_FORM_LB, PER_CP_FORM_LB, PER_VILLE_FORM_LB, PER_TEL_FORM_LB, PER_RIB_ETAB_LB, PER_RIB_GUICHET_LB, PER_RIB_COMPTE_LB, PER_RIB_CLE_LB, PER_RIB_DOMICILIATION_LB, PER_TEL_URG_LB, ETA_NUM_CDN1)
--------------
--------------
select * from en_per_ext
--------------
+-------------+-----------------+--------------+------------+-------------+---------------+------------------+-----------------------+----------------------+--------------------+----------------------+----------------+------------------+--------------------------+--------------+----------------+---------------+---------------+------------+----------------+---------------+------------------+----------------+------------+--------------+-----------------+----------------+-------------------+-----------------+-----------------+--------------------+-------------------+----------------+--------------------------+----------------+--------------+
| PER_TYPE_LB | PER_CIVILITE_LB | PER_USAGE_LB | PER_PAT_LB | PER_MARI_LB | PER_PRENOM_LB | PER_NAISSANCE_DT | PER_LIEU_NAISSANCE_LB | PER_DPT_NAISSANCE_LB | PER_NATIONALITE_LB | PER_SITUATION_FAM_LB | PER_ENFANTS_NB | PER_TYPE_FORM_LB | PER_ANNEE_ENTREE_ENFA_NB | PER_GRADE_LB | PER_SECTION_LB | PER_NATURE_LB | PER_OPTION_LB | PER_OBS_LB | PER_ADR_FAM_LB | PER_CP_FAM_LB | PER_VILLE_FAM_LB | PER_TEL_FAM_LB | PER_FAX_LB | PER_EMAIL_LB | PER_ADR_FORM_LB | PER_CP_FORM_LB | PER_VILLE_FORM_LB | PER_TEL_FORM_LB | PER_RIB_ETAB_LB | PER_RIB_GUICHET_LB | PER_RIB_COMPTE_LB | PER_RIB_CLE_LB | PER_RIB_DOMICILIATION_LB | PER_TEL_URG_LB | ETA_NUM_CDN1 |
+-------------+-----------------+--------------+------------+-------------+---------------+------------------+-----------------------+----------------------+--------------------+----------------------+----------------+------------------+--------------------------+--------------+----------------+---------------+---------------+------------+----------------+---------------+------------------+----------------+------------+--------------+-----------------+----------------+-------------------+-----------------+-----------------+--------------------+-------------------+----------------+--------------------------+----------------+--------------+
| 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' | 'bb' |
| 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' | 'cc' |
| 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' | 'dd' |
| 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' | 'ee' |
| 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' | 'ff' |
+-------------+-----------------+--------------+------------+-------------+---------------+------------------+-----------------------+----------------------+--------------------+----------------------+----------------+------------------+--------------------------+--------------+----------------+---------------+---------------+------------+----------------+---------------+------------------+----------------+------------+--------------+-----------------+----------------+-------------------+-----------------+-----------------+--------------------+-------------------+----------------+--------------------------+----------------+--------------+
--------------
COMMIT
--------------
--------------
SET AUTOCOMMIT = 1
--------------
Appuyez sur une touche pour continuer... |
Partager