Thanks for the suggestion, but its a tossup between that and the perl 8o(
I'll need to give it some thought about how much I want to port. MySQL is sure easier to install and also faster (I'm told anyway, without getting my data in I can't be sure).
best,
Campbell
At 04:22 PM 6/9/2003 -0400, Keith C. Ivey wrote:
On 9 Jun 2003 at 13:16, Campbell D. McCausland wrote:
> Thank you for your responses. Unfortunately, the sql > I'm loading is output from another tool, so I don't > get to vote on the format of the insert statements. > > If it's not possible to just turn the check off, then I > guess I'll have to consider writing a perl script or > something to add the column specifiers.
Another way would be to make a table with the old structure (without the new columns) and import into it, then do a SELECT ... INSERT from it into the real table, specifying the columns.
-- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org
--------------------------- BridgePoint UML ----------------------- Campbell D. McCausland Tel: (520) 544 2881 x21 Dir. Research and Development Fax: (520) 544 2912 Project Technology Inc 7400 N. Oracle Road, Suite 365 Tucson Arizona [EMAIL PROTECTED] 85704-6342 www.projtech.com USA -------------------- DesignPoint Model Compilers ------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
