Connection.MySQL (gb.mysql)

The goal of gb.mysql is to create MySQL specific routines and then send them to the gb.db to be executed.

For example, the Date DataType in Gambas represents a date and time value (06-08-1981 04:25:08), in MySQL the Date DataType represents only dates in a range from '1000-01-01' to '9999-12-31'.

One of the abilities of gb.db is to be “type independent” which means that if you create a database with some tables using gb.db, the component will be able to create it in any Database Manager supported by gb.db (i.e ODBC, sqlite, postgresql, etc). That is great, but if you have to create a specific database with specific datatypes in MySQL you should use the gb.mysql component.