![](https://img-blog.csdnimg.cn/20190927151117521.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
Oracle
Oracle
渴望知识的菠萝头
边学习边总结,对未知充满好奇。
展开
-
Oracle 常用语法总结(持续更新)
1.建表 2.插入一条数据 insert into 'tableName' (column1,column2...) values (value1,value2...); 3.删除一条数据 delete from 'tableName' where id = ''; 4.更新一条数据 update 'tableName' set column1=value1,column2=value2... where id = ''; 5.复制一列数据 update 'tableName' set ID=ID_t原创 2020-12-15 10:55:02 · 790 阅读 · 0 评论 -
sql 从数据库里随机查询一条数据
1.order by roud() select * from table_ip order by round() limit 1 然后我们会发现执行效果特别慢,因为是全表遍历 2.join优化 select * from table_id t1 join(select round(rand()*(select max(id) from table_id)) as id2) as t2 where...原创 2020-04-22 13:48:33 · 577 阅读 · 0 评论