Sample Table: empinfo
firstlastidagecitystate
John
Jones
99980
45
Payson
Arizona
Mary
Jones
99982
25
Payson
Arizona
Eric
Edwards
88232
32
San Diego
California
Mary Ann
Edwards
88233
32
Phoenix
Arizona
Ginger
Howell
98002
42
Cottonwood
Arizona
Sebastian
Smith
92001
23
Gila Bend
Arizona
Gus
Gray
22322
35
Bagdad
Arizona
Mary...
Thursday, January 24, 2013
Tuesday, January 22, 2013
Tugas Minggu Kedua - Membuat DataBase dan Tabel menggunakan Syntax
SQL Syntax membuat :
Database: karyawan
Tabel : tb_karyawan
Kolom: no, nik, nm_karyawan, jabatan, tmpt_lahir, tgl_lahir, gaji
CREATE database karyawan;
USE karyawan;
CREATE table tb_karyawan
(no int(3),
nik int(10),
nm_karyawan varchar(30),
jabatan varchar(30),
tmpt_lahir...
Thursday, January 17, 2013
Subscribe to:
Posts (Atom)
Minergate
