MySQL Articles

• Less queries with INSERT ... ON DUPLICATE KEY UPDATE

  Let's see how to optimize queries of our applications through the use of ON DUPLICATE KEY clause.

• Duplicate / Copy a record in MySQL

  Thanks to sitassi INSERT ... MySQL SELECT statement you can make copies of records in a simple and fast.

• Reset the MySQL root user password

  By accessing the root of the server you can re-set the root password of MySQL, even if we have forgotten. Let's see how.

• Delete those tables using JOIN

  Delete data from multiple tables at once in MySQL, SQL JOIN statement through.

• Regular Expressions in MySQL query

  Handling of regular expressions in MySQL database to simplify the work, working the strings upstream.

• Updating tables using JOIN

  Update multiple tables at once in MySQL, SQL JOIN statement through.

• Create subprogrammi in MySQL

  Creating subprogrammi in MySQL, Stored Procedures, and through the interface with other programming languages.

• Difference between MyISAM and InnoDB tables

  Technical article explaining the differences between MyISAM and InnoDB table types of MySQL.

• Full Text Search with MySQL

  How to perform full text searches in MySQL, in order to obtain results indexed by various criteria, such as the real search engines.

• MySQL and copies of data security

  Everything you need to know about MySQL backup systems, both Windows and Linux, to make backup copies of data.

• <<
• 1
• 2
• >>