MySQL查询动态创建表？

为此，您可以使用存储过程。让我们动态创建一个具有两列的表，即StudentId为int，而StudentName为varchar-

DELIMITER $$ CREATE PROCEDURE creatingDynamicTableDemo(yourTableName VARCHAR(200)) -> BEGIN -> SET @name = yourTableName; -> SET @st = CONCAT( > CREATE TABLE IF NOT EXISTS ` , @name, ` ( > `StudentId` int UNSIGNED NOT NULL AUTO_INCREMENT, > `StudentName` varchar(20) NOT NULL, > PRIMARY KEY (`StudentId`) > ) > ); -> PREPARE myStatement FROM @st; -> EXECUTE myStatement; -> DEALLOCATE PREPARE myStatement; -> END $$ DELIMITER ;

上面，我们将StudentId设置为PRIMARYKEY。

借助CALL命令调用存储过程-

call creatingDynamicTableDemo(DemoTable);

现在您可以检查表的说明-

desc DemoTable;

输出结果

这将产生以下输出-

+-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | StudentId | int(10) unsigned | NO | PRI | NULL | auto_increment | | StudentName | varchar(20) | NO | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec)