奇怪！一直有人發怪怪的「回應」？

不知道有沒有人和我一樣！
偶而會收到一些怪怪的「回應」？
明明寫了很有哲理的話，卻是附上一些「好料」的連結。
有視訊妹……有應召……有A片，J片等等！



拜託這些對我文章有「性趣」的網友，別再發這些東東了啦。
有時候對這個錯亂而瘋狂的世界，
真想喊一句：「真是够了～」。

MySQL5資料如何以CSV格式做EXPORT和IMPORT

[MySQL5]
資料庫的資料，匯出成一個 CSV 檔案！
SELECT * INTO OUTFILE '/the/path/of/testdata.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM testdata WHERE 1 ;

把 CSV 檔案，匯入MySQL5資料庫裡！
LOAD DATA LOCAL INFILE '/the/paht/of/testdata.csv' INTO TABLE testdata FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' ;


另一範例：
如果有指定欄位的話！
[EXPORT]
SELECT (uniqName, uniqCity, uniqComments) INTO OUTFILE 'testdata.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM testdata WHERE 1 ;
[IMPORT]
LOAD DATA LOCAL INFILE 'testdata.csv' INTO TABLE testdata FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (uniqName, uniqCity, uniqComments) ;


[補充]
想一次匯出多個表格的作法！
檔名：mysql_export_csv.sql
|===========================================================================|
USE database_name ;

SELECT * INTO OUTFILE '/the/path/of/testdata1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM testdata1 WHERE 1 ;

SELECT * INTO OUTFILE '/the/path/of/testdata2.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM testdata2 WHERE 1 ;

SELECT * INTO OUTFILE '/the/path/of/testdata3.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM testdata3 WHERE 1 ;
|===========================================================================|
然後在OS promote下指令！
> mysql -uyouraccount -p'yourpassword' < mysql_export_csv.sql

OK!搞定～

反之匯入多個表格作法！
檔名：mysql_import_csv.sql
|===========================================================================|
USE database_name ;

TRUNCATE TABLE testdata1 ;
LOAD DATA LOCAL INFILE '/the/path/of/testdata1.csv' INTO TABLE testdata1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' ;

TRUNCATE TABLE testdata2 ;
LOAD DATA LOCAL INFILE '/the/path/of/testdata.csv' INTO TABLE testdata2 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' ;

TRUNCATE TABLE testdata3 ;
LOAD DATA LOCAL INFILE '/the/path/of/testdata.csv' INTO TABLE testdata3 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' ;
|===========================================================================|

OS promote 指令！
> mysql -uyouraccount -p'yourpassword' < mysql_import_csv.sql

任務完成！Good luck!

一個簡單卻常被忽略的問題！A語言？

大家都知道C語言！
但未必知道和聽說過B語言和A語言。
C語言？B語言？A語言？

世界上第一個高級程式語言叫 ALGOL，也就是A語言。
而B語言則是 BCPL！
C則是再由B演化修改而來……

以下列出維基百科的參考資料：
A語言
B語言
C語言