- 博客(3)
- 收藏
- 关注
原创 数据库分页
-- MySQL, H2, HSQLDB, Postgres, and SQLiteSELECT * FROM BOOK LIMIT 1 OFFSET 2-- CUBRID supports a MySQL variant of the LIMIT .. OFFSET clauseSELECT * FROM BOOK LIMIT 2, 1-- Derby, SQL Server 201
2017-05-10 16:47:23 251
转载 日期格式中去掉前导0 & RR格式的年份.TXT
分类: LinuxConnected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as attSQL> select to_char(sysdate,'yyyy-mm-dd') from dual;TO_CHAR(SYSDATE,'YYYY-MM-DD')-----------
2017-01-18 19:49:32 736
原创 复制表的sql
1、既复制表结构也复制表内容的SQL语句:CREATE TABLE tab_new AS SELECT * FROM tab_old;2、只复制表结构不复制表内容的SQL语句:CREATE TABLE tab_new AS SELECT * FROM tab_old WHERE 1=2;3、不复制表结构,只复制内容的sql语句:insert into tab_new select * fro
2017-01-16 11:32:58 389
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人