纳速健身

标题: mqsql小操作 [打印本页]

作者: yaokai 时间: 2009-8-17 10:30
标题: mqsql小操作
更新 update te_query set query_name = 881 where query_code = 80
delete from te_query where QUERY_CODE = 80 删除
查询表名
SELECT table_name from tables where ENGINE = 'InnoDB ' and TABLE_NAME <> 'te_query' 方法较笨拙
show tables 快捷方便

欢迎光临纳速健身 (https://nasue.com/)