mysql - mysql动态创建表

Question

如何在mysql中使用存储过程动态创建表？

Declare @SalaryTable Table(Empid bigint, EmpName varchar(100), 
                           Desigation bigint, Office bigint, BasicPay Decimal(8,0),
                           WorkingDay tinyint, Present numeric(4,2), SalaryDay numeric(4,2), 
                           Overtime numeric(5,2), OthIncome Decimal(8,0), 
                           OthDeduction Decimal(8,0), OthIncome_TA Decimal(8,0), 
                           OthDeduction_TA Decimal(8,0), OthIncome_NA Decimal(8,0), 
                           OthDeduction_NA Decimal(8,0), OthIncome_TN Decimal(8,0), 
                           OthDeduction_TN Decimal(8,0), OthIncome_NN Decimal(8,0), 
                           OthDeduction_NN Decimal(8,0), GrossSalary Decimal(8,0), 
                           TDS Decimal(7,0), EMI Decimal(8,0), NetSalary Decimal(8,0))

Answer 1

创建新表的存储过程:

 CREATE PROCEDURE sproc_BuildTable 
          @TableName NVARCHAR(128)
          ,@Column1Name NVARCHAR(32)
          ,@Column1DataType NVARCHAR(32)
          ,@Column1Nullable NVARCHAR(32)


   AS

   DECLARE @SQLString NVARCHAR(MAX)
   SET @SQString = 'CREATE TABLE '+@TableName + '( '+@Column1Name+' '+@Column1DataType +' '+@Column1Nullable +') ON PRIMARY '

   EXEC (@SQLString)

   GO

希望这有效