|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
 |
|
Showing: 1-10 of 56 »»
Articles
|
|||||
 |
How do you migrate from MySQL 4.x to 5.0?
Detailed upgrade information for each version can be found at . We recommend that you do not skip a major version when upgrading, but rather upgrade...
|
||||
|
|||||
|
Where can I find documentation for MySQL Triggers?
In the MySQL Reference Manual:
|
||||
|
|||||
|
Do SPs have a "raise" statement to "raise application errors"?
Sorry, not at present. The SQL standard SIGNAL and RESIGNAL statements are on the TODO.
|
||||
|
|||||
|
Do SPs have Exception Handling?
MySQL implements HANDLER definitions according to the SQL standard. See for details.
|
||||
|
|||||
|
Can SPs return result sets (as do MS SQL and Sybase)?
Yes. If you do an ordinary SELECT inside a stored procedure or function, the result set is returned directly to the client. You will need to use the...
|
||||
|
|||||
|
Is the mode dependent on the Database or the Connection?
A mode is not 'linked' to a particular database. Modes can be set locally to the session (connection), or globally for the server With SET...
|
||||
|
|||||
|
What are the new Storage Engines in MySQL 5.0?
The FEDERATED storage engine, new in MySQL 5.0, allows the server to access tables in other (remote) servers. See
MySQL 4.1 already...
|
||||
|
|||||
|
How does PostgreSQL compare to other DBMSs?
There are several ways of measuring software: features, performance, reliability, support, and price.
Features PostgreSQL has most features present...
|
||||
|
|||||
|
Does MySQL 5.0 have Sequences?
No. However, MySQL has an AUTO_INCREMENT system, which in MySQL 5.0 can also handle inserts in a multi-master replication setup. With the...
|
||||
|
|||||
|
Is there a "MyISAM Hot-Backup" like the "InnoDB Hot-Backup"?
This is currently under development, and scheduled for MySQL 5.1.
|
||||
|
|||||
Powered by
DBNest.com (Nest of DB Professionals)