X-Sequence: fml-devel 204

Q:  sql Ĥ cf ե˽񤱤褦ˤƤ

A1: 롼ԥ󥰤ɽ

	mysql:ID ʤɤȽ񤤤ˡ ID ǤΥ롼ԥ󥰤ɽǤ
	ɤ  .ini  :-)

A2: SQL ʸ񤱤褦ˤƤФ褤

	ؿƤФ줿˻ϤƷޤѿ⤢Τ
	cf 뤳ȤϤǤʤ

	lexical scope Ǽ갷ѿɽв衩
	: &varname ˡ()

	: IO::Adapter  new IO::Adapter $mapname $config ʤɤȤ

 cf 㡧

member_maps 	= 	mysql:database

recipient_maps 	= 	mysql:database

[mysql:database]

sql_server	=	localhost
sql_user	=	fml
sql_password	=	pa$$word
sql_database	=	ml
sql_table	=	fml

get_next_key	=	select address from $sql_table
			where ml = '&ml_name' and type = '&type'

getline		=	select * from $sql_table
			where ml = '&ml_name' and type = '&type'

add		=	insert into $sql_table
			values ('$ml_name', '&address', '&type')

delete		=	delete from $sql_table
			where ml = '&ml_name' and addrss = '&address'

find		=	select * from $sql_table
			where ml = '&ml_name' and address like '&regexp'

