the semi colon...("the one way run")

Get help on databases - MySQL, Oracle, Access, etc.
Post Reply
Registered User
Posts: 5
Joined: 07 Jan 2010, 10:47

the semi colon...("the one way run")

Post by pilgrim007 »

How does one enclose semi colons on the SQL coding like this.

set option escape_character='on'

load table blablaba(
[Car_id] '|',
[Money] '|',
[IDTitle_IA] '\x0d\x0a')
from '/shared/data.txt'
escapes off
quotes off
on file error rollback
skip 1
set option escape_character='off'

(just to let u know that I do create a table before I do this...)

I have a list of SQL statement with semi colons (i.e. ;) and so I just want to run all the scripts in go...
Post Reply