php建立臨時表

$sql= "create temporary table yc_linshi (
                        img varchar(100) not null,
                         openid varchar(50) not null,
                          shopPrice decimal ,
                         goodsName varchar (100),
                         ptnum varchar (50))";
                $affected = Db::execute($sql);      

轉載于:https://www.cnblogs.com/wrld/p/9714209.html