SQL syntax with /*! c-style comments in MySQLdump
Kedar
In mysql we have — , /* and /*! comments. This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in…
Browsing Category
MySQL-Articles
76 posts
MySQL related blog posts
5 useful MySQL Command Options-pager-prompt-rehash-tee-system
There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command…
How to Load Delimited Data CSV Excel to MySQL
Loading CSV to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. I’ll…
MySQL Memory Usage Limits on 32 bit Linux
I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the…
Scheduled Backup MySQL Administrator & Windows Scheduler – Odd
Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4,…
Install 2 MySQL Server instances replication on Windows
At times you need to install multiple MySQL instances on same machine. This article is a brief step-by-step tutorial on the subject task which is divided into the following main…