MySQL – change table & database encoding to utf8
For table, we could use ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; For database, we could use ALTER DATABASE database_name charset=utf8;
Read More →Problems connecting to unix:///var/mysql/mysql.sock
In MAC, when using ‘localhost’ to connect the mysql. I get this error. The solution is to modify /etc/php.ini find the word /var/mysql/mysql.socket and modify it to /tmp/mysql.socket 🙂
Read More →font name – how to get the font name from ttf
ttf is the abbreviation of true type font. If we would like to specify some font to be used in QT app, we have to use QFont to specify the font by the font name. So the question is, how could we get the font name from ttf file. We could use the fop-ttfreader utility […]
Read More →MySQL – copy record in the same table
The steps would be copy the record to temp table modify the column you would like to copy back to the original table CREATE TEMPORARY TABLE tmp SELECT * FROM table_1 WHERE column_1 = 111;Â UPDATE tmp SET column_1 =1 WHERE column_1 = 111;Â INSERT INTO table_1 SELECT * FROM tmp WHERE column_1 = 1;
Read More →