2008/09/03

今天

早餐稍貴，但是吃得飽，因為起得晚，中餐就沒吃，晚餐吃了兩個麵包跟一個茶葉蛋。

早上 10 點多才起來，晚上應該可以 01:20 睡覺。

時間利用不錯，早上有利用時間聽英文。

在家練了一下啞鈴，早上聽了一點英文雜誌，沒唸日文。

沒唸 CS、Technique、課外書。

特別

今天去外交部領事事務局補交照片，然後去西門町晃了一下。喝到免費的飲料，還滿好喝的，可是我忘記它的名字了，沒辦法幫它打廣告 XD。

幸福

今天去社區大學聽課順利，老師有實力也很幽默(比較不尊敬的說法就是臉皮很厚、嘴巴很毒，可是又都很有道理，XD)。跟不同年齡層的人在一起真的很有趣，因為大家生活經驗都不同，各有不同的故事，常常會爆出一大堆的笑話。

對明天的期望

運動、唸書。

Comments

Setting MySQL to Use UTF-8 on MAMP (MySQL 5.5.9, or 5+)

I wanted to setup MySQL to use utf-8 on the MAMP installation on my Mac. I tried the instructions from this article: http://cameronyule.com/2008/07/configuring-mysql-to-use-utf-8/ However, I kept getting error messages that are similar to this one [ERROR] /Applications/MAMP/Library/bin/mysqld: unknown variable 'default-collation=utf8_general_ci' I did some search and realized that several variables are deprecated. Reference: http://dev.mysql.com/doc/refman/5.1/en/server-options.html Therefore, I added the following lines into /Applications/MAMP/conf/my.cnf [mysql] character-set-server=utf8 [client] character-set-server=utf8 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci init-connect='SET NAMES utf8' I restarted the server and mysql run successfully with relevant variables being set correctly. In the "Variables" tab under phpMyAdmin interface (ex. http://localhost:8888/MAMP/?language=English) character set c...

ngrok, a service to help you get a public URL for your local webserver

If you are looking for options to test your web app hosted on your own machine (e.g., laptop) remotely with someone, I recommend using a service called ngrok. https://ngrok.com/ It has many usages, but in the context of testing an app hosted on your own machine, the most important part is giving you a public URL that will redirect all the requests to your local webserver (e.g., Apache, Nginx, or whatever server you are running). You can give this URL to a testing participant without the need to host the app on a remote server. For instance, if you are testing your app using a sever on your machine, typically you can access your app in a URL like: http://localhost:3000/?study=11 Using ngrok, you will have a dynamically generated URL like the following: https://3ebe3c019867.ngrok.io/ The service will redirect requests to https://3ebe3c019867.ngrok.io to http://localhost:3000 You can then share the following link with your testing participant for the participant to use your app. http...

How to update multiple fields in an SQL update statement

Syntax: /* the correct way of putting multiple fields together, using comma */ UPDATE `stories` SET `content`='Once upon a time ...', `update_time`=now() WHERE id=1; Note: there is no 'and' between the fields you are trying to update. You should use comma between each pair of the fields you are trying to update. Otherwise, you will likely get an '0' as the result value in the 'content' field without getting any error message. If you do the following, you will likely get an '0' in the 'content' field, without any error message /* the wrong way of putting multiple fields together, using 'and' */ UPDATE `stories` SET `content`='My Story' and `update_time`=now() WHERE id=1; See also: http://stackoverflow.com/a/7375371

Aventurine Yao

Search This Blog