(Ž鐃緒申痢鐃緒申Ž鐃緒申鐃�)o鐃淳�緒申 sasata299's blog

2009鐃緒申鐃緒申鐃緒申02·鐃緒申鐃�10鐃緒申鐃緒申鐃緒申01:50

$\«\Æ\´\ê¡¼¤Ç¤¹$ MySQL

mysql鐃緒申鐃緒申鐃緒申\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申µ鐃緒申鐃緒申鐃緒申\鐃緒申\鐃緒申�鐃緒申¼\鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾�緒申鐃緒申鐃�

鐃緒申鐃薯Æ鐃緒申��申鐃緒申鐃�\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�(*Ž\鐃緒申�鐃緒申Ž\)\鐃緒申鐃�

鐃緒申鐃�\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申

鐃暑ǚ申鐃緒申鐃緒申鐃緒申鐃緒申鐃�SQL鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申½鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申¾鐃緒申鐃緒申��申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃�\µ鐃緒申鐃�¼\Ð鐃緒申鐃緒申鐃獣�緒申鐃緒申鐃緒申鐃緒申鐃緒申��鐃緒申鐃緒申鐃緒申·鐃緒申臓顱�鐃緒申鐃緒申�鐃峻�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�½Ð鐃緒申鐃�·鐃緒申鐃緒申鐃渋�緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�渋￥申

鐃緒申鐃�\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申

鐃緒申�鐃緒申\鐃緒申\鐃緒申\鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申��申Ð鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓鐃渋�緒申MySQL鐃緒申鐃緒申鐃緒申¼鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申µ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓��鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃渋�緒申
鐃緒申�鐃緒申\鐃緒申\鐃緒申\鐃緒申鐃�\µ鐃緒申鐃�¼\Ð鐃緒申鐃緒申鐃渋�緒申鐃緒申鐃�²鐃緒申��申�鐃緒申鐃緒申��申鐃緒申鐃緒申鐃渋￥申�鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃緒申½鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�MySQL鐃緒申鐃緒申鐃獣�緒申鐃緒申鐃�¼鐃緒申鐃�¹鐃緒申�鐃緒申µ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃渋�緒申

鐃緒申�鐃獣�渋�獣�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申³鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃獣�緒申«鐃緒申臓鐃�

¾鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申��申鐃緒申鐃�½鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃縮�緒申¼鐃緒申鐃緒申鐃緒申鐃緒申鐃�½鐃緒申鐃緒申鐃獣�緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃縮�渋￠Ê鐃緒申鐃緒申鐃緒申鐃緒申�鐃渋�曙¡�獣�渋�獣�緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃殉�緒申鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\¹鐃緒申鐃縮�緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�«鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�³鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申»鐃淳�緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃渋￥申\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃渋￥申\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃署¨�緒申鐃緒申鐃緒申鐃渋￥申¾鐃緒申鐃�¼鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�

鐃緒申鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃渋￥申\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\·\鐃緒申鐃�\鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申鐃殉�緒申鐃緒申鐃緒申鐃渋￡Ê鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃�µ鐃緒申鐃緒申鐃緒申鐃緒申臓��鐃緒申鐃緒申鐃緒申鐃緒申鐃�½Ð鐃緒申鐃�·鐃緒申鐃緒申鐃緒申鐃緒申鐃渋°ǚ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�

鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申鐃緒申臓鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申��申鐃緒申鐃�\鐃緒申鐃緒申鐃緒申¼\鐃緒申�鐃緒申鐃緒申�鐃暑î�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申�鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申��申鐃緒申鐃�entry\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋￥申comment\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃暑î�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃渋�緒申entry has many comments鐃緒申鐃緒申鐃渋￥申鐃緒申鐃�·鐃緒申鐃緒申鐃渋�緒申

CREATE TABLE entry (
    id int auto_increment primary key,
    title varchar(255),
    body text,
    delete_flag tinyint default 0
);

CREATE TABLE comment (
    id int auto_increment primary key,
    name varchar(255),
    content varchar(255),
    entry_id int not null
);

