set @suffix=date_format(now(),'%Y%m');
set @sqlstr = concat(
'create table IF NOT EXISTS POS_',cast(@suffix as char),
'(
loginnum int NOT NULL ,
time int NOT NULL ,
longitude varchar(12) NOT NULL ,
latitude varchar(12) NOT NULL ,
date TIMESTAMP NOT NULL default CURRENT_TIMESTAMP
)',
'type=InnoDB'
);
select @sqlstr;
PREPARE DD FROM @sqlstr;
EXECUTE DD;
set @sqlstr = concat(
'create table IF NOT EXISTS POS_',cast(@suffix as char),
'(
loginnum int NOT NULL ,
time int NOT NULL ,
longitude varchar(12) NOT NULL ,
latitude varchar(12) NOT NULL ,
date TIMESTAMP NOT NULL default CURRENT_TIMESTAMP
)',
'type=InnoDB'
);
select @sqlstr;
PREPARE DD FROM @sqlstr;
EXECUTE DD;