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 Engines: InnoDB vs. MyISAM – A Comparison of Pros and Cons

by Yang Yang on September 2, 2009

What are New Line Feed and Carriage Return in a MySQL query?

by Yang Yang on August 3, 2009

MySQL: Count the Number of Records and Update the Stats Field in Another Table

by Yang Yang on August 1, 2009

Instantly Boost SQL Query Efficiency of REGEXP or RLIKE by 2000%

by Yang Yang on July 23, 2009

mysql command line character set option for importing SQL files encoded in UTF8

by Yang Yang on July 16, 2009

How to Recover or Reset MySQL root Password after You Forgot and Lost It

by Yang Yang on June 20, 2009

Best MySQL Books to Learn MySQL Database Programming and Development (+ PHP Applications)

by Yang Yang on June 17, 2009

How to Transfer / Move WordPress Blog from One Domain to Another

by Yang Yang on June 15, 2009

MySQL: String Function to Replace Substring and Change Part of the Field Value

by Yang Yang on June 14, 2009

PHP, MySQL: Calculate Number of Days between 2 Dates or Number of Hours, Minutes and Seconds

by Yang Yang on June 13, 2009

MySQL, PHP: Display MySQL table fields and data

by Yang Yang on June 6, 2009

MySQL, PHP: Store form textarea value or data to MySQL database table

by Yang Yang on June 6, 2009

MySQL: Find Duplicate Entry / Rows / Records

by Yang Yang on May 19, 2009

MySQL: Huge Table Not Responding after Adding Index

by Yang Yang on May 18, 2009

MySQL: Counting Number of Records or Rows by a Foreign Column (from Another Table)

by Yang Yang on May 17, 2009

← Previous Entries

Next Entries →

1234