请问这段数据怎么删除？

1. CREATE TABLE `cdb_ddone_log_7ree` (
   
2. `id_7ree` MEDIUMINT( 8 ) NOT NULL ,
   
3. `tid_7ree` MEDIUMINT( 8 ) NOT NULL ,
   
4. `uid_7ree` MEDIUMINT( 8 ) NOT NULL ,
   
5. `dc_7ree` TINYINT( 1 ) NOT NULL,
   
6. `time_7ree` INT( 10 ) NOT NULL,
   
7. `isadd_7ree` TINYINT( 1 ) NOT NULL
   
8. ) ENGINE = MYISAM ;
   
9. 
   
10. 
    
11. CREATE TABLE `cdb_ddone_tie_7ree` (
    
12. `tid_7ree` MEDIUMINT( 8 ) NOT NULL ,
    
13. `ding_7ree` MEDIUMINT( 8 ) NOT NULL ,
    
14. `cai_7ree` MEDIUMINT( 8 ) NOT NULL,
    
15. `time_7ree` INT( 10 ) NOT NULL,
    
16. `isadd_7ree` TINYINT( 1 ) NOT NULL
    
17. ) ENGINE = MYISAM ;
    

复制代码

1. 升级数据库1
   
2. 
   
3. ALTER TABLE `cdb_posts` ADD `flower` INT(10) DEFAULT '0' NOT NULL;
   
4. ALTER TABLE `cdb_posts` ADD `egg` INT(10) DEFAULT '0' NOT NULL;
   
5. ALTER TABLE `cdb_threads` ADD `flower` INT(10) DEFAULT '0' NOT NULL;
   
6. ALTER TABLE `cdb_threads` ADD `egg` INT(10) DEFAULT '0' NOT NULL;
   
7. 
   
8. 升级数据库2：
   
9. 
   
10. CREATE TABLE `cdb_felog` (
    
11. `id` mediumint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
    
12. `fromuser` varchar( 15 ) NOT NULL default '',
    
13. `touser` varchar( 15 ) NOT NULL default '',
    
14. `asfe` varchar( 8 ) NOT NULL default '',
    
15. `tid` varchar( 15 ) NOT NULL default '',
    
16. PRIMARY KEY ( `id` )
    
17. ) TYPE = MYISAM;

复制代码

请高的帮个忙。。。

1. 
   
2. drop table cdb_ddone_log_7ree,cdb_ddone_tie_7ree,cdb_felog;
   
3. ALTER TABLE `cdb_posts` drop `flower` ;
   
4. ALTER TABLE `cdb_posts` drop `egg` ;
   
5. ALTER TABLE `cdb_threads` drop `flower` ;
   
6. ALTER TABLE `cdb_threads` drop `egg` ;
   

复制代码

drop table cdb_ddone_log_7ree,cdb_ddone_tie_7ree,cdb_felog;
ALTER TABLE `cdb_posts` drop `flower` ;
ALTER TABLE `cdb_posts` drop `egg` ;
ALTER TABLE `cdb_threads` drop `flower` ;
ALTER TABLE `cd ...
huihui0103 发表于 2009-7-24 17:32

谢谢，你人太好了。。。

举手之劳。。。。。。。

字符集错误的数据表 (字符集不一致可能会导致乱码，请手动修复以下数据表，当前字符集 GBK)
cdb_threadsmood(latin1)cdb_threadsmoodvote(latin1)

升级后主这样了。。。。？怎么解决吖？

已经解决！！！