but not much luck. Thanks for looking
99.99% of the time when somebody wants to make a table with that many
columns, it's because they don't understand relational databases and are
trying to put information that should be in a joined table into columns in
the main table.
--
Paul Tom
963 1
cosdb=>insert into t values (3, 3);
INSERT 973964 1
cosdb=>insert into t values (4, 4);
INSERT 973965 1
cosdb=>select avg(a), avg(b) from t;
avg | avg
+------
3.3333 | 3.33
(1 row)
cosdb=&g
that
means being able to compare versions, roll back erroneous edits, get what
the database looked like before a particular editor came along, etc. Is
there anything written on this topic? Has anybody ever tried it before?
--
Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/
s can't run in a reasonable time because the batch applications
won't allow the updater to commit until the batch job is finished.
--
Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/
OTOH, the general theme is that lusers should not be allowed to have
computers, cars, guns or genitalia.
-- Anthony DeBoer
Quoting Dennis Cote ([EMAIL PROTECTED]):
> Doesn't this mean that SQLite only supports 2^63 rows with autoincrement?
That means you can insert one row per millisecond for 29 million years.
--
Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/
In any business, the cust
ou insert 12,0 in the column "price", and you're complaining
that the value in a different column, "amount", is the default? WTF?
> Of course it's not critical but maybe new pragma would be useful.
#pragma READ_MY_MIND
--
Paul Tomblin <[EMAIL PROTECTED]> http:/
d to mean anyway?
I think it's a MySQL-ism.
--
Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/
"An NT server can be run by an idiot, and usually is." -- Tom Holub, a.h.b-o-i
he first one
is running:
- Can the second one query while the first one is querying?
- Can the second one query while the first one is updating?
- Can the second one update while the first one is updating?
- does committing in the first one release the lock and allow the seocnd
one to continue?
-
hose query is still open.
I suppose the only way I'm going to know for sure is to try writing the
same sequence of events in C, and it's been so long I'm not sure my C
skills are up to it.
--
Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/
If you're not part of the solution, you're part of the precipitate.
line 547
}
nextID does the following:
while (1)
{
$isTaken->execute($maxNumber);
if (@row = $isTaken->fetchrow_array)
{
print "$maxNumber is already taken\n";
$maxNumber++;
}
else
{
las
10 matches
Mail list logo
