MySQL is not a commercial grade database.
It lacks:
Stored procedures
Real transactions
ACID properties
Outer joins
Online backups facility
Adequate performance
Support for constraints
A professional telephone support hotline
Selecting from DUAL
ADO connector
Subqueries
Support fro GROUP BY
...
I'd prefer any other database over Mysql. Even Microsoft SQL Server is better than MySQL. Anybody who'd run MySQL in a production setting should be fired on the spot, then drawn and quartered
No. It is still lacking the following important features:
- Stored procedures
- Real transactions
- ACID properties
- Outer joins
- Online backups facility
- Adequate performance
- Support for constraints
- A professional telephone support hotline
- Selecting from DUAL
- ADO connector
- Subqueries
- Support fro GROUP BY
- ...
If you are looking for a commercial grade database, try this one instead!Keep on waiting. These are not real subqueries. Stuff such as SELECT name FROM TABLE_1 WHERE id IN (SELECT eligible FROM TABLE_2) still does not work.
Or, if you don't want to wait, use a professional commercial database
The stored procedures are not real either, just check this link on MySQL's own site!
- Stored procedures
- Real transactions
- ACID properties
- Outer joins
- Online backups facility
- Adequate performance
- Support for constraints
- A professional telephone support hotline
- Selecting from DUAL
- ADO connector
- Subqueries
- Support fro GROUP BY
- ...
I'd prefer any other database over Mysql. Even Microsoft SQL Server is better than MySQL. Anybody who'd run MySQL in a production setting should be fired on the spot, then drawn and quartered