Tagged: database

setup learn sql mac

Dynamic pivot tables (transform rows to columns)

A pivot table in MySQL with dynamic headers. Assume we have a table of properties – ‘properties’ (script for its creation is provided below), and we need to do data transformation for the report....


Extract one table from mysqldump backup file

Starting from the difficulties I experienced, when I wanted to retrieve a table from a large mysqldump backup file… which was around 500mb and above, while the conventional method was too time-consuming even though...

fabrik logo 0

Fabrik Joomla Component : Cheet Sheet Sample Code

Fabrik is one of the components in the Joomla CMS, the usefulness of the Fabrik component is a tool to easily create web applications. With Fabrik it is very easy to create forms and...