{$meta_title}
常用语句对照:
1.查询数据 SELECT * FROM {pre}novel 查询所有数据
SELECT * FROM {pre}novel WHERE id=1000 查询指定ID数据
2.删除数据 DELETE FROM {pre}novel 删除所有数据
DELETE FROM {pre}novel WHERE id=1000 删除指定的第几条数据
DELETE FROM {pre}novel WHERE author LIKE '%土豆%' author"土豆"的数据
3.修改数据 UPDATE {pre}novel SET hits=1 将所有hits字段里的值修改成"1"
UPDATE {pre}novel SET hits=1 WHERE id=1000 指定的第几条数据把hits字段里的值修改成"1"
4.替换图片地址 UPDATE {pre}novel SET pic=REPLACE(pic, '原始字符串', '替换成其他字符串')
5.清空数据ID重新从1开始 TRUNCATE {pre}novel