56,675
社区成员
发帖
与我相关
我的任务
分享
存储过程中:
set @sign=0;
select 1 into @sign from information_schema
where table_name='aa' and table_schema='表aa所在数据库名称';
if @sign=0 then
create table aa .....
end if;
命令行:
create table if not exists aa(
表定义
);
delimiter $$
create procedure table_create(IN tablename varchar(100))
begin
create table if not exists tablename
(num int );
end$$
delimiter ;
]
delimiter $$
create procedure table_create(IN tablename varchar(100))
begin
set @sql=concat("create table if not exists ",tablename,"(num int )");
prepare darwin FROM @sql;
execute darwin;
drop prepare darwin;
end$$
delimiter ;