解决方案 »
- 新手学MYSQL 用BCB6 使用mysql的API(新手散分)
- mysql 同一查询语句在2台服务器上执行都在1000MS以上,而本机只要47ms
- redhat Liunx 9.0 下如何安装 Mysql 4.0.15 ?
- 请教增加外键的sql语句
- 我如何光把数据库里面的表定义倒出来呢?。。。。
- 在Delphi中用dbExpress连接MySQL,提示“not load "libmysql.dll"”?
- 一个小问题,诚心求教,在线等。。。。
- 为何mysql查询约4000条数量,很慢,约30s
- sql如果表里有这条数据就插入,没有就不插入
- mac安装win10以后安装mamp环境mysql启动不了
- MYSQL中身份证号怎么确认出生日期和年龄?
- 能否用mysql 创建ODBC数据表?
mysql> DELIMITER $$
mysql>
mysql> DROP PROCEDURE IF EXISTS `CreateTempTable`$$
Query OK, 0 rows affected (0.00 sec)mysql>
mysql> CREATE PROCEDURE `CreateTempTable`(in paraName varchar(256))
-> BEGIN
-> set @sql_CreateTempTable=concat('DROP TABLE IF EXISTS ',paraName);
-> PREPARE stmt1 FROM @sql_CreateTempTable;
-> EXECUTE stmt1 ;
-> DEALLOCATE PREPARE stmt1;
->
-> set @sql_CreateTempTable=concat('CREATE TABLE ',paraName, ' (',
-> 'Owner varchar(256) default \'\',',
-> 'CalleeNO varchar(256) default \'\',',
-> 'DateTime datetime default NULL',
-> ') ENGINE=MyISAM DEFAULT CHARSET=utf8'
-> );
-> PREPARE stmt1 FROM @sql_CreateTempTable;
-> EXECUTE stmt1 ;
-> DEALLOCATE PREPARE stmt1;
->
-> END$$
Query OK, 0 rows affected (0.00 sec)mysql>
mysql> DELIMITER ;
mysql> call CreateTempTable('t_forimprove');
Query OK, 0 rows affected (0.06 sec)mysql> desc t_forimprove;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| Owner | varchar(256) | YES | | | |
| CalleeNO | varchar(256) | YES | | | |
| DateTime | datetime | YES | | NULL | |
+----------+--------------+------+-----+---------+-------+
3 rows in set (0.06 sec)mysql>
BEGIN
set @sql_CreateTempTable=concat('DROP TABLE IF EXISTS ',paraName);
PREPARE stmt1 FROM @sql_CreateTempTable;
EXECUTE stmt1 ;
DEALLOCATE PREPARE stmt1;
set @sql_CreateTempTable=concat('CREATE TABLE ',paraName, ' (',
'Owner varchar(256) default \'\',',
'CalleeNO varchar(256) default \'\',',
'DateTime datetime default NULL',
') ENGINE=MyISAM DEFAULT CHARSET=utf8'
);
PREPARE stmt1 FROM @sql_CreateTempTable;
EXECUTE stmt1 ;
DEALLOCATE PREPARE stmt1; END$$DELIMITER ;