鐃緒申鐃緒申鐃緒申鐃緒申臓��鐃縮�緒申鐃緒申�鐃緒申鐃緒申鐃�\鐃緒申鐃緒申鐃緒申¼\鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃緒申³鐃緒申鐃緒申鐃緒申»鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋￥申\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�³鐃緒申鐃緒申鐃術�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�

select * from entry;
-------------------------------------
| id | title  | body  | delete_flag |
-------------------------------------
   1 | title1 | body1 |           0 |
   2 | title2 | body2 |           0 |
   3 | title3 | body3 |           0 |
   3 | title4 | body4 |           0 |
-------------------------------------

select * from comment;
------------------------------------
| id | name  | comment  | entry_id |
------------------------------------
|  1 | name1 | content1 |        1 |
|  2 | name2 | content2 |        2 |
|  3 | name3 | content3 |        4 |
|  4 | name4 | content4 |        1 |
|  5 | name5 | content5 |        2 |
|  6 | name6 | content6 |        3 |
|  7 | name7 | content7 |        1 |
------------------------------------

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�½鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申½Ð鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃渋￠Á鐃緒申鐃緒申鐃緒申鐃緒申��申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申鐃緒申臓鐃渋�緒申鐃緒申�鐃獣￥申鐃緒申鐃渋�獣�渋�緒申

鐃緒申�鐃緒申1鐃緒申�鐃緒申 \¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申��¿�峻�緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申¹¾鐃緒申鐃�¹鐃緒申鐃緒申鐃渋￥申

comment\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申entry_id鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申title鐃緒申鐃緒申鐃緒申¼鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾�緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申��申鐃緒申鐃�\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃�µ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�

delimiter //
CREATE PROCEDURE get_comment_content(IN id INT)
BEGIN
    select content from content where entry_id = id;
END
//

\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�½Ð鐃緒申鐃�·鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�call鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�

call get_comment_content(3);
------------
| content  |
------------
| content6 |
------------

call get_comment_content(1);
------------
| content  |
------------
| content1 |
| content4 |
| content7 |
------------

\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋￥申��¿�峻�緒申鐃緒申鐃�½Ð鐃緒申�鐃緒申鐃緒申鐃緒申鐃渋�緒申鐃緒申�鐃縦�峻�緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申µ鐃緒申陝�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申²鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃淳�緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃渋￠É鐃縮�緒申鐃緒申鐃�IN or OUT 鐃緒申鐃緒申鐃述�緒申鐃緒申鐃�µ鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃淳�緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申�鐃緒申

CREATE PROCEDURE hoge(IN name INT);
CREATE PROCEDURE fuga(OUT name2 VARCHAR(255));

鐃緒申�鐃緒申2鐃緒申�鐃緒申 \¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申½Ð鐃緒申�鐃緒申鐃緒申鐃縮�緒申鐃緒申鐃緒申鐃�¾鐃緒申鐃�¹鐃緒申鐃緒申鐃渋￥申

entry\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃�count鐃緒申鐃緒申鐃緒申¼鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾�緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�

delimiter //
CREATE PROCEDURE count_entry(OUT cnt INT)
BEGIN
    select count(*) from entry int cnt;
END
//

call count_entry(@data);
select @data;
---------
| @data |
---------
|     4 |
---------

