{ Berbagi, Menulis, Dan Mengajar } Ilmu…

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 »