mysql 小技巧

1. 複製 table
CREATE TABLE [table_name] SELECT * FROM [old table name]

2. update record
UPDATE [table_name] SET [column_name]=[new_value] WHERE [column_name]=[some_value]

php, sql 極好的自學網站:
http://www.w3schools.com/php/php_mysql_intro.asp