On Thursday 07 July 2005 04:13 pm, Marvin Bellamy wrote:
> Thanks for the join tip. This must be a 3.2.1-specific bug, because
> that last example doesn't work for me. Looks like its been reported
> already.
Oops.. guess I missed that.
this works great:
sqlite> create view v2 as select a.id as
On Thursday 07 July 2005 02:19 pm, Marvin Bellamy wrote:
> Can anyone explain why these queries don't work? And, is there a
> workaround?
>
> create table t1 (id int);
> create table t2 (id int, name varchar(32));
> create view v1 as select a.id, b.name from t1 a, t2 b where a.id=b.id;
ugly way
On Wednesday 06 July 2005 05:12 pm, Ray Mosley wrote:
> I was already expanding my SQl horizons asking this question.
> What would be a reasonable action?
Anything but a seg fault ;)
display the error perhaps?
>
> On 7/6/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > On 7/6/05, Kiel W. <[EMAIL
On Tuesday 05 July 2005 04:48 pm, Michael Grice wrote:
> If not, are there plans to add this?
>
> I'm just a NOOB, looking to see what all SQLite can do for me, before
> I go too far down this road.
>
> Thx.
like this?
select * from table where a like '%abc%';
On Tuesday 05 July 2005 05:31 pm, Tom Shaw wrote:
> Is there an easy way to perform a search on VARCHAR/CHAR/TEXT column
> for those entries that has strings that are longer than x without
> writing my own comparitor? I am using SQLite in a PHP environment, I
> am looking for an intrinsic function
e. is julianday('2005-07-01') going to store
> any time information? Thanks.
yes it does.
sqlite> select datetime(julianday('2005-07-01'));
2005-07-01 00:00:00
time is midnight ;)
>
> jack.
>
> --- Stephen Leaf <[EMAIL PROTECTED]> wrote:
> > On Tuesday 05 July
On Tuesday 05 July 2005 09:53 am, Cory Nelson wrote:
> Just an educated guess, but probably because sqlite tries to be as
> minimal as possible. Which I have no complaints with, as comparing a
> double will likely be faster than comparing a string.
I personally store all mine like this anyway
unless I didn't look in the right place? I'd assume
this is just all standard SQL however where is a good place to read up on
that? in the past I just read the DBMS site.
>
> -Ursprüngliche Nachricht-
> Von: Stephen Leaf [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag,
sqlite> select time('now');
13:45:20
$ date
Fri Jul 1 08:45:37 CDT 2005
anyone know what's wrong?
thanks,
Stephen
9 matches
Mail list logo