{include file="../../../application/admin/view/public/head" /}

- 执行sql语句

> 常用语句对照：
> 1.查询数据 SELECT * FROM {pre}vod 查询所有数据
> SELECT * FROM {pre}vod WHERE vod_id=1000 查询指定ID数据
> 2.删除数据 DELETE FROM {pre}vod 删除所有数据
> DELETE FROM {pre}vod WHERE vod_id=1000 删除指定的第几条数据
> DELETE FROM {pre}vod WHERE vod_actor LIKE '%刘德华%' vod_actor"刘德华"的数据
> 3.修改数据 UPDATE {pre}vod SET vod_hits=1 将所有vod_hits字段里的值修改成"1"
> UPDATE {pre}vod SET vod_hits=1 WHERE vod_id=1000 指定的第几条数据把vod_hits字段里的值修改成"1"
> 4.替换图片地址 UPDATE {pre}vod SET vod_pic=REPLACE(vod_pic, '原始字符串', '替换成其他字符串')
> 5.清空数据ID重新从1开始 TRUNCATE {pre}vod

{include file="../../../application/admin/view/public/foot" /}