SQL SELECT

The SQL SELECT statement allows you to retrieve records from one or more tables in your SQL database. For SQL SELECT statements can be used with WHERE clauses and also using relationship by joining tables. The result is stored in a result table, called the result-set.

Continue reading

SQL DELETE

SQL DELETE statement allows you to delete a single record or multiple records from a table or an entire records in a table. The syntax for the SQL DELETE statement is:

Continue reading

SQL UPDATE

The SQL UPDATE Query is used to modify the existing records in a table. You can use WHERE clause with UPDATE query to update selected rows otherwise all the rows would be effected.

Continue reading

Regenerate thumbnail sizes in wordpress after changing thumbnail sizes

Allows you to regenerate your thumbnails after changing the thumbnail sizes. Regenerate Thumbnails allows you to regenerate the thumbnails for your image attachments. This is very handy if you’ve changed any of your thumbnail dimensions (via Settings -> Media) after previously uploading images or have changed to a theme with different featured post image dimensions.

Continue reading