创建帐号
 
INSERT INTO account (username,I,gmlevel,tbc) VALUES ('myname',SHA1(CONCAT(UPPER('myname'),':',UPPER('123456'))),3,1);
修改密码
UPDATE account SET I = SHA1(CONCAT(UPPER('myname'),':',UPPER('456789'))) WHERE username = 'myname';