Hi,
I found syntax for INSERT command in both Paul DuBois excellent book and
online manual but for single insert. And it works... which for a newbie like
me is thrilling. But, I am stuck for multiple inserts.
I am trying to remove from a database trailing characters (ascii 10) that
have shown
- Original Message -
From: Philippe L. Houze [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 8:09 AM
Subject: MySQL: Multiple INSERTS syntax ...
When running: INSERT INTO customers3 (firstname) select TRIM(trailing
char(10) FROM firstname) FROM customers where