MySQL Temporary Table

Programming in MySQL – Part 9

MySQL Course

Foreword: In this part of the series, I talk about MySQL temporary table.

By: Chrysanthus Date Published: 27 May 2015

Introduction

This is part 9 of my series, Programming in MySQL. In this part of the series, I talk about MySQL temporary table. You should have read the previous parts of the series before reaching here, as this is a continuation.

Temporary Table and Connection
A temporary table in MySQL is a table that exists as long as the connection is on. When a connection is dropped, the temporary table ceases to exist. The user who is connected is the one to use the temporary table.

In simple terms the syntax is:

CREATE TEMPORARY TABLE tbl_name
    (create_definition,...);

You can try the following:

CREATE TEMPORARY TABLE Women
(
    WomanID INTEGER NOT NULL AUTO_INCREMENT,
    Name CHAR(40),
    Address CHAR(40),
    City CHAR(40),
    State CHAR(40),
    Country CHAR(40),
    Phone CHAR(40),

    PRIMARY KEY (WomanID ASC)
);

You can now go on to insert values into the temporary table. You can try the following:

INSERT INTO Women (Name, Address, City, State, Country, Phone) VALUES ('Mary', '50 Up Street', 'Fine York', 'California', 'U.S.A', '5555555555');

You can go on to select what you have inserted into the temporary table. You can try,

SELECT * FROM Women;

The temporary table lasts as long as the connection lasts.

Well, let us end here for this tutorial. We continue in the next part of the series.

Chrys

Broad Network

Related Articles

MySQL Temporary Table

Programming in MySQL – Part 9

MySQL Course

Introduction

Related Links

Comments