Daily Archives: 2005-04-07

SQL 筆記

UPDATE user SET pass_can_change_time = unix_timestamp( date_add( now( ) , INTERVAL 1 year ) ) ,
acct_ctrl = n WHERE username = account

當 n = 16 則 Account Flags = [U] (普通使用者)
當 n = 20 則 Account Flags = [UN] (不需密碼)
當 n = 17 則 Account Flags = [UD] (帳號失效)