将查询从MySql转换为Sqlite [英] Convert query from MySql to Sqlite

问题描述

我需要将此查询从MySQL格式转换为SQLite.我正在尝试自己，但发现了一些困难.

I need to convert this query from MySQL format to SQLite. I'm trying myself but I've found some difficulty.

在SQLite中，curdate()和interval函数不存在.

In SQLite, the curdate() and the interval functions do not exist.

select a.Date 
from (
    select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as Date
    from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a
    cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b
    cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c
) a
where a.Date between '2010-01-20' and '2010-01-24' 

推荐答案

以下是基本语法:

select a.Date 
from (select date('now', '-'||(a.a + (10 * b.a) + (100 * c.a))|| ' days') as Date
      from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9
           ) a cross join
           (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9
           ) b cross join
           (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9
           ) c
    ) a;

我省略了where子句，因为这些日期是过去1000余天，因此他们仍然不会选择任何内容.

I left out the where clause because those dates are more than 1000 days in the past, so they won't select anything anyway.

这篇关于将查询从MySql转换为Sqlite的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！