[size=medium] 1.以学生表为例,建表如图[/size]
[img]http://dl.iteye.com/upload/attachment/429776/ac5c3b5a-81f9-33b5-8e79-81ba6a06101f.jpg[/img]
[size=medium] 2.为表创建主键
alter table student add primary key(id);
3.为表建立序列[/size]
[img]http://dl.iteye.com/upload/attachment/429782/4648fd22-d479-3ede-836e-4ed70a92bd2d.jpg[/img]
[size=medium] 4.为表建立触发器[/size]
[img]http://dl.iteye.com/upload/attachment/429786/50a2e861-09e2-31f7-9914-626fd8e1e226.jpg[/img]
[size=medium] [color=red] 注:触发器是以"/"结尾[/color][/size]
[size=medium] 5.测试[/size]
[img]http://dl.iteye.com/upload/attachment/429788/56073526-ea5b-3dd3-b2ba-5d574c5d3d56.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/429776/ac5c3b5a-81f9-33b5-8e79-81ba6a06101f.jpg[/img]
[size=medium] 2.为表创建主键
alter table student add primary key(id);
3.为表建立序列[/size]
[img]http://dl.iteye.com/upload/attachment/429782/4648fd22-d479-3ede-836e-4ed70a92bd2d.jpg[/img]
[size=medium] 4.为表建立触发器[/size]
[img]http://dl.iteye.com/upload/attachment/429786/50a2e861-09e2-31f7-9914-626fd8e1e226.jpg[/img]
[size=medium] [color=red] 注:触发器是以"/"结尾[/color][/size]
[size=medium] 5.测试[/size]
[img]http://dl.iteye.com/upload/attachment/429788/56073526-ea5b-3dd3-b2ba-5d574c5d3d56.jpg[/img]