1: 列出所有数据 select * from f5_data
2: 删除所有数据 delete from f5_data
3: 列出某一栏目数据 select * from f5_data where tid =(select tid from f5_type where tname = '频道1')
4: 删除某一栏目数据 delete from f5_data where tid =(select tid from f5_type where tname = '频道1')
5: 列出某一专题的数据 select * from f5_data where v_topic =(select id from f5_topic where name = '男人必看十部')
6: 删除 某一专题的数据 delete from f5_data where v_topic =(select id from f5_topic where name = '男人必看十部')
(请谨慎操作，以免造成数据错误！[?])
|