how to drop a table using shell script

swapna sree · 08-11-2011, 12:01 AM

Hi team,

Am inserting the data into a new table ,the data is coming from Select statement.
like

select col1,col2,col3
into tempdb..tableNew
from tempdb..tableSource
where col1 = 2

so before inserting into tableNew,it should drop the table if exists in tempdb

am using drop table tempdb..tableNew but its of no use in shell script but if i run the same in Database its droping the table

Can anyone help me on this.

Regards
Swapna

sieira · 08-11-2011, 05:31 AM

I don't understand what you mean, I wonder if you're trying something like this:

Code:

#!/bin/bash
mysql -e select col1,col2,col3 
into tempdb..tableNew
from tempdb..tableSource
where col1 = 2

Could you be more specific, please?

What database engine are you using
How are you building you script
How do you run your drop table statement, both whan you do it from the engine, and from the script

swapna sree · 08-12-2011, 05:54 AM

hey i got it..

if exists (select * from sysobjects where type='U' and name=' tableNew')
drop table tableNew
go

select col1,col2,col3
into tempdb..tableNew
from tempdb..tableSource
where col1 = 2