On Wed, 2005-08-10 at 11:30 +0200, djm wrote:
> Hello,
>
>
> >> My understanding, after all of your helpful comments, currently is:
> >>
> >> Simultaneous reading of a server file by different clients is safe, as
> >> long as the file doesnt get changed at all (at least in a time scale
> >>
Marcus Welz wrote:
Hello there,
I think that adhering to standards is a Very Good Thing(tm). They are
standards for a reason. Deviations can introduce ambiguity, confusion,
complexity, vendor lock-ins and all sorts of other headaches.
That said, however, I believe that "no, because it's not
Hello there,
I think that adhering to standards is a Very Good Thing(tm). They are
standards for a reason. Deviations can introduce ambiguity, confusion,
complexity, vendor lock-ins and all sorts of other headaches.
That said, however, I believe that "no, because it's not the standard" isn't
On 8/10/05, Austin Ziegler <[EMAIL PROTECTED]> wrote:
> > What are your reasons for thinking supporting '`' is a bad idea?
>
> 1. It's not part of the standard.
LOL!
Standards are great! Everybody should have several. ;)
On Aug 10, 2005, at 12:38 PM, Kurt Welgehausen wrote:
AS is always optional, i.e., in table names and in
column names.
That's what I thought as well. But the documentation doesn't reflect
that. It isn't a huge deal, of course, but people looking at the docs
for the right syntax might
AS is always optional, i.e., in table names and in
column names.
Regards
On 8/10/05, ender <[EMAIL PROTECTED]> wrote:
> Austin Ziegler wrote:
>>On 8/9/05, ender <[EMAIL PROTECTED]> wrote:
>>> So my simple feature request would be: allow '`' as a quoting symbol -
>>> as mySQL does. Or - what would be as helpful as the other idea - allow
>>> unquoted column names with
Austin Ziegler wrote:
On 8/9/05, ender <[EMAIL PROTECTED]> wrote:
So my simple feature request would be: allow '`' as a quoting symbol -
as mySQL does. Or - what would be as helpful as the other idea - allow
unquoted column names with leading digits - as mySQL does.
Also see ticket #
It would seem that if you alias tables in the FROM clause of a SELECT
statement, the "as" that falls between the real table name and the
alias is optional. But the lang_select.html page seems to indicate
that it is required (there aren't any square brackets around the "AS"
in the
David Fowler wrote:
Query 2:
SELECT * FROM table1, table2
WHERE ((table1.value LIKE "%value%" AND table1.table2_id = table2.id)
> OR (table1.value LIKE "%different_value%" AND table1.table2_id =
table2.id)); This query (and even more complex versions of it) works in
MySQL (Haven't tried
> select conversation_id, count(*), max(unread), max(updated_on)
> from messages
> where conversation_id in ()
> group by conversation_id;
>
> I use max(updated_on) to get the date of the most recent message in
> the conversation. Is there a way to return the ID of this message?
Assuming that the
Wednesday, August 10, 2005, 5:57:50 AM, Ivo wrote:
IK> Hello,
IK> It seems that at least under windows there are rounding problems with the
IK> milliseconds:
IK> sqlite> select strftime("%f", "2005-01-01 12:34:55.122");
IK> 55.121
IK> [...]
IK> Is this maybe a problem of the underlying
On 8/10/05, Colin Fleming <[EMAIL PROTECTED]> wrote:
> I'm writing a messaging system, and I have the following problem.
> I have a conversations table, and a messages table that has a
> foreign key to conversations. I can do something like the
> following to provide a summary:
>
> select
Hi,
does the pragma full_column_names work in sqlite3 command line utility?
If I write:
.header on
pragma full_column_names=1;
select * from t1;
I do not see the table name (t1) in column headers. I see 'ID' not 't1.ID'.
Fanda
Hello,
It seems that at least under windows there are rounding problems with the
milliseconds:
sqlite> select strftime("%f", "2005-01-01 12:34:55.122");
55.121
sqlite> select strftime("%f", "2005-01-01 12:34:55.123");
55.122
sqlite> select strftime("%f", "2005-01-01 12:34:55.124");
55.124
Hello,
>> My understanding, after all of your helpful comments, currently is:
>>
>> Simultaneous reading of a server file by different clients is safe, as
>> long as the file doesnt get changed at all (at least in a time scale
>> where the Client Os could cache it).
Mrs.> Remove your
I'm writing a messaging system, and I have the following problem. I
have a conversations table, and a messages table that has a foreign
key to conversations. I can do something like the following to provide
a summary:
select conversation_id, count(*), max(unread), max(updated_on)
from messages
17 matches
Mail list logo