Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us

Showing: 1-10 of 61    »»
Articles
 
document Where i can find data sets?
www.OpenSourceDB.org is a site where you can find data sets for very low price or free,  available data sets are 1. BIN (Bank Identification...
03 Aug, 2009 Views: 185 Comments: 0
document 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...
03 Aug, 2009 Views: 331 Comments: 0
document Where can I find documentation for MySQL Triggers?
In the MySQL Reference Manual:
03 Aug, 2009 Views: 383 Comments: 0
document 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.
03 Aug, 2009 Views: 333 Comments: 0
document Do SPs have Exception Handling?
MySQL implements HANDLER definitions according to the SQL standard. See for details.
03 Aug, 2009 Views: 322 Comments: 0
document 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...
03 Aug, 2009 Views: 288 Comments: 0
document 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...
03 Aug, 2009 Views: 285 Comments: 0
document 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...
06 Sep, 2007 Views: 1673 Comments: 0
document 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...
03 Aug, 2009 Views: 360 Comments: 0
document 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...
03 Aug, 2009 Views: 413 Comments: 0



RSS