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;
It's Me
Labels
- Ahkwat (5)
- C++ (14)
- Daily Me (3)
- Database (11)
- Flash (2)
- Java (4)
- Konsep Bahasa Pemrograma (2)
- Pengolahan Citra (3)
- Product (2)
- Tentang Blog (5)
No comments on "Database - Load File .exe ke dalam mysql