On Mon, 29 Sep 2003 16:02:23 +0200 "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> For me, I think he may use two statements: > 1. Create the table if it does not exist. > 2. Insert data if that will not create duplicates. Yep, IMHO this is the only solution. > Another alternative is to first DROP that table and recreate it. But I think > the above 2 steps procedure will work. I suppose in this case Hassan should use DROP IF EXISTS and SELECT .. INSERT. > Unfortunately, I don't see a way to send these queries at once to the server > for execution. I don't think, that this queries should be sent at once (and there is no way to do it). They can be successfully executed one by one. --- 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]