\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u304b\u3089\u3001mysql\u3000\u3078\u3001\u5909\u63db\u3059\u308b\u969b\u306e\u624b\u9806<\/p>\n
\u2460\u3000DB\u306e\u4f5c\u6210<\/p>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u3001mysql\u3067\u3082\u53ef\u80fd\u3067\u3059\u304c\u3001\u9762\u5012\u306a\u306e\u3067\u3000phpmyadmin \u3067\u3084\u308b
\n\u203b\u3000\u3053\u306e\u6642\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306e\u6a2a\u306b\u3042\u308b\u7a7a\u6b04\u306b\u306a\u3063\u3066\u3044\u308b\u90e8\u5206\u3067\u306e\u3000\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u3092\u5fd8\u308c\u306a\u3044\u4e8b\uff01
\n\u5fc5\u305a\u3000utf8_unicode_ci \u3092\u9078\u629e\u3059\u308b
\n\u2461\u3000\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u4f5c\u6210
\n\u7a7a\u306e\u307e\u307e\u3060\u3068\u3001\u8aad\u307f\u8fbc\u307f\u304c\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u524d\u3082\u3063\u3066\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u751f\u6210\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308b
\n# mysql -u ytest -pytest
\n> use ytest
\n\u3053\u3053\u307e\u3067\u3067\u3000\u63a5\u7d9a\u78ba\u7acb<\/p>\n
\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306e\u5217\u6bce\u306b\u30d5\u30a3\u30fc\u30eb\u30c9\u5316\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b
\nVARCHAR(80) —> 80\u6587\u5b57\u306e\u6587\u5b57\u5217
\nINTEGER ——> \u6574\u6570\u3000\u6841\u6570\u306e\u7701\u7565\u53ef
\nFLOAT ———> \u5c0f\u6570\u70b9\u3000\u6841\u6570\u7701\u7565\u53ef
\n\u305d\u306e\u4ed6\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u30bf\u30a4\u30d7\u3082\u5b58\u5728\u3059\u308b<\/p>\n
\u4ee5\u4e0b\u3000\u30a8\u30af\u30bb\u30eb\u306e\u5217\u304b\u3089\u30d5\u30a3\u30fc\u30eb\u30c9\u69cb\u6210\u3092\u4f5c\u3063\u3066\u767b\u9332\u3059\u308b\u4f8b
\n>Create Table ytest (<\/p>\n
KeyWord VARCHAR(80),
\nMuchType VARCHAR(80),
\nCP_name VARCHAR(80),
\nAG_name VARCHAR(80),
\nQtyIndex INTEGER(10),
\nTPBTPrice INTEGER(10),
\nTPBPrice INTEGER(10),
\nNOI INTEGER(10),
\nNOC INTEGER(10),
\nCRR FLOAT(10),
\nAP FLOAT(10),
\nCost INTEGER(10),
\nAvgCPC FLOAT(10),
\nAdIDExt VARCHAR(80),
\nNumID INTEGER(10),
\nSumCord INTEGER(10),
\nTACost INTEGER(10),
\nData INTEGER(10),
\nAplcb VARCHAR(80),
\nAvgClicks FLOAT(10),
\nTtlClicks INTEGER(10),
\nNoName VARCHAR(80) );
\nexit;
\n\u3053\u308c\u3067\u3001\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u3067\u304d\u308b<\/p>\n
\u2462\u3000\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f<\/p>\n
mysql \u3067\u3000csv\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u306f\u4ee5\u4e0b\u306e\u8981\u9818<\/p>\n
# mysql -u ytest -pytest
\n> use ytest
\n\u3053\u3053\u307e\u3067\u3067\u3000\u63a5\u7d9a\u78ba\u7acb<\/p>\n
csv\u306e\u8aad\u307f\u8fbc\u307f
\n\u306a\u305c\u304b\u30d5\u30a1\u30a4\u30eb\u306e\u7f6e\u304d\u5834\u306f\u3000\/var\/lib\/mysql\/ytest\u3000\u4ee5\u4e0b\u306b\u3057\u306a\u3044\u3068\u3001\u30c0\u30e1<\/p>\n
>LOAD DATA INFILE “yahoo-data-utf8.csv” INTO TABLE ytest FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘;<\/p>\n
\u58ca\u308c\u3066\u3044\u306a\u3044\u30d5\u30a1\u30a4\u30eb\u304c\u6587\u5b57\u5316\u3051\u3059\u308b\u552f\u4e00\u306e\u539f\u56e0\u306f\u3001
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210\u6642\u306b\u30bb\u30c3\u30c8\u3057\u305f\u6587\u5b57\u30b3\u30fc\u30c9\u3068\u30d5\u30a1\u30a4\u30eb\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u4e0d\u4e00\u81f4<\/p>\n","protected":false},"excerpt":{"rendered":"
\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u304b\u3089\u3001mysql\u3000\u3078\u3001\u5909\u63db\u3059\u308b\u969b\u306e\u624b\u9806 \u2460\u3000DB\u306e\u4f5c\u6210 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u3001mysql\u3067\u3082\u53ef\u80fd\u3067\u3059\u304c\u3001\u9762\u5012\u306a\u306e\u3067\u3000phpmyadmin \u3067\u3084\u308b \u203b\u3000\u3053\u306e\u6642\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306e\u6a2a\u306b\u3042\u308b\u7a7a\u6b04\u306b\u306a\u3063\u3066\u3044\u308b\u90e8\u5206\u3067\u306e … \u7d9a\u304d\u3092\u8aad\u3080 Excel Mysql \u5909\u63db<\/span>