Group items matching

in title, tags, annotations or url

MySQL now has a new "database" named INFORMATION_SCHEMA. It is a virtual database only; there will never be a need to create a file by that name, and the MySQL server itself creates and populates the tables therein.

MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema".

Many of us do not realize that MySQL's Timestamp is not the timestamp which PHP date() understands. In fact if you try to use MySQL timestamp directly in php date() function then you will get totally wrong dates. There is a simple way to use MySQL timestamp data in php.

The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010. The new milestone release incorporates semi-synchronous replication in MySQL 5.5 based on patches to InnoDB developed by Google.

MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download.

MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.

Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.

Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.

MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". The long answer is the MySQL 5.0 New Features series, and this book is the third in that series.

Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:

This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously:

Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL.

Reporting Services is a Web service-based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain information from virtually any data source.

Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications.

After an extensive research we sorted out the top 7 Open Source Server based database management systems, have a look.

PostgreSQL performance optimization is a widely discussed issue on the most forums. Although PostgreSQL is shipped with a solid default configuration aimed to fit most setups, it requires fair amount of performance optimization to offer the best.

Whenever user wants to interact with Sql Server, he has to interact with Sql Server through Sql.

The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker.

While writing the Queries using in SQL Query Analyzer tool we need not to follow any particular case.Because SQL is case insensitive language.

In this post, we are going to explain how you can list all CONSTRAINT of database or table in SQl Server. When you are working on database sometimes you need to check or get the CONSTRAINT on database or table. Using below given query we can get the CONSTRAINT of table or database quickly.