(Charles Babcock) MySQL, the supplier of the open source database with the same name, this week started shipping a new enterprise version of its MySQL Server 5.0 database that eases the workload of database administrators. The new version comes with an expert advisory service built in, as well as mo

One of the least commonly used of the MySQL datatypes has to be the SET datatype. The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET datatype can hold any number of strings from a predefined list of strin

(Melonfire) Any database programmer will tell you that in high-traffic database-driven applications, a single badly-designed SQL query can significantly impact the overall performance of your application. Not only does such a query consume more database time than it ideally should, but it can have a

(Sean Michael Kerner) In an interesting twist of irony, Oracle, which is taking aim at Linux leader Red Hat for being too expensive, is being undercut with an open source challenge to its namesake database.

(Barbara Darrow) MySQL’s new enterprise-class support option, including a new network monitoring dashboard, is now available, the company said.

(Peter Harvey) MySQL offers one of the most complete selection of application programmer interface support. Some of these are in the form of a library (such as the MySQL C API library) while others are in the form of a driver (such as the ODBC driver). For most people/situations – the choice of whic

(Peter Zaitsev) One think I can see with people using EXPLAIN is trusting it too much, ie assuming if number of rows is reported by EXPLAIN is large query must be inefficient. It may not be the case.

(Matthew R. King) The MyODBC Driver will not automatically create Insert, Delete, or Update statements for the Table Adapters. If you wish to alter the database from a Visual Basic application, you will have to create these statements yourself.

(Anil Mahadev) In this tutorial, I will dive into the nitty gritties of MYSQL 5 Application Development using the MYSQL Connector for .NET for Visual Studio.NET 2005 and build a simple Database Application using VC# and MYSQL 5. (pdf)

(Matthew R. King) The DataSet will appear in the Solution Explorer. Right-click on it and select View Designer.