MySQL Point

Occasionally one has the problem, ordered read to have to correct text table content with what umlauts contains. But this is MySQL not as another possible without, as MySQL character set supported by default, the sort with umlauts not our natural understanding supported by . Eine bessere Beschreibung dieses Problems findet sich in der MySQL-FAQ [...]

In this tutorial, you will learn various ways to concatenate two or more string together by using concat function which is provided by MySQL. Almost RMDMSs support us to concatenate two or more strings together by using different implementations. MS SQL server us operator plus (+) to concatenate strings. Oracle only allows you to concatenate [...]

You can use UNION if you want to select rows one after the other from several tables, or several sets of rows from a single table all as a single result set. UNION is available as of MySQL 4.0.This section illustrates how to use it. Suppose you have two tables that list prospective and actual [...]

ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query. ANALYZE helps query optimizer to make accurate decisions by detailed analysis of the data, unlike query optimizer which makes quick analysis. The command [...]

Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL. Use mdbtools utilities as described below: mdb-tables displays the list of tables in MS Access mdb-scheme export the MS Access schema to MySQL database. The documentation doesn’t mention that MySQL is supported. You [...]

Suppose you want to change and enable the remote access to MySQL DB on your linux server (Debian). By default, you don’t get such privileges so you will have to work your way through this. I have a very simple article for you so that you can enable the remote access. This is a pretty [...]