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!

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

vb/mysql temporary table

Status
Not open for further replies.

bxgirl

Programmer
Nov 21, 2005
75
US
Can I do this in VB6 using mySQL 4?
create temporary table within VB using conn.Execute then joining the temp table to a permanent table.
 
You could use a "Create Table" query to create the table and then a "Insert Into" to fill the permanent table. Then drop the temporary table.

 
Thank you.

create table actually creates a table but what about create temporary table...will that work?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top