On Mon, 29 Sep 2003 12:30:28 +0200 "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> It seems Victoria didn't understand the real problem: > > I think that query should be stopped as soon as the table exists. > But if it doesn't exist, the query should create it and insert some records. > The problem is: WHY is MySQL trying to insert records while the table > exists? It should only insert records after creating the table (and table > will be created only when t doesn't exist already). I don't think you're right. The main aim of this query is to INSERT data into table. And before this it checks if the table already exists and creates it if not. So, there is no problem imho. > So, in that query, will the IF condition apply for table creation only? Yes. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
