http://www.sqlite.org/faq.html. No. 1.
|-+>
| | "[EMAIL PROTECTED]|
| | "
>--|
|
All the filenames you need to modify are on the download page.
Regards.
rayB
** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING
*
*** Confidentiality and Privilege Notice
***
This e-mail is intended only to be read or used by the
Are you confusing a NULL with an empty (zero length) string? They are not
the same.
Regards.
rayB
|-+>
| | "Nguyen Dang |
| | Quang" |
| | <[EMAIL PROTECTED]|
| | m>
Perhaps the analogy is better the other way around - try driving a stick
shift after driving an automatic. Takes a gear change or two for you to
realise what the other pedal is for.
As you mention, this is a constant point of discussion on this board.
Perhaps 'Version 3 Data Types' should be
Try:
UPDATE table SET aColumn = someNewValue, numTouched = numTouched + 1
WHERE ;
Regards.
rayB
|-+>
| | Tito Ciuro |
| | <[EMAIL PROTECTED]> |
| ||
| |
Try:
select count(*) from table1
where (timestamp >13448180261410868 and timestamp <= 13448182164507680);
not:
select count(*) from table1
where ((timestamp >13448180261410868) and (timestamp <=
13448182164507680));
Regards.
rayB
** PLEASE CONSIDER OUR ENVIRONMENT BEFORE
"The second query says that before time A there are 46 entries."
No, that is not what the query states:
select count(*) from table1
where (timestamp<=13448180261410868);
^
Regards.
rayB
** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING
*
Please leave the current functionality as is.
I believe it is the role of the host language to perform any editing or
translation of data, such as the removal of leading or trailing spaces, not
the SQL engine.
Regards.
rayB
** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING
http://www.sqlite.org/lang_createtable.html
Regards.
rayB
|-+>
| | Clint Bailey |
| | <[EMAIL PROTECTED]|
| | h.net> |
| ||
| |
Does the column need to be loaded with UTC? Why not just insert the column
with localtime already applied? It would make the SELECT you require
trivial:
SELECT * FROM table WHERE datefield = '2005-12-23'.
Regards.
rayB
|-+>
| | "Murray @
Refer http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions.
'localtime' has to be allowed for.
Regards.
rayB
|-+>
| | "Murray @|
| | PlanetThoughtful"|
| |
My information is that MySQL does not enforce check constraints - your
testing supports this.
Regards.
rayB
|-+>
| | "Marcus Welz"|
| | <[EMAIL PROTECTED]|
| | om> |
| |
Seconded.
|-+>
| | "Laurent"|
| | <[EMAIL PROTECTED]|
| | ternet.fr> |
| ||
| | 12/10/2005 23:36 |
| | Please respond
... internationalise. Sorry, couldn't resist.
|-+>
| | [EMAIL PROTECTED]|
| ||
| | 11/10/2005 07:48 |
| | Please respond to|
| | sqlite-users
No. COUNT(*) of an empty result returns 0. COUNT(*) should always return an
integer value, never NULL. It is a row-based, rather than a column-based,
aggregate function.
rayB
|-+>
| | "D. Richard Hipp"|
| | <[EMAIL
... and where will it stop? Someone will then ask for 'SELECT COUNT(*) ...
WHERE ...' changes.
Agreed, leave things as they are.
rayB
|-+>
| | Darren Duncan|
| | <[EMAIL PROTECTED]|
| | can.net>
Is it M6 you are referring to?
http://www.auug.org.au/events/2005/auug2005/tutorials.html
Regards.
rayB
|-+>
| | Klint Gore |
| | <[EMAIL PROTECTED]|
| | u> |
| |
I too would be happy to pay for DVDs if they were to be made available.
Tyranny of distance prevents me from attending (Sydney, Australia based).
rayB
|-+>
| | "Paul G" |
| | <[EMAIL PROTECTED]|
| |
Try:
SELECT * FROM t1 WHERE b IS NULL;
A column value is null or not null; it cannot be said to equal null as null
has no value;
rayB
|-+--->
| | Stefan Finzel |
| | <[EMAIL PROTECTED]|
| |
No, thank you for taking the time and effort for this very informative
post-mortem. There's some stuff here I didn't know, so my knowledge and
skills have also been expanded.
Regards.
rayB
*** Confidentiality and Privilege Notice ***
This e-mail is intended
Just curious. What is it that is motivating you to vacuum so frequently?
Regards.
rayB
*** Confidentiality and Privilege Notice ***
This e-mail is intended only to be read or used by the addressee. It is
confidential and may contain legally privileged
It's not possible for a column value to be equal to NULL; hence the SQL
syntax is 'IS NULL'. However, in an UPDATE statement, writing
'columnA=NULL' is valid, as in this context '=' is an assignment, not a
relationship operator.
Regards.
rayB
|-+>
|
SQLite generating the "create index" SQL DDL statement at the end of the
.dump output is the correct behaviour.
In my experience using a number of different DBMSs, the sequence of data
loading and then indexing is usually quicker than performing those
operations the other way round. In a
Or try:
.mode lines
.null
select * from tablename limit 1;
The output is more readable if tablename has many columns and also provides
some example data for each column.
rayB
|-+--->
| | "Griggs, Donald"|
| |
Windows download is 628.1MB. There goes your hard drive. 'Nuff said really.
rayB
|-+>
| | Andrew Piskorski |
| | <[EMAIL PROTECTED]|
| | m> |
| ||
|
UNION working correctly. UNION returns distinct values; UNION ALL returns
all rows (including duplicates).
rayB
*** Confidentiality and Privilege Notice ***
This e-mail is intended only to be read or used by the addressee. It is
confidential and may contain
26 matches
Mail list logo