Thursday, 09 February 2012 |
Dump to file In Mysql
Category : Tips
mau berbagi sedikit, ada cara bagus untuk melakukan dump ke file selain mengunakan pemograman menengah, kita juga bisa memakai SQL untuk dump ke file. contohnya :
code di atas artinya kita hendak, melakukan backup tabel barang.
FIELDS TERMINATED BY ',' artinya tiap field di pisahkan dengan tanda koma
LINES TERMINATED BY '\n' artinya tiap field di pisahkan dengan \n
Melanjutkanpost saya yang tadi, saya juga ingin berbagi, bagaimana QUERY SQL bisa membaca file dan secara cepat memasukannya ke dalam database, sebagai contoh kita mau memasukan data yang telah di back up, dalam hal ini tabel barang. maka yang harus kita lakukan adalah
Facebook
<< Back
| Code: |
| SELECT * INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' FROM tabel_barang; |
code di atas artinya kita hendak, melakukan backup tabel barang.
FIELDS TERMINATED BY ',' artinya tiap field di pisahkan dengan tanda koma
LINES TERMINATED BY '\n' artinya tiap field di pisahkan dengan \n
Melanjutkanpost saya yang tadi, saya juga ingin berbagi, bagaimana QUERY SQL bisa membaca file dan secara cepat memasukannya ke dalam database, sebagai contoh kita mau memasukan data yang telah di back up, dalam hal ini tabel barang. maka yang harus kita lakukan adalah
| Code: |
| LOAD DATA INFILE '/tmp/result.txt INTO TABLE tabel_barang; FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; |
Facebook
<< Back
0 Comment
| 791 hits | Posted by Callrid at 2007-08-10 08:39:01
| Related Read | |
|
|
|
| Other Source | |
|
A Practical Guide On Complete Multivitamins Many of us have a hard time deciding what the best multivitamin is for us. This is completely confusing and difficult especially when there are so many bottles to scan in the various aisles of the...
High Blood Pressure The nutritional benefits of low-fat dairy products are well known for ages.
The latest studies show that the ingredients of dairy products - some combination of milk proteins are effective and...
Welcome To Mimicwatch.com - Quality Luxury Replica Vacheron Constantin Watches At Affordable Price When entering our online store at Mimicwatch.com, you are given an unique opportunity to choose among a wide selection of famous Replica Watches and Replica handbags such as Replica Vacheron...
Ebook Marketing Tips A great way to have a product to sell on the Internet is an e-book which almost anyone can create. There is no longer any need for delaying with the simple process detailed below. If you are afraid...
Tactical Asset Marketing Asset Management Different Asset Allocation Strategies
Asset marketing is the process of dividing a portfolio into major asset categories such as cash, stocks, real estate, or...
|
|
| ||||||
| ||||||
|
|||||||||
|
|||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||
callrid.com Created 2006-2010 by Anton Ongsono
All rights reserved