MySQL Community Server 5.1.37, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.37 is recommended for use on production systems.

MySQL Community Server 5.0.84, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.

This is a very useful script when you need drop all the objects in a schema.

Execution process in the DreamCoder for Oracle.

1. Open the script in the SQL Editor.
2. Open the SQL output
3. Execute the script with F9.

 

This is the top five of the most common errors during the connection process to MySQL database server.

1. 2003 Can't connect to MySQL server on.
2. Lost connection to MySQL server during query.
3. 1045 Access denied for user.
4. Host xxx is not allowed to connect to this MySQL.
5. MySQL server has gone away.

The most common error in mysql server is "Can't connect to MySQL server on 'localhost' (10061)", this happen when you attempt to connect to the MySQL database Server.

 One of the most frequent questions we are asked is; how to manipulate the XML Types for DreamCoder for Oracle. Before it was a complicated task to manipulate this type of field since DreamCoder only recognized XML types as a simple text field and only  enabled the edition option in the form view.

DreamCoder for Oracle  includes many changes, such as the way objects are described with the SQL and PL/SQL editor.  

The new DreamCoder for Oracle includes a new way to describe objects or alias when using the SQL and PL/SQL editor, just combine CTRL + CLICK on the object. The advantage of this new option is that the object opens in edition mode, therefore the programming process is quicker. If you are opening a method package, when opened the cursor will be pointing to the method.

One of the most common activities when working with MySQL is exporting and importing data, this article focuses on that while using DreamCoder for MySQL.