3 * MySQL¥Ð¥¤¥ó¥Ç¥£¥ó¥°¤òÍѤ¤¤¿Æ°ºî³ÎǧÎã
5 ** mysql¥¯¥é¥¤¥¢¥ó¥Èµ¯Æ°
14 mysql> create database senna_test;
16 ¥Ç¡¼¥¿¥Ù¡¼¥¹ºîÀ®¤µ¤ì¤¿¤³¤È¤ò³Îǧ¡£
18 mysql> show databases;
26 3 rows in set (0.00 sec)
30 °Ê²¼¤Î¥Æ¡¼¥Ö¥ë¤òsenna_test¤ËºîÀ®
33 CREATE TABLE table01 (
34 id INT UNSIGNED AUTO_INCREMENT NOT NULL, PRIMARY KEY(id),
42 °Ê²¼¤Î¤è¤¦¤Ê¥Õ¥¡¥¤¥ë(insert_to_table)¤«¤é¡¢table01¤Ë¥ì¥³¡¼¥ÉÅÐÏ¿
45 INSERT INTO table01 VALUES
46 (NULL, "½°±¡Áªµó¤Ë¤Ä¤¤¤Æ", "³§¤µ¤ó¤Ï¤Ï¤É¤ÎÅÞ¤ËÅêɼ¤¹¤ë¤Î¤Ç¤·¤ç¤¦¤«"),
47 (NULL, "²Ìʪ", "apple ¥ê¥ó¥´¡¢orange ¥ª¥ì¥ó¥¸"),
48 (NULL, "²Î", "¤ï¤¯¤ï¤¯¤µ¤»¤Æ¤è¡¢¤Ä¤¤¤Æ¤ë¤Í¤Î¤Ã¤Æ¤ë¤Í"),
49 (NULL, "MySQL", "MySQL¥ê¥Õ¥¡¥ì¥ó¥¹¥Þ¥Ë¥å¥¢¥ë¤òÁ´ÉôÆɤá"),
50 (NULL, "¥í¥Ü¥Ã¥È¤Îgood design¤È¤Ï", "Àè½µËö¤Ë³«ºÅ¤µ¤ì¤¿ GoodDesignPresentation 2005");
52 # mysql -u root < insert_to_table
54 ** Á´Ê¸¸¡º÷WHERE MATCH¤Î³Îǧ
56 °Ê²¼¤Î¤è¤¦¤Ê¥Õ¥¡¥¤¥ë(search)¤«¤é¡¢¸¡º÷Æ°ºî¤ò³Îǧ¡£
59 SELECT * FROM table01 WHERE MATCH(body) AGAINST('Åêɼ');
60 SELECT * FROM table01 WHERE MATCH(body) AGAINST('Åêɼ¤¹¤ë');
61 SELECT * FROM table01 WHERE MATCH(body) AGAINST('apple');
62 SELECT * FROM table01 WHERE MATCH(body) AGAINST('¥ê¥ó¥´');
63 SELECT * FROM table01 WHERE MATCH(body) AGAINST('¤ï¤¯¤ï¤¯');
64 SELECT * FROM table01 WHERE MATCH(body) AGAINST('gooddesign');
65 SELECT * FROM table01 WHERE MATCH(body) AGAINST('Æɤá');
67 # mysql -u root < search
69 ±Ñ¸ì¡¢ÆüËܸì¤È¤â¸¡º÷¤Ç¤¤¿¡£
73 °Ê²¼¤Î¤è¤¦¤Ê¥Õ¥¡¥¤¥ë(upd_and_search)¤«¤é¥ì¥³¡¼¥É¤Î¹¹¿·¤È¸¡º÷¤ÎÆ°ºî¤ò³Îǧ¡£
76 UPDATE table01 SET body = 'wakuwakusaseteyo,¤Ä¤¤¤Æ¤ë¤Í¤Î¤Ã¤Æ¤ë¤Í' WHERE id = 3;
77 SELECT * FROM table01 WHERE MATCH(body) AGAINST('wakuwaku');
78 UPDATE table01 SET body = '¤ï¤¯¤ï¤¯¤µ¤»¤Æ¤è¡¢¤Ä¤¤¤Æ¤ë¤Í¤Î¤Ã¤Æ¤ë¤Í' WHERE id = 3;
79 SELECT * FROM table01 WHERE MATCH(body) AGAINST('¤ï¤¯¤ï¤¯¤µ¤»¤Æ¤è');
80 UPDATE table01 SET body = '¥°¥Ã¥É¥Ç¥¶¥¤¥ó' WHERE id = 5;
81 SELECT * FROM table01 WHERE MATCH(body) AGAINST('¥°¥Ã¥É¥Ç¥¶¥¤¥ó');
82 UPDATE table01 SET body = 'good design 2005' WHERE id = 5;
83 SELECT * FROM table01 WHERE MATCH(body) AGAINST('design');
84 UPDATE table01 SET body = 'read mysql reference manual' WHERE id = 4;
85 SELECT * FROM table01 WHERE MATCH(body) AGAINST('manual');
87 # mysql -u root < upd_and_search
89 ¹¹¿·¡¢¸¡º÷¤È¤âÀµ¤·¤¯Æ°ºî¤·¤¿¡£