Debug queries with mytop
mytop is an mysql tool written in Perl to look at the database queries during runtime. This is how to debug queries with mytop. Installation apt-get install mytop Usage mytop -u USERNAME -pPASSWORD -d DATABASE
Tag: MySQL
Create UTF-8 Database
To create a UTF-8 Database: CREATE DATABASE my_very_nice_db DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci; For external access, have a look at MySQL – external Access.
Conditions
There are conditional commands for MySQL too. IF/ELSE SELECT FieldA as A, FieldB as B, IF(FieldA = FieldB, ‘equal’, ‘not equal’) as condition, FROM table WHERE this LIKE that Or cascaded: SELECT FieldA as A, FieldB as B, IF(FieldA = FieldB,’FieldA is equal to FieldB’,IF(FieldC = FieldD,’FieldC is equal to FieldD’,’all false’)) as output, FROM […]