Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 11 to 11 of 11 total
Insert into..
Fri, Jul 6 2018 2:42 PM
Permanent Link
Tim Young [Elevate Software]
Elevate Software, Inc.
timyoung@elevatesoft.com
Ian,
<< But, unless I am missunderstanding, currently, the temporary table has to have already been created to
insert into, I was hoping to have it automatically be created based on the insert and source table. >>
In that case, you should use this instead:
CREATE TEMPORARY TABLE MyTable
(LIKE MyOtherTable);
INSERT INTO...
or do like Roy suggests and use CREATE TEMPORARY TABLE MyTable AS SELECT...
Tim Young
Elevate Software
www.elevatesoft.com
«
Previous Page
Page 2 of 2
Jump to Page:
1
2