SQL
c_83456768
这个作者很懒,什么都没留下…
展开
-
MySql快速生成insert 语句
用于替代手写insert语句生成后自行编辑所需要的字段即可-- python版占位符SELECT CONCAT( 'insert into ', table_name, '(', GROUP_CONCAT( COLUMN_NAME ), ') value (', GROUP_CONCAT( '%s' ), ')' ) FROM information_schema.COLUMNS WHERE table_schema = 'your database' AN原创 2022-04-15 12:18:30 · 4767 阅读 · 0 评论 -
oracle筛选一年周末日期并循环插入表中
DECLARE cursor days IS SELECTd FROM ( SELECT TRUNC( TO_DATE( '2021-11-1', 'YYYY-mm-dd' ) ) + ROWNUM - 1 AS d FROM dual CONNECT BY ROWNUM <= 430 ) td WHERE TO_CHAR( td.D, 'd' ) IN ( 1, 7 );BEGIN FOR dc IN days LOOP INSERT INTO "HOLIDAYS" VA.原创 2021-10-26 17:02:54 · 487 阅读 · 0 评论 -
[SQL]递归查询
SELECT DISTINCT T.NODEVALUEID FROM Table_TREE T START WITH T.NODEID = '{0}' CONNECT BY PRIOR T.NODEID = T.PARENTNODEID原创 2014-05-27 08:59:11 · 360 阅读 · 0 评论 -
给ORACLE数据库的列添加默认值
ALTER TABLE ‘table’MODIFY('column' DEFAULT 'value')原创 2014-06-19 15:31:43 · 1358 阅读 · 0 评论 -
DISCUZ,数据库批量禁言
update ****common_member t set t.groupid = 4 where clause;原创 2015-10-17 14:58:15 · 851 阅读 · 0 评论 -
MySql,Trim函数使用
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING,转载 2015-11-26 20:51:07 · 532 阅读 · 0 评论