Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Temporary Table...Select

Status
Not open for further replies.
lwinsor

lwinsor

MIS
Sep 22, 1999
4
0
0
CA
I am fairly experienced with MySQL, but I cannot get the CREATE TEMPORARY TABLE syntax to work.

I want to put a SELECT query into a temporary table so I can run a bunch of other queries against it, but I can't figure out the syntax. I'm trying with a single field test table, and it's still not working.

I'm using version 3.22.21

Thanks.

 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
134
lupidol
lupidol
Gerrit Broekhuis
  • Locked
  • Question
create connection by code
Replies
2
Views
96
Gerrit Broekhuis
Gerrit Broekhuis
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
152
spamjim
spamjim
jyothi12389
  • Locked
  • Question
create a schedule and MYSQL loading csv data to table
Replies
0
Views
41
jyothi12389
jyothi12389
TheLazyPig
  • Locked
  • Question
Create Stored Function in phpmyadmin 1
Replies
2
Views
71
TheLazyPig
TheLazyPig

Part and Inventory Search

Sponsor

Back
Top