Home » SQL / MySQL Tips and Tutorials

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: LOAD DATA LOCAL INFILE only imports 1 or 2 rows?

by Yang Yang on February 7, 2012

MySQL Performance Tips

by Yang Yang on March 12, 2011

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

by Yang Yang on March 5, 2011

MySQL: Find non-ASCII characters in a table column

by Yang Yang on March 2, 2011

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

by Yang Yang on February 17, 2011

MySQL: Export Table to CSV Text Files for Excel

by Yang Yang on November 18, 2010

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

by Yang Yang on October 25, 2010

MySQL: Change Default Character Set or Default Collation in phpMyAdmin

by Yang Yang on October 16, 2010

MySQL: Check if a table exists

by Yang Yang on July 30, 2010

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

by Yang Yang on July 9, 2010

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

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

by Yang Yang on February 10, 2010

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

by Yang Yang on September 5, 2009

MySQL: Select and Show all MySQL Users

by Yang Yang on September 3, 2009

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

by Yang Yang on September 2, 2009

← Previous Entries

1234