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

Showing: 1-10 of 62    »»
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: 340 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: 408 Comments: 0
document Where can I find documentation for MySQL Triggers?
In the MySQL Reference Manual:
03 Aug, 2009 Views: 459 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: 410 Comments: 0
document Do SPs have Exception Handling?
MySQL implements HANDLER definitions according to the SQL standard. See for details.
03 Aug, 2009 Views: 397 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: 365 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: 353 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...
07 Sep, 2007 Views: 1859 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: 463 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: 552 Comments: 0



RSS