MySQL: Multiple INSERTS syntax ...

2001-07-18 Thread Philippe L. Houze
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

Re: MySQL: Multiple INSERTS syntax ...

2001-07-18 Thread Allen Grace
- 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