I was recently asked to help create multiple MySQL tables on a MySQL 4 server using a MySQL 5 client.

This post will show you how you can create multiple tables in multiple databases using our database of choice, MySQL.

Setup a shell script to execute the query. Assume that the first argument passed is the database, indicated by $db.

# CODE FOR synch_db.sh
db=$1;
mysql -uuser -ppass --host=192.168.0.1 -e 'CREATE TABLE IF NOT EXISTS '$db'.table_name ( id int(11) NOT NULL auto_increment, alias varchar(80) default NULL, tag varchar(80) default NULL, mapping int(1) default 0, PRIMARY KEY (id)) TYPE=MyISAM;'

mysql -uuser -ppass --host=192.168.0.1 -e 'CREATE TABLE IF NOT EXISTS '$db'.table_name2 ( id int(11) NOT NULL auto_increment, alias varchar(80) default NULL, tag varchar(80) default NULL, mapping int(1) default 0, PRIMARY KEY (id)) TYPE=MyISAM;'

…

Last week we released a new version of XAMPP for Linux providing the new MySQL 5 software. Today we also can announce a new version for Windows containing the new version of MySQL.

Also new in the Windows version of XAMPP: upgraded version of Apache (2.0.55), PHP (4.4.1), phpMyAdmin (2.6.4-pl3) and OpenSSL (0.9.8a).

Download XAMPP for Windows!

One more day until 7 November 2005, which is the deadline for submissions to the MySQL Users Conference 24-27 April 2006 themed “Discover. Connect. Succeed. Scale Your Business with MySQL.“. We have well over a hundred quality proposals already, and more are being submitted all the time. Tomorrow Monday is the last day!

More and more companies are discovering LAMP as an enterprise-grade, OpenSource stack to built mission-critical applications on it. Web development companies are developing LAMP applications for businesses like Disney, Deutsche Telekom, Sueddeutsche.de, Lufthansa and such. But what about a professional support with guaranteed response times up to 2 hours? That's where our PHP/LAMP support is targeted at, including support for databases like MySQL for example.

We provide support for enterprise companies that have their own development department, but need someone who is helping them if they experience problems while developing their application, including application management and monitoring. The support program is for an unlimited number of servers in your company.

If you are an ISV or SI with your own PHP developers, then this support is also for you: we …

MySQL success is due to not only to its efficiency, but also to its ease of administration.
And despite what its detractors say about lack of features (that was before
5.0, of course), there is a feature that is crucial for enterprise database
management, and MySQL has had it built-in since early version. I am talking
about data replication that can trasform a single server into a scalable and
highly reliable system with minimum effort and expense.

Recently, one more element was added to MySQL set of features. MySQL Cluster is an ambitious engine that turns your servers into a full fledged cluster that can be accessed from any node without worry. Any node is master and slaveat the same time. However, these features come at the price of some higherhardware requirement (MySQL Cluster is, as of today, an all-in-RAM database).

MySQL data transfer methodsThere are differences between these two …

Commented my.ini file

While at Devshed Forums I noticed the need for an example my.ini (or my.cnf) file with all available options set and proper comments.
Infact, while some commented examples are provided by MySQL AB and some others can be found on the net, I think that there is not an attempt to collect all available options into one file.
This is my try ... please note that this is work in progress!!

[client]
#under this section you?ll find all client parameters

#by setting this your mysql client (tipically the command line tool) will connect using this username as default
user=pippo3
#by setting this your mysql client (tipically the command line tool) will connect using this password as default
password=pippo3

#client will connect to server using this port as default
port=3306 …

Every now and then, people are puzzled by the precise status and extent of MySQL support for dynamic SQL.
Statement Handling
MySQL support the prepared statement syntax. For the better part, a prepared statement is much like a 'normal', immediate statement. The main difference is seen in the way the statement is processed by the server.
Immediate Statements
When an immediate statement is issued, it is processed directly. Processing comprises the following steps:

1. 
   
2. Parsing: lexical and syntactic analysis of the statement
   
3. Planning: optimizer devises a strategy to realise the required result or action, the execution plan or query plan
   
4. Execution: …

Late last year I bought a Dell Inspiron 9200 laptop for my work machine while on the road. It was a fine machine, plenty powerful to run all the tools I need to document MySQL.

The laptop came with a two-edged sword — the 1920×1200 WUXGA screen had awesome resolution, allowing one to work on so many windows at once it was practically like having dual monitors. The disadvantage was that the screen had a lowsy anti-glare coating that produced a sparkle effect when your viewing angle shifted, which can be read about with this Google search.

I first thought this was just the way the screen was and dealt with it, but it later became apparent that this screen was sub-standard compared to …

Every now and then, people are puzzled by the precise status and extent of MySQL support for dynamic SQL.
Statement Handling
MySQL support the prepared statement syntax. For the better part, a prepared statement is much like a 'normal', immediate statement. The main difference is seen in the way the statement is processed by the server.
Immediate Statements
When an immediate statement is issued, it is immediately processed. Processing comprises the following steps:

1. 
   
2. Parsing: lexical and syntactic analysis of the statement
   
3. Planning: optimizer devises a strategy to realise the required result or action, the execution plan or query plan
   
…