PHP, HTML, CSS, JQUERY, MYSQL Tutorials

999Tutorials.com – Your Tutorial Spot

Entries for the ‘Mysql’ Category

Optimize MySQL tables simple

Just like you need to defrag and check your file system, it’s important to do the same thing with MySQL tables. If you don’t, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.
Speed in MySQL is all about how fast the [...]

Sub queries

Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don’t need to do that much programming in PHP, just let mysql do the work
A new thing in MySql 5 is the possibility to use something called “sql subqueries”. It can be a very powerful new tool [...]

Basic sql optimization for MySql

It’s important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how…
When you start getting large tables you can sometimes end up with slow running queries.
It’s important to optimize your [...]

Schedule scripts to run

Schedule your daily work like checking logfiles, cleaning up old data in your web systems. Let automated scripts take care of this, learn how to use “Cronjob” for this.
We developed a site where the visitors can sell their used stuff. The add process is made up by three steps, and for some reason some people [...]