General

All other little handy tips that can’t really fit in any specific category

Photography

Photography technique, tutorials and equipment review.

Computers

Tips, tutorials and solutions for Windows, Macs, Linux, Servers and Media Centers. Get the very most out of your computer. Resources for all levels from newbies and techies.

Web Design and Development

Tools, tech tips and tutorials for web design and development. Including wordpress plugins and tweaks.

Tools and Productivity

Software, web applications, scripts and tools to make your computing, design, development or networking experience more easier, enjoyable and productive.

Home » Archive by Tags

Articles tagged with: Postgres

SQL: Difference between DELETE and TRUNCATE

One of the questions I got asked today is what the difference is between the SQL commands DELETE and TRUNCATE. So here we’re looking at the differences between DELETE and TRUNCATE.

Postgres/MySQL – How to Show A Specific Range of Rows

postgres-logo

In Postgres and MySQL database, there is a neat functionality which returns results from a specific range of rows. This is done using LIMIT and OFFSET. The examples in this article demonstrate how they work.

css.php