Results 1 to 3 of 3
  1. #1
    Erin Salmon
    Guest

    Default SQL: Temporary Tables

    Hi,

    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?

    Cheers,

    Erin

  2. #2
    Graham L
    Guest

    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
    Marlboro
    Guest

    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, 09:18 AM
  2. Tables in HTML
    By Chilling_Silently in forum PressF1
    Replies: 12
    Last Post: 20-06-2003, 04:06 PM
  3. Tables in HTML
    By Gorela in forum PressF1
    Replies: 5
    Last Post: 07-09-2002, 11:28 AM
  4. XL Pivot Tables
    By in forum PressF1
    Replies: 0
    Last Post: 08-05-2001, 06:59 PM
  5. XL Pivot Tables
    By in forum PressF1
    Replies: 0
    Last Post: 30-01-2001, 09: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
  •