鐃緒申鐃緒申²鐃緒申�鐃緒申鐃緒申�鐃渋�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�call鐃緒申鐃�·鐃緒申鐃緒申鐃緒申\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�½Ð鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申鐃�鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�@data鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃獣�緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�¼鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋￥申\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋￥申½Ð鐃緒申�鐃緒申鐃緒申鐃緒申鐃出�緒申鐃緒申�鐃緒申鐃緒申�鐃縦�峻�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�²鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉�緒申鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃術�渋￥申鐃�³鐃緒申鐃緒申鐃渋�緒申鐃緒申�鐃縦�峻�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申臓��°¡￥申

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓鐃緒申³鐃緒申鐃緒申鐃緒申2鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�渋�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申»鐃緒申鐃縮�緒申鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃術�渋￥申臓鐃�Ž鐃緒申鐃�Ž鐃緒申鐃緒申鐃緒申漫鐃緒申漫鐃緒申鐃�(#Ž鐃緒申痢鐃�\Ž鐃緒申鐃�)=鐃緒申�鐃緒申)鐃緒申�鐃緒申鐃�\)Ž鐃緒申鐃�;'.Ž\鐃緒申鐃縮￥申鐃縮￥申鐃緒申Ž鐃緒申鐃�Ž鐃緒申!!
鐃緒申鐃�½鐃緒申鐃緒申鐃緒申»鐃淳�緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申鐃緒申臓鐃緒申½鐃緒申鐃緒申鐃術�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¼鐃緒申�鐃緒申鐃緒申�鐃渋�緒申鐃緒申鐃緒申鐃述�緒申«鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃渋�緒申

鐃緒申�鐃緒申3鐃緒申�鐃緒申 \¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃�¼鐃緒申鐃緒申鐃緒申鐃緒申�鐃渋�緒申鐃緒申臓鐃�

entry_id鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申comment鐃緒申鐃緒申鐃渋�縦�峻�緒申鐃緒申鐃�\«\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申·鐃緒申臓鐃緒申½鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申count\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申��鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾�緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�2·鐃緒申鐃緒申��申¾鐃緒申鐃�\³\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申µ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃渋￥申many_flag鐃緒申鐃緒申鐃緒申1鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃署¨�緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�

count\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申³鐃緒申鐃緒申鐃術�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋￥申

CREATE TABLE count (
    id int auto_increment primary key,
    entry_id int not null,
    count int not null,
    many_flag tinyint
);

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓鐃緒申³鐃緒申鐃緒申鐃緒申\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申�鐃署´�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�µ鐃緒申鐃緒申鐃緒申鐃緒申�鐃曙¡�緒申\«鐃緒申鐃�¼\½\鐃緒申鐃緒申鐃渋×�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾�緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃縦�渋￥申

delimiter //
CREATE PROCEDURE summary()
BEGIN
    DECLARE done int;
    DECLARE _entry_id int;
    DECLARE _count int;
    DECLARE cur CURSOR FOR
        select entry_id, count(entry_id) as count from comment group by entry_id;
    DECLARE EXIT HANDLER FOR NOT FOUND SET done = 0;

    SET done = 1;
    OPEN cur;
    WHILE done DO
        FETCH cur INTO _entry_id, _count;
        IF _count > 1 THEN
            insert into count values(null, _entry_id, _count, 1);
        ELSE
            insert into count values(null, _entry_id, _count, 0);
        END IF;
    END WHILE;
    CLOSE cur;
END
//

call summary;
select * from count;
-------------------------------------
| id | entry_id | count | many_flag |
-------------------------------------
|  1 |        1 |     3 |         1 |
|  2 |        2 |     2 |         1 |
|  3 |        3 |     1 |         0 |
|  4 |        4 |     1 |         0 |
-------------------------------------

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申²鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申

DECLARE cur CURSOR FOR
    select entry_id, count(entry_id) as count from comment group by entry_id;

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃暑¡￥申cur鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申\«鐃緒申鐃�¼\½\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申Ð鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申鐃緒申�鐃緒申鐃緒申鐃�µ鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�\«鐃緒申鐃�¼\½\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋￥申SQL鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�

FETCH cur INTO _entry_id, _count;

鐃緒申鐃緒申鐃緒申鐃緒申臓鐃緒申³鐃緒申鐃緒申鐃渋�緒申鐃緒申�鐃緒申鐃縮�緒申鐃緒申鐃緒申鐃緒申½鐃緒申鐃緒申鐃緒申\«鐃緒申鐃�¼\½\鐃緒申鐃緒申鐃緒申鐃緒申鐃�·鐃緒申鐃�²鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�1¹鐃緒申�鐃緒申鐃緒申��申鐃緒申鐃� _entry_id 鐃緒申鐃緒申鐃緒申 _count 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃獣�緒申鐃緒申�鐃縦�峻�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃�«鐃緒申�鐃渚Ǚ申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申½鐃緒申鐃緒申鐃獣�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃�«鐃緒申�鐃緒申

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¾鐃緒申��申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申³鐃緒申鐃緒申鐃渋�緒申鐃緒申�鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃淳�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申²鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申鐃緒申鐃緒申鐃渋￥申臓鐃緒申¹鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃緒申(鐃緒申臓鐃緒申鐃緒申鐃緒申\鐃緒申�鐃緒申)

[»²¹鐃緒申鐃�]
MySQL \¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃�
MySQL5³«鐃緒申鐃緒申鐃術�緒申鐃緒申鐃� - \¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申¼\鐃緒申鐃�\鐃緒申�鐃渋�緒申\鐃緒申鐃�\鐃緒申鐃�\鐃縮�緒申鐃緒申鐃�\¹\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃�¼«鐃緒申鐃緒申鐃�²½

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申«鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�\¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃渋�曙¡�曙Ǚ申鐃淳�緒申鐃緒申鐃緒申鐃縦￥申鐃緒申鐃緒申鐃術�緒申鐃緒申鐃緒申鐃緒申³鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申MySQL鐃緒申鐃緒申鐃獣�緒申鐃緒申鐃緒申鐃署´�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃署´�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�½Ð鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉�緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�mysql鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¾鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申帖鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申µ鐃緒申�鐃緒申½鐃緒申鐃縮�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃渋￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃術�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申�鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申

¸½¾ì¤Ç»È¤¨¤ë MySQL (DB Magazine SELECTION)

鐃緒申鐃�½¾鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃緒申鐃緒申鐃署¨�緒申鐃緒申鐃� MySQL (DB Magazine SELECTION)
鐃緒申鐃緒申鐃緒申¼鐃緒申�鐃渋￥申¾¾鐃緒申�鐃緒申 ²鐃緒申鐃緒申鐃緒申鐃緒申鐃�
鐃緒申鐃緒申鐃渋�緒申鐃緒申鐃緒申鐃緒申µ鐃緒申臓鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申¼鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃巡¡￥申2006-03-17
鐃緒申鐃緒申鐃曙™申¹鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃純¡￥申

\鐃緒申鐃�\鐃緒申鐃�\³\鐃緒申�鐃緒申鐃緒申�鐃緒申«鐃緒申鐃緒申鐃緒申

$¤³¤Î\¨\ó\È\ê¡¼¤ò¤Ï¤Æ¤Ê\Ö\Ã\¯\Þ¡¼\¯¤ËÄÉ²Ã$

\鐃緒申鐃�\鐃緒申鐃緒申臓鐃�: mysql; \¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃�

\³\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申��申鐃緒申鐃緒申鐃� (1)

- 1. 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�·鐃緒申鐃緒申鐃緒申DB鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申
- 2016鐃緒申鐃緒申鐃緒申10·鐃緒申鐃�20鐃緒申鐃緒申鐃緒申 01:31
- \¹\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃�»²¹鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�·鐃緒申鐃緒申鐃縦�渋￥申
  
  鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓鐃渋�緒申鐃緒申²鐃緒申鐃縮�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�»鐃淳�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃縦�緒申鐃緒申�鐃緒申鐃緒申鐃�½鐃緒申�鐃緒申¹鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�
  
  鐃緒申�鐃緒申鐃緒申²鐃緒申鐃緒申鐃緒申\鐃緒申\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申µ鐃緒申鐃緒申鐃緒申SQL
  select count(*) from entry int cnt;
  
  鐃緒申鐃緒申鐃緒申µ鐃緒申��Ǚ申鐃緒申��申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申鐃縮�渋￠Àµ鐃緒申鐃�·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申
  select count(*) from entry into cnt;
  
  鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申»鐃淳�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申¹鐃緒申臓鐃�
  鐃緒申鐃�³鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�µ鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�

\³\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申

鐃緒申鐃�¾鐃緒申鐃緒申鐃�
	¾鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃�µ²鐃緒申鐃緒申鐃�¾²鐃緒申鐃� 鐃緒申鐃緒申鐃� 鐃緒申鐃緒申鐃�

karaage299 at gmail.com

鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申µ»鐃緒申鐃�

Ruby Freaks Lounge (28,30)
NoSQL鐃緒申鐃緒申鐃緒申»鐃緒申�鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾�緒申鐃緒申鐃�

鐃緒申��緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�

鐃緒申��申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�µ»鐃緒申鐃�

PR鐃緒申鐃緒申鐃述�暑î�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申µ鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�2鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋�緒申³鐃緒申鐃緒申鐃緒申

PostgreSQL鐃緒申鐃緒申鐃緒申SQL鐃緒申鐃緒申鐃緒申·鐃緒申鐃�²鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申«鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申鐃�½¼鐃緒申鐃緒申鐃�·鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃�

Real Tech Night 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃�·鐃緒申鐃緒申鐃緒申 #realtech

redash鐃緒申鐃緒申鐃緒申鐃緒申鐃�·鐃緒申鐃緒申鐃純™申鐃緒申鐃�AWS鐃緒申鐃緒申鐃緒申鐃�鐃緒申鐃緒申鐃述�緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�5鐃緒申鐃緒申�鐃緒申鐃緒申鐃�¹½鐃緒申鐃緒申鐃遵™申¹鐃緒申鐃緒申鐃緒申

Google Analytics鐃緒申鐃�«鐃緒申鐃緒申鐃緒申\¹\鐃緒申\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\·鐃緒申鐃�¼\鐃緒申鐃緒申鐃緒申鐃緒申鐃�\鐃緒申鐃緒申鐃緒申¼\鐃緒申�鐃緒申鐃緒申鐃�¼«鐃緒申鐃緒申��申鐃緒申帖�鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申Classi鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申³鐃緒申鐃�¹»鐃緒申鐃緒申鐃出�緒申�鐃緒申鐃緒申鐃�\µ鐃緒申鐃�¼\鐃緒申鐃�\¹鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申��³

'); label.html('\ \鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申\鐃緒申鐃�\鐃緒申鐃�\鐃暑™申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹¹鐃緒申�鐃緒申鐃緒申鐃�\鐃緒申�鐃緒申¼\½\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申��申鐃緒申鐃緒申鐃緒申鐃緒申鐃�²鐃緒申鐃緒申鐃緒申鐃縮�緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申�鐃緒申鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�¼(cookie)鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申·鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�
\ 鐃緒申鐃�³鐃緒申鐃緒申鐃緒申\Ð\鐃緒申鐃緒申鐃緒申¼鐃緒申鐃緒申鐃述�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申«鐃殉�巡Ǚ申鐃緒申鐃緒申鐃緒申鐃緒申·鐃緒申�鐃緒申³鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申鐃�³鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�¼鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃�¾µ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申µ鐃緒申鐃�»鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�
\ 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縦�渋￥申鐃緒申鐃緒申µ鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¼鐃緒申鐃�\鐃緒申�鐃緒申¼\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申¼鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃曙™申�鐃緒申鐃緒申鐃�½鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¼鐃緒申鐃緒申鐃緒申³鐃緒申鐃�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�¼鐃緒申鐃緒申鐃緒申»鐃緒申鐃緒申鐃緒申鐃緒申�鐃緒申鐃緒申辧鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申鐃緒申鐃緒申鐃緒申鐃�³鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�鐃緒申鐃緒申鐃緒申鐃緒申鐃�¹鐃緒申臓鐃�
\ ¾鐃緒申��Ù™申鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃�\鐃書Í鐃緒申�鐃緒申鐃緒申鐃�µ鐃縮�緒申鐃緒申�鐃緒申鐃緒申�鐃緒申³鐃緒申�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�µ鐃緒申鐃緒申鐃緒申鐃緒申臓鐃�\ '); banner.append(label); var closeButton = $('

(Ž鐃緒申痢鐃緒申Ž鐃緒申鐃�)o鐃淳�緒申 sasata299's blog

鐃緒申�鐃緒申MySQL鐃緒申臓鐃�\«\鐃緒申鐃�\鐃緒申\鐃緒申鐃緒申鐃緒申鐃緒申�鐃暑Ǚ申鐃緒申鐃�·µ­»鐃緒申鐃�

\³\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申��申鐃緒申鐃緒申鐃� (1)

\³\鐃緒申鐃�\鐃緒申鐃�\鐃緒申鐃緒申鐃緒申¹鐃緒申鐃緒申鐃緒申

鐃緒申�鐃緒申MySQL鐃緒申臓鐃�\«\鐃緒申鐃�\鐃緒申\鐃緒申鐃緒申鐃緒申鐃緒申�鐃暑Ǚ申鐃緒申鐃�·µ»鐃緒申鐃