可动态创建啊,存储过程不支持动态游标查询 ,CREATE PROCEDURE ps_create_table_more(IN i INT) BEGIN DECLARE k INT; SET k = 1; WHILE k < i DO SET @t = k; SET @tname = concat('sp3_', @t, 'k'); SET @dwhe = '(id int,name varchar(255));'; SET @sql_text := concat('create table ', @tname, @dwhe); PREPARE stmt FROM @sql_text; EXECUTE stmt; SET k = k + 1; END WHILE; END
TABLE是可以的。我指的是drop procedure和create procedure不行
The following SQL statements can be used as prepared statements: ALTER TABLE ANALYZE TABLE CACHE INDEX CALL CHANGE MASTER CHECKSUM {TABLE | TABLES} COMMIT {CREATE | DROP} DATABASE {CREATE | RENAME | DROP} USER CREATE INDEX CREATE TABLE DELETE DO DROP INDEX DROP TABLE FLUSH {TABLE | TABLES | TABLES WITH READ LOCK | HOSTS | PRIVILEGES | LOGS | STATUS | MASTER | SLAVE | DES_KEY_FILE | USER_RESOURCES} GRANT INSERT INSTALL PLUGIN KILL LOAD INDEX INTO CACHE OPTIMIZE TABLE RENAME TABLE REPAIR TABLE REPLACE RESET {MASTER | SLAVE | QUERY CACHE} REVOKE SELECT SET SHOW BINLOG EVENTS SHOW CREATE {PROCEDURE | FUNCTION | EVENT | TABLE | VIEW} SHOW {AUTHORS | CONTRIBUTORS | WARNINGS | ERRORS} SHOW {MASTER | BINARY} LOGS SHOW {MASTER | SLAVE} STATUS SLAVE {START | STOP} UNINSTALL PLUGIN UPDATEOther statements are not yet supported. .
好像在SP里面实现不了
PROCEDURE ps_create_table_more(IN i INT)
BEGIN
DECLARE k INT; SET k = 1;
WHILE k < i
DO
SET @t = k;
SET @tname = concat('sp3_', @t, 'k');
SET @dwhe = '(id int,name varchar(255));';
SET @sql_text := concat('create table ', @tname, @dwhe);
PREPARE stmt FROM @sql_text;
EXECUTE stmt;
SET k = k + 1;
END WHILE;
END
TABLE是可以的。我指的是drop procedure和create procedure不行
ANALYZE TABLE
CACHE INDEX
CALL
CHANGE MASTER
CHECKSUM {TABLE | TABLES}
COMMIT
{CREATE | DROP} DATABASE
{CREATE | RENAME | DROP} USER
CREATE INDEX
CREATE TABLE
DELETE
DO
DROP INDEX
DROP TABLE
FLUSH {TABLE | TABLES | TABLES WITH READ LOCK | HOSTS | PRIVILEGES
| LOGS | STATUS | MASTER | SLAVE | DES_KEY_FILE | USER_RESOURCES}
GRANT
INSERT
INSTALL PLUGIN
KILL
LOAD INDEX INTO CACHE
OPTIMIZE TABLE
RENAME TABLE
REPAIR TABLE
REPLACE
RESET {MASTER | SLAVE | QUERY CACHE}
REVOKE
SELECT
SET
SHOW BINLOG EVENTS
SHOW CREATE {PROCEDURE | FUNCTION | EVENT | TABLE | VIEW}
SHOW {AUTHORS | CONTRIBUTORS | WARNINGS | ERRORS}
SHOW {MASTER | BINARY} LOGS
SHOW {MASTER | SLAVE} STATUS
SLAVE {START | STOP}
UNINSTALL PLUGIN
UPDATEOther statements are not yet supported.
.
TABLE是可以的。我指的是drop procedure和create procedure不行Sorry 的确不支持 ........