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)
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
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
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.