I understand that at some point, a sql table that has been locked by
someone
will automatically be unlocked, but I'm a little unclear as to the
circumstances. Say at the beginning of a function I open a connection,
lock a table, and then close the connection. Then, perhaps a few lines
down in
Sorry about the mutli post of this, but I got some mail daemon errors, so
I'm sending again to make sure. The question is below.
Carl
-- Forwarded message --
Date: Fri, 12 Apr 2002 10:20:37 -0400
From: Carl Schmidt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Locking tables
On Fri, 12 Apr 2002, Christopher Thompson wrote:
On Friday 12 April 2002 8:10 pm, Carl Schmidt wrote:
I have a form where a user enters some numbers into text boxes. Some of
the text boxes can be left blank. The business logic receives all
variables to all text boxes. Should I :
I'm
If I set a mysql table def time to default like so:
eventTime time NOT NULL DEFAULT '0';
Will it default to the current time like the TIMESTAMP does? If not, is
it possible with something like CURTIME() to make this happen?
Carl
From the mysql docs, it looks like you can only use foreign keys if your
tables are type InnoDB. Is this correct?
Carl
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I don't believe my web host has either InnoDB or BDB installed on their
system so I ran some tests here:
mysql alter table Development_EventType TYPE=INNODB;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
That's the result I get, but when I do a table dump, the
| NO|
| have_ssl | NO|
+---+---+
6 rows in set (0.00 sec)
mysql
Looks to pretty clear like it ain't there.
Carl
On Sun, 7 Apr 2002, Paul DuBois wrote:
At 20:23 -0400 4/7/02, Carl Schmidt wrote:
I don't believe my web host has either InnoDB or BDB installed on their
system
One thing did occur to me though. I was looking at the syntax for
actually creating a database on the mysql server. I wanted to make sure
that those table types that are installed with mysql do not have to be
specified as _available_ to tables in a particular database. In other
words, when a
On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the
. However, it prompted me to ask the question, are primary
keys already optimized for some sort of indexing and searching? So then I
emailed the list.
Carl
On Sat, 6 Apr 2002, Paul DuBois wrote:
At 18:28 -0500 4/6/02, Carl Schmidt wrote:
On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote:
Your
10 matches
Mail list logo