insert results of select from one table into another table.

#1

I want to create a new table containing only the results from a select statement of another table. How is that done?

select a, b, c into destTable from sourceTable where a='x';

Does one have to create the destTable or is it created for you with the correct structure?

#2

On 02/01/2012 01:14 PM, SpreadTooThin wrote:

Quote:

I want to create a new table containing only the results from a select statement of another table. How is that done?

select a, b, c into destTable from sourceTable where a='x';

Does one have to create the destTable or is it created for you with the correct structure?

The insert target must exist before you can even write the query.

#3

is there a way to use the describe table statement to create the new table?

#4

SpreadTooThin wrote on 01.02.2012 19:14:

Quote:

I want to create a new table containing only the results from a select statement of another table. How is that done?

select a, b, c into destTable from sourceTable where a='x';

Does one have to create the destTable or is it created for you with the correct structure?

create table destTable
select a,b,c,
from sourceTable
where a = 'x'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

insert results of select from one table into another table.

comp.databases.mysql comp.databases.mysql

insert results of select from one table into another table. - 02-01-2012 , 12:14 PM

Re: insert results of select from one table into another table. - 02-01-2012 , 12:27 PM

Re: insert results of select from one table into another table. - 02-01-2012 , 12:32 PM

Re: insert results of select from one table into another table. - 02-01-2012 , 12:54 PM