Mysql
zhu473105308
这个作者很懒,什么都没留下…
展开
-
Mysql常用语句部分(1)
create database oa;//创建数据库drop database oa;//删除数据库use oa;//使用数据库alter table zhulei add column createTime timestamp default CURRENT_TIMESTAMP; //给表添加属性alter table person modify id in原创 2012-02-15 16:51:11 · 455 阅读 · 0 评论 -
Mysql 中 存储过程 if else
以下这样写会报错:[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end if' at line 8 create procedur原创 2012-04-09 11:17:56 · 18132 阅读 · 1 评论 -
Mysql 触发器
CREATE TRIGGER insertToTbdaylogger AFTER INSERT ON tbtaskflow FOR EACH ROWBEGIN DECLARE i_temp int; select count(*) into i_temp from tbdaylogger where insertTimes>=DATE_SUB(NOW()原创 2012-05-04 17:47:29 · 838 阅读 · 0 评论