How 'if not exists' implemented in MySQL?

2004-01-08 Thread Bing Du
Greetings, We're trying to migrate an application from MS SQL Sever 2000 to MySQL 5.0. Choosing version 5.0 of MySQL is because its support of stored procedure is needed. We have a stored procedure doing something as shown below on the MS SQL Server 2000: IF NOT EXISTS (SELECT statement)

Re: How 'if not exists' implemented in MySQL?

2004-01-08 Thread robert_rowe
First, please be aware that MySQL 5.0 is an alpha release. It is very young and there may still be some unresolved issues. It is not generally recommended to use alpha releases in production situations. Besides, anything that can be done in a stored procedure can be implemented in client side

Re: How 'if not exists' implemented in MySQL?

2004-01-08 Thread Bing Du
Thanks a bunch for your instance responce. Right now, I'm just testing the stored procedure feature of MySQL 5.0. If that works, we'll see next if the timetable for MySQL 5.0 go production can meet our own timetable. 'Select Into' was also what I figured. Just wanted to see if MySQL has

Re: How 'if not exists' implemented in MySQL?

2004-01-08 Thread robert_rowe
Stored procedures are MySQL are real new so I don't have much experience with them yet. The manual does seem to include some good info but I haven't delved too deeply. MaxDB is actually a separate DB. It is a re-brand of SAP DB. You might look for SAP DB info. It would probably apply to MaxDB.