How to create the temporary table in MYSQL using X-cart
Posted On : August 10, 2013
| No Comment
Temporary table can be used for storing temporary data in mysql.The most important part Is that Temporary table will be deleted when the current client session terminated.
Temporary table will be used only for MySQL version 3.23.If you are using older version so you cannot use temporary table.
Look at following code :
include(/func/func.db.php) db_query("CREATE TEMPORARY TABLE IF NOT EXISTS `webchat_users` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`name` varchar(16) NOT NULL, `gravatar` varchar(32) NOT NULL )");