{"id":241,"date":"2009-02-25T10:38:55","date_gmt":"2009-02-25T16:38:55","guid":{"rendered":"https:\/\/massumifukuda.work\/wp\/entry\/2009\/02\/25\/103855"},"modified":"2019-06-16T21:41:38","modified_gmt":"2019-06-17T03:41:38","slug":"20090225-1236130735","status":"publish","type":"post","link":"https:\/\/massumifukuda.work\/wp\/20090225-1236130735\/","title":{"rendered":"MySQL"},"content":{"rendered":"

\"tatui<\/p>\n

CREATE TABLE new_table AS SELECT * FROM old_table;<\/p>\n

SELECT COUNT(*) FROM \u30c6\u30fc\u30d6\u30eb\u540d<\/p>\n

..:::insert\u6587:::..<\/p>\n

\u250c—————————————-\u2510
\n\u2502id \u2502int\u3000\u3000\u3000\u3000\u3000\u2502 auto_increment\u3000\u2502\u3000
\n\u2502CAL01 \u2502varchar(10)\u3000\u2502\u3000\u3000\u3000\u3000\u3000\u3000\u3000 \u3000\u2502
\n\u2502CAL02 \u2502varchar(20)\u3000\u2502\u3000\u3000\u3000 \u3000\u3000\u3000\u3000\u2502
\n\u2514—————————————-\u2518<\/p>\n

insert into TABLE values(NULL’data01′,’data2′);<\/p>\n

<\/p>\n

..:::alter\u6587:::..<\/p>\n

alter table TABLE add CAL03 varchar(9) after CAL01;<\/p>\n

..::inport::…<\/p>\n

load data local infile “dump.csv<\/a>” into table TABLE fields terminated by ‘,’;<\/p>\n

.::mysql<\/a>.sock\u306e\u5834\u6240::.
\n\/var\/lib\/mysql<\/a>\/<\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE TABLE new_table AS SELECT * FROM old_table; SELECT COUNT(*) FROM \u30c6\u30fc\u30d6\u30eb\u540d ..:::insert\u6587:::.. \u250c—&#8212 … \u7d9a\u304d\u3092\u8aad\u3080 MySQL<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-241","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/posts\/241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/comments?post=241"}],"version-history":[{"count":1,"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/posts\/241\/revisions"}],"predecessor-version":[{"id":310,"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/posts\/241\/revisions\/310"}],"wp:attachment":[{"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/media?parent=241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/categories?post=241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/massumifukuda.work\/wp\/wp-json\/wp\/v2\/tags?post=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}