学步园

(1). 查询语句：
           select username,uid from supesite.supe_userspaces where catid='91';
           select T1.image from supesite.supe_spaceimages AS T1 INNER JOIN supesite.supe_spaceitems AS T2 ON             T1.itemid = T2.itemid where T2.username = '".$username."' LIMIT 1;

     (2).插入语句：
           insert into cdb_members (username,password) values ('$username','$passwd');

     (3).更新语句：
          update vpopmail.vpopmail set pw_privilege='1' where pw_name='haha';

     (4).修改表结构语句：
          alter table vpopmail     add pw_haha int (10) default null;
          alter table vpopmail     drop pw_haha;
          alter table haha     add uid int (10) not null auto_increment, add primary key (uid);

     (5). 创建表 数据库：
           create table lian (a int,b char(10));
           create database jie;
  
     (6) .删除数据库 表 记录：
        drop database jie;
        drop table lian;
        delete from lian where username='dd';

     (7) mysql 备份
         mysqldump --all-databases > all_databases.sql

     (8) mysql 恢复
          mysql < all_databases.sql

     (9) 创建mysql帐户
          mysql> grant all privileges on *.* to 'lianbinjie'@'localhost'
           -> identified by '840611';

        mysql> GRANT SELECT,UPDATE ON *.* TO 'monty'@'%' (可以网络访问的账户)
          ->       IDENTIFIED BY '840611';

    (10)    更改已有帐户的密码
         mysql> grant all privileges on *.* to 'lianbinjie'@'localhost'
            -> identified by '840611';
          mysql> flush privileges;