Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Erin Salmon

    Default SQL: Temporary Tables


    Can someone explain to me how to determine just how temporary a temporary table is.

    I am trying to use one for a shopping cart system, in which the user stores products in a temporary table. The temporary table would be deleted after they leave.

    I've run SQL in a query in mySQL to create a temporary table, and I can access the table for about a minute or two, after which it is gone. How can I extend this time to suit my application?



  2. #2
    Graham L

    Default Re: SQL: Temporary Tables

    Temporary tables are associated with a connection ... and last only as long as the connection. Perhaps since http: is not a connection protocol, that is the problem. ;-) This note might give you some ideas.

  3. #3

    Default Re: SQL: Temporary Tables

    I use MS SQL Server, which i'm assuming will be the same SQL:

    Use #(Table_Name) for a local temp table, which disappears when the code completes ie if the temp table is in a stored procedure or running a batch of code together.

    Use ##(Table_Name) for a temp table that you can call from a different connection to the server.

Similar Threads

  1. Dreamweaver MX tables
    By Greg S in forum PressF1
    Replies: 1
    Last Post: 07-03-2004, 10:18 AM
  2. Tables in HTML
    By Chilling_Silently in forum PressF1
    Replies: 12
    Last Post: 20-06-2003, 05:06 PM
  3. Tables in HTML
    By Gorela in forum PressF1
    Replies: 5
    Last Post: 07-09-2002, 12:28 PM
  4. XL Pivot Tables
    By in forum PressF1
    Replies: 0
    Last Post: 08-05-2001, 07:59 PM
  5. XL Pivot Tables
    By in forum PressF1
    Replies: 0
    Last Post: 30-01-2001, 10:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts