Mobile-Menu iFuturz Infoweb Inc. Contact Portfolio

10

Aug

How to create the temporary table in MYSQL using X-cart

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.

For Example

Look at following code :

View Code PHP
 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 )");
  • Tags:

Comment