Database - Load File .exe ke dalam mysql

create database karyawan;
use karyawan;

create table identitas(nomor varchar(2), nama_depan varchar(20), nama_belakang varchar(20),
kelamin char(1), tempat_lahir varchar(15), tgl_lahir date, tgl_masuk date, divisi varchar(10),
Level1 varchar(15), jabatan varchar(20), gaji int);
describe identitas;

Load data infile'D:\karyawan.csv ' into table identitas
fields terminated by ',' ignore  1 lines;
Load data infile'D:\karyawan2.txt ' into table identitas
fields terminated by ',';
select*from identitas;

No comments on "Database - Load File .exe ke dalam mysql

Leave a Reply