- 1
- 2
- 3
- 4
- 5
- 6
- 7
const string sql = @"DROP TABLE IF EXISTS inter_table_tmp;
CREATE TEMPORARY TABLE inter_table_tmp AS
select * from table1
where time >= '{0} 00:00:00' and timetime<= '{1} 23:59:59'
and status=1 and some_id in (225,244);
select*from inter_table_tmp;
drop table inter_table_tmp;";
Комментарии (0) RSS
Добавить комментарий