1: 列出所有数据 select * from sea_data
2: 删除所有数据(id不还原为0) delete from sea_data/sea_playdata/sea_content 三个表各执行一次
3: 列出某一栏目数据 select * from sea_data where tid =(select tid from sea_type where tname = '频道1')
4: 删除某一栏目数据 delete from sea_data where tid =(select tid from sea_type where tname = '频道1')
5: 清空所有数据(id还原为从0开始) TRUNCATE sea_data/sea_playdata/sea_content 三个表各执行一次
(请谨慎操作,以免造成数据错误![?])
|