SQL / MySQL Tips and Tutorials

SQL is the designing and programming language of relational databases. Open source, MySQL is the most successful database system in the world. It’s widely used across the web world that majority of the websites out there are backed by it. It has many utilities as well.


MySQL Performance Tips

by Yang Yang on March 12, 2011

in SQL / MySQL Tips and Tutorials

MySQL: Get the exact size of a database by SQL query

by Yang Yang on March 5, 2011

in SQL / MySQL Tips and Tutorials

MySQL: Find non-ASCII characters in a table column

by Yang Yang on March 2, 2011

in SQL / MySQL Tips and Tutorials

MySQL: How to export a database / table to XML?

by Yang Yang on February 17, 2011

in SQL / MySQL Tips and Tutorials

MySQL: Export Table to CSV Text Files for Excel

by Yang Yang on November 18, 2010

in SQL / MySQL Tips and Tutorials

MySQL log files are taking a lot of disk space – How to disable and delete them?

by Yang Yang on October 25, 2010

in SQL / MySQL Tips and Tutorials

MySQL: Change Default Character Set or Default Collation in phpMyAdmin

by Yang Yang on October 16, 2010

in SQL / MySQL Tips and Tutorials

MySQL: Check if a table exists

by Yang Yang on July 30, 2010

in SQL / MySQL Tips and Tutorials

MySQL logic operators: How to use AND, OR together in WHERE clauses in one query?

by Yang Yang on July 9, 2010

in SQL / MySQL Tips and Tutorials

How to bring down / optimize memory usage in your unmanaged Linux VPS box and avoid OOM (Out Of Memory) errors?

by Yang Yang on July 1, 2010

in Apache Web Server Tutorials & Tips, PHP Tips & Tutorials, SQL / MySQL Tips and Tutorials

A few database security tips – things to do to effectively protect MySQL databases

by Yang Yang on February 10, 2010

in Information Security, SQL / MySQL Tips and Tutorials

MySQL: How to backup ALL databases as root with mysqldump at once?

by Yang Yang on September 5, 2009

in Hosting Tips & Deals, SQL / MySQL Tips and Tutorials

MySQL: Select and Show all MySQL Users

by Yang Yang on September 3, 2009

in SQL / MySQL Tips and Tutorials

MySQL: How to change or convert MyISAM to InnoDB or vice versa?

by Yang Yang on September 2, 2009

in SQL / MySQL Tips and Tutorials

MySQL Engines: InnoDB vs. MyISAM – A Comparison of Pros and Cons

by Yang Yang on September 2, 2009

in SQL / MySQL Tips and Tutorials

← Previous Entries

1234