mapper文件中sql 小于:"<";大于:
mariadb存储过程:
create or replace procedure create_all_view_from_table(IN y int,IN x int, IN tableName varchar(100)) BEGIN SET @i = 0; SET @sql = CONCAT('create view view_all_',tableName,' as ' ); WHILE @i<x DO set @sql = concat(@sql,'select * from ',tableName,'_',y,'_',@i); if @i != x-1 then set @sql = concat(@sql,' union '); end if; SET @i = @i+1; END WHILE; PREPARE create_stmt FROM @sql; EXECUTE create_stmt; END;
mysql 日期格式化:
date_format(now(),'%Y-%m-%d %H:%i:%s')