database

Spatial Extensions is a set of data types and functions, helps easily (by not using geometrical mathematics) work with points in the map, polygons and distances and other units can be found in geographical maps. According to documentation [1] Spatial Extensions can be used as well in MyISAM as in InnoDB with a one note – InnoDB does not support spatial indexes. I have not checked if something is changed in the recent versions of MySql.

This time, I will make a closer look at mysql user variables. They can be divided into two main categories: defined variables, used in procedures and functions and undefined, also can be used in procedures and function, but also can be used in sql queries as in-line code.

Problem is as old as a world – how to get next ID value in MySQL assuming, AUTO_INCREMENT is in use. If ID value is needed after record is submitted and if ID value is needed before insertion is made.