mysql
qiuqiutang_007
这个作者很懒,什么都没留下…
展开
-
mysql语句
1.取下一个自增字段的值:select auto_increment from information_schema.`TABLES` where TABLE_NAME='t_exampaper';2.查询表是否存在:select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA`='dbname...原创 2010-05-15 13:21:04 · 54 阅读 · 0 评论 -
mysql查看触发器
SELECT * FROM information_schema.TRIGGERS;原创 2012-02-01 13:57:18 · 120 阅读 · 0 评论 -
mysql 日期比较
select * from tb where c> date_format('2007-07-06','%Y%m%d') and c <= date_format('2007-07-09','%Y%m%d');select * from tb where c> date('2007-07-07') and c< date('2007-07-09')STATDAY是形如2...原创 2012-02-02 14:00:13 · 91 阅读 · 0 评论