鐃緒申鐃緒申鐃緒申鐃緒申鐃春醐申鐃緒申某鐃緒申店鐃叔「デ￥申鐃緒申鐃駿￥申鐃緒申鐃獣わ申鐃書しわ申鐃緒申鐃緒申鐃粛…」とわ申鐃旬わ申鐃銃わ申鐃緒申年鐃循わ申鐃緒申鐃薯見わ申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃旬業でわ申Excel鐃叔緒申分鐃淑のでわ申鐃殉り気鐃祝わ申鐃緒申鐃緒申鐃夙はなわ申鐃獣わ申鐃塾でわ申鐃緒申鐃緒申調鐃駿てみわ申罰里鐃緒申砲鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申颪靴鐃緒申鐃緒申任鐃緒申鐃�
MythTV鐃淑どわ申遒件申鐃緒申箸鐃緒申鐃�MySQL鐃緒申鐃緒申鐃緒申鐃緒申辰鐃緒申鐃緒申箸鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申必鐃竣最常申鐃渋わ申鐃熟囲でわ申鐃緒申鐃夙ってわ申鐃殉わ申鐃藷。わ申鐃緒申鐃叔￥申鐃緒申鐃緒申謄如鐃緒申鐃緒申戞鐃緒申鐃緒申了箸鐃緒申鐃緒申鐃縦器申戞鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申遒件申討澆泙鐃緒申鐃緒申里如鐃緒申泙箸鐃銃わ申鐃緒申鐃緒申鐃夙思わ申鐃殉わ申鐃緒申
OpenOffice.org Base鐃緒申MySQL鐃緒申鐃緒申鐃出わ申鐃緒申続鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉で￥申文鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申辰任鐃緒申鐃緒申剖鐃緒申錣件申討鐃緒申泙鐃緒申鐃緒申鐃�
鐃緒申鐃盾そ鐃緒申如鐃緒申鐃緒申戞鐃緒申鐃緒申辰堂鐃緒申任鐃緒申腓�鐃緒申
鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃熟わ申鐃緒申鐃殉でデ￥申鐃緒申鐃緒申鐃緒申鐃緒申物鐃祝わ申鐃緒申鐃緒申鐃緒申鐃渋際にデ￥申鐃緒申鐃緒申个鐃緒申鐃緒申譴刻申鐃塾は￥申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃ワ申(DBMS)鐃緒申鐃緒申鐃叔￥申鐃緒申鐃緒申鐃竣ンソ￥申鐃緒申鐃緒申無鐃緒申鐃叔使わ申鐃緒申DBMS鐃夙わ申鐃銃は￥申MySQL鐃緒申PostgreSQL鐃緒申SQLite鐃淑どわ申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃盾、鐃緒申鐃緒申鐃出￥申鐃緒申鐃初イ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申撚鐃銃�鐃緒申鐃殉わ申鐃緒申SQLite鐃熟簡逸申鐃叔でわ申鐃緒申鐃緒申MySQL鐃緒申PostgreSQL鐃熟居申能鐃緒申豊鐃駿で互角な器申鐃緒申鐃叔わ申鐃緒申
DBMS鐃緒申鐃緒申鐃緒申的鐃淑種申鐃淑わ申鐃藷供わ申鐃暑ソ鐃春トでわ申鐃緒申鐃緒申OpenOffice.org鐃緒申Base鐃緒申Calc鐃緒申Writer鐃淑どわ申鐃叔￥申鐃緒申鐃駿￥申鐃緒申連鐃夙ワ申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃�鐃緒申併鐃術わ申鐃緒申弌鐃緒申鐃緒申鐃獣縁申鐃緒申鐃緒申僂鐃緒申襪鰹申箸鐃緒申鐃叔緒申砲覆鐃殉わ申鐃緒申鐃殉わ申鐃緒申多鐃緒申鐃塾ワ申鐃緒申鐃夙でも、鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃ワ申鐃緒申鐃緒申僂鐃緒申討鐃緒申泙鐃緒申鐃緒申閥鐃緒申鐃緒申埜鐃緒申鐃緒申弌鐃�Google鐃緒申鐃緒申鐃叔わ申鐃緒申鐃術わ申鐃緒申討鐃緒申泙鐃緒申鐃粛￥申
鐃殉わ申鐃熟わ申鐃緒申法鐃�MySQL鐃塾ワ申鐃藷スト￥申鐃緒申鐃緒申法鐃夙器申鐃緒申的鐃淑使わ申鐃緒申鐃緒申泙箸鐃銃みまわ申鐃順う鐃緒申
鐃緒申鐃春トワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃藷タ￥申鐃緒申鐃初イ鐃藷スト￥申鐃緒申
鐃緒申鐃緒申鐃緒申法鐃�mysql鐃竣わ申鐃緒申鐃熟わ申鐃銃￥申MySQL鐃緒申鐃緒申鐃出」わ申探鐃緒申鐃緒申鐃緒申鐃藷スト￥申鐃緒申椒鐃緒申鐃薯クワ申奪鐃緒申鐃緒申泙鐃緒申鐃�
Synaptic鐃緒申鐃初イ鐃藷スト￥申鐃緒申
鐃緒申鐃緒申鐃緒申法鐃�mysql-server鐃竣わ申鐃緒申鐃熟わ申鐃銃￥申mysql-server鐃竣とわ申鐃緒申鐃術ッワ申鐃緒申鐃緒申鐃緒申探鐃緒申鐃緒申鐃緒申鐃藷スト￥申鐃暑し鐃殉わ申鐃緒申
鐃緒申鐃藷スト￥申鐃緒申鐃緒申鐃緒申鐃叔￥申root鐃術ワ申鐃緒ー鐃宿わ申鐃緒申鐃緒申鐃緒申未鐃宿緒申鐃緒申鐃緒申鐃殉わ申鐃塾で￥申任鐃春のパワ申鐃緒ー鐃宿わ申鐃緒申鐃所し鐃殉わ申鐃緒申鐃緒申鐃淑みに￥申OS鐃緒申root鐃醇ー鐃緒申鐃緒申MySQL鐃緒申root鐃醇ー鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申物鐃叔わ申鐃緒申
MySQL鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申侫鐃緒申鐃緒申鐃熟￥申/etc/mysql/my.cnf鐃夙わ申鐃緒申鐃春ワ申鐃緒申鐃緒申任鐃緒申鐃緒申鐃緒申離侫鐃緒申鐃緒申鐃緒申鐃緒申[client]鐃緒申[mysqld]鐃塾ブワ申鐃獣ワ申鐃緒申鐃緒申法鐃緒申鐃緒申譴常申豌種申鐃緒申裡鐃緒申圓鐃獣わ申鐃殉わ申鐃緒申
default-character-set = utf8
[2012.03.30 鐃宿居申]
鐃緒申鐃緒申鐃緒申鐃出￥申鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申鐃出￥申側鐃緒申[mysqld]鐃叔は￥申鐃緒申character-set-server=utf8鐃竣わ申鐃緒申僂鐃緒申鐃宿�鐃竣わ申鐃緒申鐃緒申茲�鐃叔わ申鐃緒申
鐃緒申鐃緒申鐃術刻申鐃熟とりあ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申任鐃緒申鐃渋鰹申鐃緒申董鐃緒申鐃緒申離鐃緒申泪鐃宿わ申MySQL鐃緒申鐃緒申鐃出わ申撞鐃銃逸申鐃緒申泙鐃緒申鐃�
$ sudo service mysql restart
鐃淑わ申鐃緒申鐃醇ー鐃緒申鐃緒申鐃宿加など詳細なワ申鐃緒申鐃緒申鐃緒申鐃緒申砲弔鐃緒申討鐃�MySQL Administrator鐃夙わ申鐃緒申鐃緒申鐃緒申鐃淑ツ￥申鐃暑が鐃緒申鐃緒申泙鐃緒申鐃�
mysql鐃緒申鐃初イ鐃緒申鐃緒申箸鐃銃逸申鐃緒申鐃祝は￥申MySQL鐃緒申root鐃醇ー鐃緒申鐃叔ワ申鐃藷スト￥申鐃緒申鐃緒申鐃緒申鐃緒申蠅件申鐃緒申僖鐃緒申錙種申匹鐃夙ってワ申鐃緒申鐃緒申鐃藷しまわ申鐃緒申
$ mysql -u root -p
鐃夙わ申鐃緒申鐃緒申鐃殉ワ申匹鐃渋行わ申鐃緒申函鐃緒申鐃緒申里茲�鐃緒申表鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
Enter password:
鐃緒申鐃緒申鐃叔￥申鐃術ワ申鐃緒ー鐃宿わ申鐃緒申鐃熟わ申鐃緒申鐃遵、Enter鐃緒申鐃緒申鐃薯押わ申鐃銃￥申鐃緒申鐃緒申鐃塾よう鐃緒申表鐃緒申鐃緒申鐃緒申鐃出ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申任鐃緒申鐃�
mysql> SHOW DATABASES;
information_schema鐃緒申mysql鐃緒申test鐃夙わ申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申録鐃緒申鐃緒申討鐃緒申鐃熟わ申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申鐃塾ワ申鐃緒申廛鐃熟使わず鐃緒申鐃緒申鐃緒申鐃祝テワ申鐃緒申鐃術とわ申鐃緒申data1鐃夙わ申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�CREATE DATABASE data1;鐃緒申鐃緒申鐃叔もい鐃緒申鐃塾でわ申鐃緒申鐃緒申鐃緒申鐃�OpenOffice.org鐃緒申連鐃夙わ申鐃緒申鐃緒申櫃鐃淑醐申鐃緒申鐃緒申鐃緒申从鐃緒申裡鐃緒申弔箸鐃緒申謄鐃緒申薀わ申鐃緒申鐃夙わ申文鐃緒申鐃緒申鐃緒申鐃宿わ申utf8鐃緒申鐃緒申鐃所し鐃銃わ申鐃緒申鐃殉わ申鐃緒申
mysql> CREATE DATABASE data1 DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)
鐃緒申鐃緒申鐃叔もう鐃緒申鐃駿￥申SHOW DATABASES;鐃緒申孫圓鐃緒申鐃夙￥申data1鐃夙わ申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃獣わ申辰討鐃緒申襪鰹申箸鐃緒申認鐃叔わ申鐃殉わ申鐃緒申
csv鐃春ワ申鐃緒申鐃緒申蓮鐃�/var/lib/mysql/鐃淑駕申鐃祝わ申鐃緒申謄如鐃緒申鐃緒申戞鐃緒申鐃緒申鐃縮常申鐃緒申里弔鐃緒申鐃緒申侫鐃緒申鐃緒申鐃緒申鐃緒申存鐃緒申鐃銃わ申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃塾常申隋�/var/lib/mysql/data1鐃叔わ申鐃緒申鐃淑駕申鐃緒申鐃渋行わ申鐃暑コ鐃殉ワ申鐃�(鐃緒申鐃緒申鐃緒申分)鐃夙わ申鐃塾逸申味鐃緒申泙箸鐃銃わ申鐃緒申鐃殉わ申鐃緒申
mysql> USE data1;
鐃緒申鐃術わ申鐃緒申如鐃緒申鐃緒申戞鐃緒申鐃緒申鐃緒申鐃所し鐃殉わ申鐃緒申
mysql> CREATE TABLE table1 ( id int, name varchar(100) );
table1鐃夙わ申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申(鐃春ワ申鐃緒申鐃緒申鐃�)鐃緒申鐃夙わ申鐃緒申鐃緒申鐃粛わ申文鐃緒申鐃藷かとわ申鐃緒申鐃緒申鐃緒申鬚垢鐃宿�鐃竣わ申鐃緒申鐃所、鐃緒申鐃塾常申鐃緒申"id鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申"鐃緒申"name鐃夙わ申鐃緒申文鐃緒申鐃緒申"鐃塾ｏ申鐃縦わ申鐃粛わ申鐃緒申鐃緒申鐃緒申董鐃緒申屮鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃緒申侫鐃緒申鐃緒申鐃宿わ申名鐃塾つまわ申id鐃緒申name鐃緒申鐃緒申分鐃熟￥申鐃緒申鐃旬醐申任盥緒申鐃緒申泙鐃緒申鐃�
mysql> SHOW TABLES;
鐃銃￥申鐃瞬ワ申離螢刻申箸鐃宿緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申法鐃�table1鐃夙わ申鐃緒申鐃銃￥申鐃瞬ルが鐃獣わ申辰討鐃緒申鐃熟わ申鐃叔わ申鐃緒申USE data1;鐃塾実刻申鐃緒申鐃淑ら、SHOW TABLES FROM data1;鐃夙わ申鐃緒申鐃緒申鐃叔デ￥申鐃緒申鐃駿￥申鐃緒申名鐃緒申鐃緒申蠅刻申鐃宿�鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃�
mysql> LOAD DATA INFILE "test.csv" INTO TABLE table1 FIELDS TERMINATED BY ',' ENCLOSED BY '"';
鐃緒申鐃旬わ申鐃夙に￥申,鐃竣で駈申鐃准わ申鐃銃各デ￥申鐃緒申鐃緒申鐃緒申"鐃竣で駈申鐃殉れたcsv鐃春ワ申鐃緒申鐃緒申(test.csv)鐃緒申鐃宿み刻申鐃淳まわ申鐃緒申鐃緒申鐃塾よう鐃緒申表鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申鐃緒申任鐃緒申鐃�
mysql> SELECT * FROM table1;
鐃銃￥申鐃瞬ワ申鐃緒申鐃夙わ申端鐃緒申鐃緒申鐃宿緒申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申粉鐃緒申鐃緒申任鐃緒申鐃淑醐申鐃緒申鐃緒申鐃緒申匹鐃重�鐃准でなわ申鐃夙￥申鐃曙イ鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申 鐃銃￥申鐃瞬ワ申鐃緒申離如鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃祝は￥申
mysql> DELETE FROM table1;
鐃緒申鐃緒申鐃緒申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申里鐃緒申戮討離譽鰹申鐃緒申鐃�(鐃緒申録)鐃緒申探遒刻申鐃祝は￥申
mysql> TRUNCATE TABLE table1;
鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申速鐃叔わ申鐃緒申
鐃緒申 鐃銃￥申鐃瞬ルそ鐃塾わ申里鐃緒申鐃緒申鐃緒申鐃祝は￥申
mysql> DROP TABLE table1;
鐃淑わ申鐃緒申MySQL鐃緒申鐃初イ鐃緒申鐃緒申箸鐃塾誌申鐃緒申鐃祝は￥申鐃緒申quit鐃竣わ申鐃暑い鐃熟￥申exit鐃竣で緒申了鐃叔わ申鐃殉わ申鐃緒申鐃緒申鐃塾常申隋∧醐申鐃緒申痢鐃�;鐃竣わ申鐃緒申鐃竣でわ申鐃緒申
長鐃緒申鐃淑ってわ申鐃殉わ申鐃塾で￥申続鐃緒申鐃熟種申鐃緒申砲鐃緒申泙鐃緒申腓�鐃緒申
続鐃緒申鐃熟わ申鐃緒申鐃初→鐃緒申MySQL鐃叔試す鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申圓鐃緒申裡鐃緒申鐃�
鐃縦ワ申鐃緒申鐃緒申
MythTV鐃淑どわ申遒件申鐃緒申箸鐃緒申鐃�MySQL鐃緒申鐃緒申鐃緒申鐃緒申辰鐃緒申鐃緒申箸鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申必鐃竣最常申鐃渋わ申鐃熟囲でわ申鐃緒申鐃夙ってわ申鐃殉わ申鐃藷。わ申鐃緒申鐃叔￥申鐃緒申鐃緒申謄如鐃緒申鐃緒申戞鐃緒申鐃緒申了箸鐃緒申鐃緒申鐃縦器申戞鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申遒件申討澆泙鐃緒申鐃緒申里如鐃緒申泙箸鐃銃わ申鐃緒申鐃緒申鐃夙思わ申鐃殉わ申鐃緒申
OpenOffice.org Base鐃緒申MySQL鐃緒申鐃緒申鐃出わ申鐃緒申続鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉で￥申文鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申辰任鐃緒申鐃緒申剖鐃緒申錣件申討鐃緒申泙鐃緒申鐃緒申鐃�鐃緒申鐃盾そ鐃緒申如鐃緒申鐃緒申戞鐃緒申鐃緒申辰堂鐃緒申任鐃緒申腓�鐃緒申
鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃夙わ申
鐃緒申鐃殉わ申鐃殉な常申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃楯￥申短鐃緒申文鐃叔まとわ申謄鐃緒申忙弔鐃緒申鐃緒申蝓�Excel鐃緒申Calc鐃淑どわ申表鐃竣誌申鐃緒申鐃春トで逸申鐃緒申表鐃祝わ申鐃緒申鐃所、鐃緒申鐃緒申鐃祝書いわ申鐃緒申弔覆匹函鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃祝￥申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申的鐃祝は￥申鐃緒申鐃塾よう鐃淑常申鐃緒申鐃緒申鐃旬わ申鐃夙わ申鐃緒申鐃緒申鐃緒申鐃銃まとわ申鐃緒申鐃緒申僂鐃緒申鐃緒申鐃塾わ申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃夙呼びまわ申鐃緒申鐃縮常、Access鐃淑どのデ￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃春トで使わ申鐃緒申如鐃緒申鐃緒申戞鐃緒申鐃緒申箸鐃緒申鐃緒申鐃緒申佞鐃銃縁申鐃緒申鐃縮ｏ申如鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申謄鐃叔使わ申鐃暑た鐃潤、鐃緒申鐃緒申鐃緒申鐃祝￥申妊妊鐃緒申鐃緒申覯緒申鐃緒申鐃銃わ申鐃緒申鐃緒申鐃緒申任鐃緒申鐃�鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃熟わ申鐃緒申鐃殉でデ￥申鐃緒申鐃緒申鐃緒申鐃緒申物鐃祝わ申鐃緒申鐃緒申鐃緒申鐃渋際にデ￥申鐃緒申鐃緒申个鐃緒申鐃緒申譴刻申鐃塾は￥申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃ワ申(DBMS)鐃緒申鐃緒申鐃叔￥申鐃緒申鐃緒申鐃竣ンソ￥申鐃緒申鐃緒申無鐃緒申鐃叔使わ申鐃緒申DBMS鐃夙わ申鐃銃は￥申MySQL鐃緒申PostgreSQL鐃緒申SQLite鐃淑どわ申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃盾、鐃緒申鐃緒申鐃出￥申鐃緒申鐃初イ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申撚鐃銃�鐃緒申鐃殉わ申鐃緒申SQLite鐃熟簡逸申鐃叔でわ申鐃緒申鐃緒申MySQL鐃緒申PostgreSQL鐃熟居申能鐃緒申豊鐃駿で互角な器申鐃緒申鐃叔わ申鐃緒申
DBMS鐃緒申鐃緒申鐃緒申的鐃淑種申鐃淑わ申鐃藷供わ申鐃暑ソ鐃春トでわ申鐃緒申鐃緒申OpenOffice.org鐃緒申Base鐃緒申Calc鐃緒申Writer鐃淑どわ申鐃叔￥申鐃緒申鐃駿￥申鐃緒申連鐃夙ワ申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃�鐃緒申併鐃術わ申鐃緒申弌鐃緒申鐃緒申鐃獣縁申鐃緒申鐃緒申僂鐃緒申襪鰹申箸鐃緒申鐃叔緒申砲覆鐃殉わ申鐃緒申鐃殉わ申鐃緒申多鐃緒申鐃塾ワ申鐃緒申鐃夙でも、鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃ワ申鐃緒申鐃緒申僂鐃緒申討鐃緒申泙鐃緒申鐃緒申閥鐃緒申鐃緒申埜鐃緒申鐃緒申弌鐃�Google鐃緒申鐃緒申鐃叔わ申鐃緒申鐃術わ申鐃緒申討鐃緒申泙鐃緒申鐃粛￥申
鐃殉わ申鐃熟わ申鐃緒申法鐃�MySQL鐃塾ワ申鐃藷スト￥申鐃緒申鐃緒申法鐃夙器申鐃緒申的鐃淑使わ申鐃緒申鐃緒申泙箸鐃銃みまわ申鐃順う鐃緒申
MySQL鐃塾ワ申鐃藷スト￥申鐃緒申
Fedora鐃叔わ申箸鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申Ubuntu 10.04鐃緒申箸鐃緒申泙鐃緒申鐃緒申鐃�apt-get鐃叔もイ鐃藷スト￥申鐃緒申任鐃緒申泙鐃緒申鐃緒申鐃�root(MySQL鐃塾器申鐃緒申鐃峻ユー鐃緒申)鐃塾パワ申鐃緒ー鐃緒申鐃緒申鐃緒申鐃緒申鐃�鐃緒申GUI鐃緒申表鐃緒申鐃緒申鐃緒申襪随申瓠�鐃緒申鐃春トワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃藷タ￥申鐃緒申Synaptic鐃術ッワ申鐃緒申鐃緒申鐃殉ネ￥申鐃緒申鐃緒申鐃夙っわ申鐃緒申鐃緒申鐃緒か鐃緒申笋刻申鐃緒申任鐃緒申腓�鐃緒申鐃緒申鐃春トワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃藷タ￥申鐃緒申鐃初イ鐃藷スト￥申鐃緒申
鐃緒申鐃緒申鐃緒申法鐃�mysql鐃竣わ申鐃緒申鐃熟わ申鐃銃￥申MySQL鐃緒申鐃緒申鐃出」わ申探鐃緒申鐃緒申鐃緒申鐃藷スト￥申鐃緒申椒鐃緒申鐃薯クワ申奪鐃緒申鐃緒申泙鐃緒申鐃�
Synaptic鐃緒申鐃初イ鐃藷スト￥申鐃緒申
鐃緒申鐃緒申鐃緒申法鐃�mysql-server鐃竣わ申鐃緒申鐃熟わ申鐃銃￥申mysql-server鐃竣とわ申鐃緒申鐃術ッワ申鐃緒申鐃緒申鐃緒申探鐃緒申鐃緒申鐃緒申鐃藷スト￥申鐃暑し鐃殉わ申鐃緒申
鐃緒申鐃藷スト￥申鐃緒申鐃緒申鐃緒申鐃叔￥申root鐃術ワ申鐃緒ー鐃宿わ申鐃緒申鐃緒申鐃緒申未鐃宿緒申鐃緒申鐃緒申鐃殉わ申鐃塾で￥申任鐃春のパワ申鐃緒ー鐃宿わ申鐃緒申鐃所し鐃殉わ申鐃緒申鐃緒申鐃淑みに￥申OS鐃緒申root鐃醇ー鐃緒申鐃緒申MySQL鐃緒申root鐃醇ー鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申物鐃叔わ申鐃緒申MySQL鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申
mysql-server鐃薯インスト￥申鐃暑す鐃緒申弌鐃�MySQL鐃緒申鐃緒申鐃出はわ申鐃叔に駕申働鐃緒申鐃銃わ申鐃殉わ申鐃塾で￥申鐃獣わ申鐃緒申鐃所す鐃緒申必鐃竣はわ申鐃緒申泙鐃緒申鵑�￥申文鐃緒申鐃緒申鐃緒申鐃出削申鐃緒申鐃緒申鐃緒申辰討鐃緒申鐃緒申泙鐃緒申腓�鐃緒申MySQL鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申侫鐃緒申鐃緒申鐃熟￥申/etc/mysql/my.cnf鐃夙わ申鐃緒申鐃春ワ申鐃緒申鐃緒申任鐃緒申鐃緒申鐃緒申離侫鐃緒申鐃緒申鐃緒申鐃緒申[client]鐃緒申[mysqld]鐃塾ブワ申鐃獣ワ申鐃緒申鐃緒申法鐃緒申鐃緒申譴常申豌種申鐃緒申裡鐃緒申圓鐃獣わ申鐃殉わ申鐃緒申
default-character-set = utf8
[2012.03.30 鐃宿居申]
鐃緒申鐃緒申鐃緒申鐃出￥申鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申鐃出￥申側鐃緒申[mysqld]鐃叔は￥申鐃緒申character-set-server=utf8鐃竣わ申鐃緒申僂鐃緒申鐃宿�鐃竣わ申鐃緒申鐃緒申茲�鐃叔わ申鐃緒申
鐃緒申鐃緒申鐃術刻申鐃熟とりあ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申任鐃緒申鐃渋鰹申鐃緒申董鐃緒申鐃緒申離鐃緒申泪鐃宿わ申MySQL鐃緒申鐃緒申鐃出わ申撞鐃銃逸申鐃緒申泙鐃緒申鐃�
$ sudo service mysql restart
鐃淑わ申鐃緒申鐃醇ー鐃緒申鐃緒申鐃宿加など詳細なワ申鐃緒申鐃緒申鐃緒申鐃緒申砲弔鐃緒申討鐃�MySQL Administrator鐃夙わ申鐃緒申鐃緒申鐃緒申鐃淑ツ￥申鐃暑が鐃緒申鐃緒申泙鐃緒申鐃�
MySQL鐃舜のワ申鐃緒申鐃緒申鐃緒申
MySQL鐃叔は￥申鐃緒申鐃緒申的鐃祝わ申mysql鐃緒申鐃初イ鐃緒申鐃緒申箸箸鐃緒申鐃緒申鐃緒申泪鐃宿ライ鐃緒申帖鐃緒申鐃緒申箸辰鐃獣種申鐃緒申鐃緒申鐃緒申遒件申泙鐃緒申鐃�mysql鐃緒申鐃初イ鐃緒申鐃緒申箸鐃銃逸申鐃緒申鐃祝は￥申MySQL鐃緒申root鐃醇ー鐃緒申鐃叔ワ申鐃藷スト￥申鐃緒申鐃緒申鐃緒申鐃緒申蠅件申鐃緒申僖鐃緒申錙種申匹鐃夙ってワ申鐃緒申鐃緒申鐃藷しまわ申鐃緒申
$ mysql -u root -p
鐃夙わ申鐃緒申鐃緒申鐃殉ワ申匹鐃渋行わ申鐃緒申函鐃緒申鐃緒申里茲�鐃緒申表鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
Enter password:
鐃緒申鐃緒申鐃叔￥申鐃術ワ申鐃緒ー鐃宿わ申鐃緒申鐃熟わ申鐃緒申鐃遵、Enter鐃緒申鐃緒申鐃薯押わ申鐃銃￥申鐃緒申鐃緒申鐃塾よう鐃緒申表鐃緒申鐃緒申鐃緒申鐃出ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申任鐃緒申鐃�
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 66
Server version: 5.1.41-3ubuntu12.6 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
Your MySQL connection id is 66
Server version: 5.1.41-3ubuntu12.6 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃塾削申鐃緒申
鐃殉わ申鐃緒申鐃緒申鐃緒申鐃塾ワ申鐃殉ワ申匹鐃渋行わ申鐃銃みて駕申鐃緒申鐃緒申鐃緒申mysql> SHOW DATABASES;
information_schema鐃緒申mysql鐃緒申test鐃夙わ申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申録鐃緒申鐃緒申討鐃緒申鐃熟わ申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申鐃塾ワ申鐃緒申廛鐃熟使わず鐃緒申鐃緒申鐃緒申鐃祝テワ申鐃緒申鐃術とわ申鐃緒申data1鐃夙わ申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�CREATE DATABASE data1;鐃緒申鐃緒申鐃叔もい鐃緒申鐃塾でわ申鐃緒申鐃緒申鐃緒申鐃�OpenOffice.org鐃緒申連鐃夙わ申鐃緒申鐃緒申櫃鐃淑醐申鐃緒申鐃緒申鐃緒申从鐃緒申裡鐃緒申弔箸鐃緒申謄鐃緒申薀わ申鐃緒申鐃夙わ申文鐃緒申鐃緒申鐃緒申鐃宿わ申utf8鐃緒申鐃緒申鐃所し鐃銃わ申鐃緒申鐃殉わ申鐃緒申
mysql> CREATE DATABASE data1 DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)
鐃緒申鐃緒申鐃叔もう鐃緒申鐃駿￥申SHOW DATABASES;鐃緒申孫圓鐃緒申鐃夙￥申data1鐃夙わ申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃獣わ申辰討鐃緒申襪鰹申箸鐃緒申認鐃叔わ申鐃殉わ申鐃緒申
鐃銃￥申鐃瞬ワ申虜鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃熟￥申鐃殉わ申鐃緒申鐃塾ままでわ申鐃緒申鐃渋際に￥申表鐃緒申鐃緒申鐃塾デ￥申鐃緒申鐃緒申鐃緒申録鐃緒申鐃緒申砲蓮屮董鐃緒申屮鐃竣わ申鐃緒申鐃緒申鐃緒申覆鐃緒申鐃出なわ申泙鐃緒申鵝�まわ申鐃緒申鐃叔￥申鐃緒申鐃薯１件ず鐃縦緒申鐃緒申鐃緒申鐃緒申里聾鐃緒申鐃重�鐃叔はなわ申鐃塾で￥申鐃緒申鐃俊￥申鐃緒申鐃緒申鐃粛わ申文鐃緒申鐃緒申離如鐃緒申鐃緒申鐃熟随申鐃緒申鐃�csv鐃春ワ申鐃緒申鐃緒申(文鐃緒申鐃緒申鐃緒申鐃宿わ申UTF8鐃祝わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃叔わ申test.csv鐃夙わ申鐃殉わ申)鐃緒申鐃術意わ申鐃銃逸申鐃緒申鐃緒申録鐃緒申鐃暑こ鐃夙にわ申鐃殉わ申鐃緒申csv鐃春ワ申鐃緒申鐃緒申蓮鐃�/var/lib/mysql/鐃淑駕申鐃祝わ申鐃緒申謄如鐃緒申鐃緒申戞鐃緒申鐃緒申鐃縮常申鐃緒申里弔鐃緒申鐃緒申侫鐃緒申鐃緒申鐃緒申鐃緒申存鐃緒申鐃銃わ申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃塾常申隋�/var/lib/mysql/data1鐃叔わ申鐃緒申鐃淑駕申鐃緒申鐃渋行わ申鐃暑コ鐃殉ワ申鐃�(鐃緒申鐃緒申鐃緒申分)鐃夙わ申鐃塾逸申味鐃緒申泙箸鐃銃わ申鐃緒申鐃殉わ申鐃緒申
mysql> USE data1;
鐃緒申鐃術わ申鐃緒申如鐃緒申鐃緒申戞鐃緒申鐃緒申鐃緒申鐃所し鐃殉わ申鐃緒申
mysql> CREATE TABLE table1 ( id int, name varchar(100) );
table1鐃夙わ申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申(鐃春ワ申鐃緒申鐃緒申鐃�)鐃緒申鐃夙わ申鐃緒申鐃緒申鐃粛わ申文鐃緒申鐃藷かとわ申鐃緒申鐃緒申鐃緒申鬚垢鐃宿�鐃竣わ申鐃緒申鐃所、鐃緒申鐃塾常申鐃緒申"id鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申"鐃緒申"name鐃夙わ申鐃緒申文鐃緒申鐃緒申"鐃塾ｏ申鐃縦わ申鐃粛わ申鐃緒申鐃緒申鐃緒申董鐃緒申屮鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃緒申侫鐃緒申鐃緒申鐃宿わ申名鐃塾つまわ申id鐃緒申name鐃緒申鐃緒申分鐃熟￥申鐃緒申鐃旬醐申任盥緒申鐃緒申泙鐃緒申鐃�
mysql> SHOW TABLES;
鐃銃￥申鐃瞬ワ申離螢刻申箸鐃宿緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申法鐃�table1鐃夙わ申鐃緒申鐃銃￥申鐃瞬ルが鐃獣わ申辰討鐃緒申鐃熟わ申鐃叔わ申鐃緒申USE data1;鐃塾実刻申鐃緒申鐃淑ら、SHOW TABLES FROM data1;鐃夙わ申鐃緒申鐃緒申鐃叔デ￥申鐃緒申鐃駿￥申鐃緒申名鐃緒申鐃緒申蠅刻申鐃宿�鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃�
mysql> LOAD DATA INFILE "test.csv" INTO TABLE table1 FIELDS TERMINATED BY ',' ENCLOSED BY '"';
鐃緒申鐃旬わ申鐃夙に￥申,鐃竣で駈申鐃准わ申鐃銃各デ￥申鐃緒申鐃緒申鐃緒申"鐃竣で駈申鐃殉れたcsv鐃春ワ申鐃緒申鐃緒申(test.csv)鐃緒申鐃宿み刻申鐃淳まわ申鐃緒申鐃緒申鐃塾よう鐃緒申表鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申鐃緒申任鐃緒申鐃�
Query OK, 10 rows affected (0.00 sec)
Records: 10 Deleted: 0 Skipped: 0 Warnings: 0
Records: 10 Deleted: 0 Skipped: 0 Warnings: 0
mysql> SELECT * FROM table1;
鐃銃￥申鐃瞬ワ申鐃緒申鐃夙わ申端鐃緒申鐃緒申鐃宿緒申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申粉鐃緒申鐃緒申任鐃緒申鐃淑醐申鐃緒申鐃緒申鐃緒申匹鐃重�鐃准でなわ申鐃夙￥申鐃曙イ鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申泙鐃緒申鐃�鐃銃￥申鐃瞬ワ申虜鐃緒申
鐃淑駕申鐃塾ワ申鐃殉ワ申匹如鐃緒申如鐃緒申鐃緒申虜鐃緒申鐃緒申鐃叔わ申鐃殉わ申鐃緒申鐃緒申 鐃銃￥申鐃瞬ワ申鐃緒申離如鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃祝は￥申
mysql> DELETE FROM table1;
鐃緒申鐃緒申鐃緒申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申里鐃緒申戮討離譽鰹申鐃緒申鐃�(鐃緒申録)鐃緒申探遒刻申鐃祝は￥申
mysql> TRUNCATE TABLE table1;
鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申速鐃叔わ申鐃緒申
鐃緒申 鐃銃￥申鐃瞬ルそ鐃塾わ申里鐃緒申鐃緒申鐃緒申鐃祝は￥申
mysql> DROP TABLE table1;
SQL命鐃緒申砲弔鐃緒申鐃�
DBMS鐃塾ワ申鐃初イ鐃緒申鐃緒申箸任蓮鐃緒申鐃塾よう鐃祝￥申鐃緒申鐃獣のワ申鐃殉ワ申匹鐃夙わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申SQL命鐃緒申箸鐃�SQL文鐃淑どと呼ばわ申鐃緒申鐃緒申僂慮鐃緒申鐃叔わ申鐃緒申SQL命鐃緒申蓮鐃宿�鐃緒申文鐃緒申鐃祝￥申;鐃竣わ申鐃春わ申鐃暑こ鐃夙になってわ申鐃殉わ申(鐃春わ申鐃淑わ申鐃緒申鐃緒申鐃緒申鐃峻わ申鐃緒申鐃瞬になわ申)鐃緒申鐃殉わ申鐃緒申SQL命鐃緒申鐃粛緒申鐃緒申(SELECT鐃淑わ申)鐃緒申鐃緒申文鐃緒申鐃夙常申文鐃緒申鐃緒申鐃緒申未鐃緒申鐃宿�鐃竣はわ申鐃緒申泙鐃緒申鵝�でわ申鐃緒申鐃緒申鐃叔￥申鐃緒申鐃駿￥申鐃緒申名鐃緒申董鐃緒申屮鐃縮常申望鐃淑醐申鐃緒申鐃夙わ申鐃緒申鐃夙わ申多鐃緒申鐃緒申鐃潤、予鐃緒申鐃緒申鐃緒申文鐃緒申鐃緒申表鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃宿みやす鐃緒申鐃淑わ申泙鐃緒申鐃�鐃淑わ申鐃緒申MySQL鐃緒申鐃初イ鐃緒申鐃緒申箸鐃塾誌申鐃緒申鐃祝は￥申鐃緒申quit鐃竣わ申鐃暑い鐃熟￥申exit鐃竣で緒申了鐃叔わ申鐃殉わ申鐃緒申鐃緒申鐃塾常申隋∧醐申鐃緒申痢鐃�;鐃竣わ申鐃緒申鐃竣でわ申鐃緒申
長鐃緒申鐃淑ってわ申鐃殉わ申鐃塾で￥申続鐃緒申鐃熟種申鐃緒申砲鐃緒申泙鐃緒申腓�鐃緒申
続鐃緒申鐃熟わ申鐃緒申鐃初→鐃緒申MySQL鐃叔試す鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申圓鐃緒申裡鐃緒申鐃�
鐃縦ワ申鐃緒申鐃緒申
