数据库
busishenren
想偷懒不学习!
展开
-
MySQL联合删除delete语法
首先创建两张表,一张用户表(user),一张课程表(course)做简单的演示:CREATE TABLE `user` ( `id` int(0) NOT NULL, `user_name` varchar(50) NULL, `age` int(0) NULL, PRIMARY KEY (`id`));用户表有个唯一标志id,以及用户名称和年龄。课程也很简单:CREATE TABLE `course` ( `id` int(10) NOT NULL, ...原创 2021-02-26 14:55:55 · 2526 阅读 · 0 评论 -
Oracle展示时间段内的所有时间
SELECT TO_CHAR ( TRUNC ( to_Date ( '${startTime}', 'YYYY-MM-DD' ), 'DD' ) + ROWNUM - 1, 'YYYY-MM-DD' ) AS YWSCSJFROM DUAL CONNECT BY ROWNUM < TRUNC ( to_Date ( '${endTime}', 'Y...原创 2019-02-28 11:39:10 · 527 阅读 · 0 评论