31.12.2014, 12:06
- Depends on the query.
- No, more.
- No. Most people use phpMyAdmin but there are stand-alone tools like MySQL Workbench.
---
On another note, I would very much like to see better internal handling of NULL values. If a NULL value appears in a non-string column and you try to retrieve it with the _int or _float functions you will get errors. Maybe add another optional parameter to cache_get_row_int and cache_get_row_float that allows the user to specify a default value should the field be NULL.
I know you can use IFNULL in the query to circumvent the problem, but if you have a lot of fields that can be NULL then it can significantly lengthen the query. Especially if you also want to add an alias for use with the cache_get_field_content functions.