Structures in c – basics

Structures in c are used to represent data what have connections to each other in a single variable. This could be a record from a database. Structures can be declared outside the functions to give access for all the function in the program. Other options for...

C programming – where to start

I think to have a decent understanding of c, or start learning c programming  is really good even if somebody is not planning to work with the language itself. Most of the languages are based on c or are in some way related to it. Most of the currently used popular...

C typedef basics

If c is not your first language, you will really miss boolean primitive type. In other languages boolean is already defined, but in c there is no such type, it is actually using integer values instead. It is really simple to implement a boolean value with typedef:...

C primitive data types

In the C programming language variables are declared before the program itself starts, before functionality. This applies to functions also. With an example: main(){ int iCnt = 0; int iValue = myFunc(); }//end main int myFunc(){ return 1; }//end myFunc The following...

MySql function – how to create functions

Custom function in MySQL comes handy if we have some sort of calculation what to make, in order to get a value what can be stored. This implies that we want to push some logic into the database which is not a to popular idea among engineers. A function always gives...

MySql join – the basics

In a relational database with high level of normalization the data is stored in multiple tables. To retrieve the data from many tables joins can be used to connect data from multiple tables or itself(self join). Joins nowadays are considered to be a slow operation,...