Re: "'" in SQL INSERT statement

Поиск
Список
Период
Сортировка
От Alessio Bragadini
Тема Re: "'" in SQL INSERT statement
Дата
Msg-id 3A700060.3FD31A6D@albourne.com
обсуждение исходный текст
Ответ на "'" in SQL INSERT statement  (Markus Wagner <wagner@imsd.uni-mainz.de>)
Ответы Re: "'" in SQL INSERT statement
Список pgsql-sql
Markus Wagner wrote:

> I have some data that I wish to transfer into a database using perl/DBI.

If you use Perl DBI you should issue statements like
$dbh->do ('INSERT INTO table (field1, field2) VALUES (?,?)',undef, $value1, $value2);

This binding takes care of quoting and escapes all characters that may
cause problems in the database backed (e.g. "that's" becomes "that''s"
etc.)

There is a DBI mailing list where you can find more info and support:
see <http://www.isc.org/dbi-lists.html>

-- 
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-2-755750

"It is more complicated than you think"    -- The Eighth Networking Truth from RFC 1925


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: "'" in SQL INSERT statement
Следующее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: "'" in SQL INSERT statement