SQLite Forum

A little help with temp tables?
Login
> CREATE TEMP TABLE hello ( SELECT ProductI...

```
sqlite> create temp table foo as select * from event limit 3;
sqlite> select * from foo;
'ci',2454303.0902662039734,1,NULL,NULL,NULL,NULL,'drh',NULL,'initial empty baseline',NULL,2454303.0902662039734
'ci',2454304.0000694449991,181,NULL,NULL,NULL,NULL,'drh',NULL,'Setup webpag updates.',NULL,2454304.0000694449991
'ci',2454303.3139583338051,182,NULL,NULL,NULL,NULL,'drh',NULL,'Improvements to web-based user management.',NULL,2454303.3139583338051
```