数据库
关注
分享
扫一扫
chengyu_555
性格稳重
展开
-
数据库随机取数据
mysql中随机取10条数据select * from 表名 order by rand() limit 10oracle中随机取1条数据select * from（select * from 表名 order by dbms_random.value）2008-10-08 17:12:21 · 402 阅读 · 0 评论 -
mysql触发器
delimiter $$CREATE TRIGGER vt_trigger_delete AFTER DELETE on versiontypeFOR EACH ROW BEGIN delete from versiontype where parentid = old.id;END $$delimiter;2008-12-08 15:53:34 · 130 阅读 · 0 评论