需要保存一些創建表的語句,這些語句的表首碼是可以設置的一個變數,就需要用到以下方法了,如果誰有更好的方法,請告知,謝謝。
mysql中使用變數執行sql語句:
01.
set
@PREFIX =
'fk_'
;
02.
create
database
fk_manage;
03.
use fk_manage;
04.
set
@QUERY = concat(
"create table "
, @PREFIX,
"user(
05.
id, int(10) primary key auto_incresment,
06.
name, varchar(25) not null,
08.
email, varchar(50),
09.
reg_date, TIMESTAMP default CURRENT_TIMESTAMP,
10.
last_login, TIMESTAMP default CURRENT_TIMESTAMP on update current_timestamp);"
);
11.
prepare
execsql
from
@QUERY;
12.
execute
execsql;
13.
14.
set
@QUERY = concat(
"create table "
, @PREFIX,
"role(
15.
id, int(10) primary key auto_incresment,
16.
name, varchar(25) not null,
17.
action, varchar(32) not null,
18.
inuse, tinyint default 1 comment '1 for use,0 for stop',
19.
create_date, TIMESTAMP default CURRENT_TIMESTAMP);"
);
20.
prepare
execsql
from
@QUERY;
21.
execute
execsql;
22.
23.
deallocate
prepare
execsql;
摘自:DigDeeply's Blog
留言列表