List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 12 2002 3:01pm
Subject:Re: Sql Alter Table error handling
View as plain text  
In the last episode (Jun 12), leonardo klarmann porto said:
> HI,
> 	I would like to know how can i resume errors in a Alter Table sentence.
> 	I am doing a script that uses alter table to drop some columns of some
> tables in my converted access to mysql database.
> 	The problem is that if a column doesn┤t exists in a certain table, the
> script stops with a column/key doesn┤t exist error.
> 	How can i execute this script non stop? Is there a resume error sentence
> for that? Is there a handling error way to do that?

$ mysql --help | grep error
  -f, --force           Continue even if we get an sql error.

	Dan Nelson
Re: Tables in MySQLRob12 Jun