select statement
How to Create Updateable Views in MySql
Views are not only read-only but also can be updaeable. However to create an updateable view, the SELECT statement which defines view has to follow serveral rules as follow: SELECT statement must not reference to more than one table. It means it must not contain more than one table in FROM clause, other tables in [...]
How to Count Number of Records in a Database Table in MySql
In order to count a number of records in a database table we can use standard SQL COUNT function. The syntax is quite simple as follows: SELECT COUNT(*) AS total_founds FROM table_name The query will return the total record of the table. We can use WHERE clause in SELECT statement to filter records in the [...]
How to speed up your website with phpCache
Caching seems to be the new trend. But aside from all the marketing, it’s really a lot more than that. If you don’t have the money to buy those lovely Zend products, you might find yourself turning to the world of Open Source (again). And viola! You’ll be helped. There are two ways to cache [...]