The variable scope in javascript can still surprise me. This is a nice one I debugged today: A variable that is not defined by "var" have a global scope. Th

This is slightly modified from something I found @ http://www.kirupa.com/forum/archive/index.php/t-263260.html Using high-score lists or similar you often ha

This is another MySQL trick I keep coming back to. mysqldump -u root --password=pass db1 | mysql -u root --password=pass db2 found @ http://mywheel.net/

When you need to switch a fields collation you can check if any existing data will conflict with this change. For example a keyword-field might contain data

The unix cp command makes you the owner of the copied files. You can set flags but this is supposedly a more complete way to keep any attributes.

mkdi

Quite simple but something I can never seem to remember: INSERT INTO files_users (file_id, user_id) SELECT id, '2' FROM efs.files; found @ http://mysq

Echoing an echo in PHP can create confusing output: will output hello1 since you will be printing the return value (boolean true)

When altering a database, table or field from one character set to another, existing data will probably look garbled since it is expected to be in the new chara

Altering the character set and collation of a table is sometimes not enough. You may have to alter the actual fields in the table to get MySQL to comply in some

You can select from a table and set the collation to be used for the search. [code] SELECT * FROM my_table WHERE my_field = 'hallå'; SELECT * FROM my_tab