Search Results

We have found 11 items matching your search.
fallback-no-image-991

How to easily install a local MySQL/PHP server

  • 531 user views 0 reviews

An easy way to develop PHP and MySQL apps locally. How to set up a local apache server with a couple of clicks.

fallback-no-image-1432

MySQL left join

  • 424 user views 0 reviews

In this page we have discussed an advanced usage of MySQL LEFT JOIN.

fallback-no-image-6160

How To: Reset a WordPress user Password using phpMyAdmin or MySQ

  • 435 user views 0 reviews

Reset a users password on Wordpress using database tools

fallback-no-image-8012

SQL Functions - Math Functions

  • 514 user views 0 reviews

Just like how programming languages have functions built-in to allow you to do common tasks easily. So does SQL. A lot of these functions are mathematical. Some of them are more useful than others.

fallback-no-image-8013

SQL Date Functions - Converting and Using

  • 487 user views 0 reviews

SQL provides a lot of functions for manipulating dates in a database. You can store values in a date field or a datetime field. If you store the dates as unix_timestamps you can get a lot more flexibi

fallback-no-image-8225

MySQL DROP DATABASE Recovery

  • 712 user views 0 reviews

Is it possible to recover data destroyed by unintentionaly confirmed DROP DATABASE command? This tutorial answers this question and offers step-by-step procedure how to do it, if possible.

fallback-no-image-8226

Optimizing MySQL: Performance Tuning Script

  • 626 user views 0 reviews

Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server variables. It’s easy

fallback-no-image-8227

Optimizing MySQL: Importance of JOIN Order

  • 400 user views 0 reviews

This third part of MySQL optimizing tutorial mini series shows an importance of table order during JOIN. The difference between regular JOIN and optimized one is dramatic, so keep reading!

fallback-no-image-8365

Optimizing MySQL: Configuration Directives

  • 443 user views 0 reviews

This is the first part of MySQL Optimization mini series. In this tutorial we will go thru the MySQL configuration directives which have an influence on its performance.

fallback-no-image-8366

Optimizing MySQL: Log Slow Queries

  • 554 user views 0 reviews

This tutorial is the second part of the MySQL Optimization mini series and introduces the Slow Query Log as well as describes its setup and output.

fallback-no-image-16725

MySQL FAQs - Introduction to SQL Date and Time Handling

  • 499 user views 0 reviews

MySQL FAQs - Introduction to SQL Date and Time Handling