db2 escape single quote

When the shell script executes, the shell interprets the lines in the script and executes them;For some specially processed sentences, we can use quotation marks or backslashes to prevent the shell from interpreting the execution.As below, when you

1. If it is single quotes, the following error appears: DB2 INSERT into sales (region) values (') db21034e This command is treated as SQL Statement because it is not a valid command line Processor command. During SQL processing, it returns:

Import Database: load data infile 'd:/test.txt 'into table nmg fields terminated by', 'Lines terminated by' \ r \ n ';13.2.5. load data infile syntax load data [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE'File_name. Txt '[REPLACE | IGNORE] INTO

The DB2 like predicate query statement supports the use of percent sign (%), underscore (_), does not support square brackets ([]) (note: It treats square brackets as actual values rather than wildcards), and when we need to query for the percent

The LOAD DATA infile statement reads from a text file into a table at a high speed. If you specify a local keyword, read the file from the client host. If local is not specified, the file must be located on the server. (Local is available in MySQL3.2

Load data [low_priority] [local] infile 'file_name.txt '[Replace | ignore] into Table tbl_name[Fields[Terminated by '\ T'][Optionally] enclosed by ''][Escaped by '\'][Lines terminated by '\ n'][Ignore number lines][(Col_name,...)] Load daThe TA

Http://blog.csdn.net/adparking/article/details/7098221 Load data [low_priority] [local] infile 'file_name.txt '[Replace | ignore] Into Table tbl_name[Fields[Terminated by '\ T'][Optionally] enclosed by ''][Escaped by '\'][Lines terminated by '\

LOAD DATA [Low_priority | CONCURRENT] [LOCAL] INFILE ' file_name.txt '[REPLACE | IGNORE]Into TABLE tbl_name[Fields[TERMINATED by ' string '][[optionally] enclosed by ' char '][Escaped by ' char ']][LINES[Starting by ' string '][TERMINATED by '

The load data infile statement reads a table from a text file at a high speed. If you specify the local keyword, read the file from the client host. If local is not specified, the file must be on the server. (Local is available in MySQL 3.22.6 or a

Use bitsCN.com for mysqlloaddatainfile Load data [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] Into table tbl_name [FIELDS [Terminated by 'string'] [[OPTIONALLY] enclosed by 'char '] [Escaped by 'char