zwwcn

Just another WordPress.com site

tempary table

A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. This means that two different connections can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.)

 

CREATE TEMPORARY TABLE TMP_BILL_ADDRESS(ADDRESS_ID bigint);

INSERT INTO TMP_BILL_ADDRESS(ADDRESS_ID)
SELECT a.OBJECT_ID FROM OP_ADDRESS a;

DROP TABLE TMP_BILL_ADDRESS;

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: