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 up on a database after obviously a coding error in the saving of
the database. Each of the record in each field has contracted the disease...
When running: INSERT INTO customers3 (firstname) select TRIM(trailing
char(10) FROM firstname) FROM customers where id>1219; everything works
according to plan but when running: INSERT INTO customers3
(lastname,firstname) SELECT trim(trailing char(10) FROM firstname FROM
customers where id>1219, trim(trailing char(10) FROM lastname FROM customers
where id>1219; I am getting an 1064 error
I tried a SELECT trim(trailing char(10) FROM (lastname,firstname) FROM
customers where id>1219; I am also getting an 1064 error.
Any help or pointing into a direction would be greatly appreciated.
Philippe
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
