{ Berbagi, Menulis, Dan Mengajar } Ilmu…

UPDATE `pangkat` SET `Golongan`='IV', `Ruang`='B', `TMT`='12-12-2001', `Gapok`='12000' WHERE `Kd_Pangkat`='G04' … Read entire article »

insert into `dbpenggajian`.`pangkat`(`Kd_Pangkat`,`Golongan`,`Ruang`,`TMT`,`Gapok`) values ( NULL,’877′,NULL,NULL,NULL) Contoh insert into `pangkat`(`Kd_Pangkat`,`Golongan`,`Ruang`,`TMT`,`Gapok`) VALUES('001','II','C','00-11-2011','2500') … Read entire article »

(3:36:16 PM) dimas_4dityo: boss…INNER JOIN Kie piye ?? (3:36:22 PM) dimas_4dityo: pengertian konsep e (3:37:25 PM) punyadony: nggabungno dua tabel.. penggabungane, berdasar ndek field key yg bersesuaian ndek masing2 tabel (3:37:52 PM) punyadony: tabel A : NIP, Nama, Alamat (3:38:11 PM) punyadony: tabel B : NIP, Gaji, Bonus (3:38:21 PM) punyadony: nah join e (3:39:31 PM) punyadony: select a.nama, a.alamat, b.gaji, b.bonus from A a inner join B b on a.NIP = b.NIP (3:40:01 PM) dimas_4dityo: oo… (3:40:05 PM) dimas_4dityo: oke2x (3:40:29 PM) punyadony: ok2 … Read entire article »

http://www.java2s.com/Tutorial/MySQL/0100__Table-Join/0040__Inner-Join.htm … Read entire article »

Excel Ke MySQLCara nie agak panjang sikit berbanding cara lain (mungkin ada yang lebih senang) Tapi memang boleh dipraktikkan. Fail disimpan (Save As) CVS Buka PHPMyAdmin dan buat 1 DATABASE. Kemudian buat 1 TABLE No of field 5 (mengikut kesesuaian rekod dari Excel) IMPORT FAIL Setelah selesai membuat Database dan Table, klik Table, Import, Browse fail CVS Pilih CVS Load Data, Field terminate by , (comma) Klik GO Add New User – jika belum Uji Connection guna Dreamweaver Hasilnya boleh dilihat dalam web browser. (IE) OK. … Read entire article »

12.2.5. LOAD DATA INFILE Syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ’file_name’ [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [FIELDS [TERMINATED BY ’string’] [[OPTIONALLY] ENCLOSED BY ’char’] [ESCAPED BY ’char’] ] [LINES [STARTING BY ’string’] [TERMINATED BY ’string’] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...] The LOAD DATA INFILE statement reads rows from a text file into a table at a very … Read entire article »