Create new table from another table

Answered

It keeps showing error when I try to create a new table from my extraction

Because I want to combine the function of scheduling and query creationn I think I would not prioritize UI generation by right click

So how could i create a new table in my query? As sentences from "select" to ";" works very well

useless riding of the brackets

0
3 comments

Hi Wang Ye,

I guess you were referring to a statement having the following structure:

SELECT *
INTO new_table_name
FROM existing_table_name;

What database do you have, and which SQL dialect you're using in your example?

0

Tried it. Good! Thank you! u guys r amazingly helpful!

0

Every time. 

And promptly

Thank you guys!

0

Please sign in to leave a comment.