Hi all,
I have a problem with a table in the database. I created it a while ago (a
month maby) and then everything worked fine. Now however, every time I query
the table the query hangs and I don't know why. I understand that it's
difficult to tell me what the problem is based on that little
Hi again,
Little more information about the problem that I wrote about in my last
email.
As I said before, the database wont accept any query to that table. It just
hangs. However I'm not sure of which query that is executed the first time
the table hangs. I'm not sure if this matters. But
Hi,
I have this table:
CREATE TABLE FOR_SALE (
ISBN VARCHAR(10) NOT NULL,
STOREID MEDIUMINT(8) UNSIGNED NOT NULL,
MYDATE DATE NOT NULL,
PRICE SMALLINT UNSIGNED NOT NULL,
PRIMARY KEY (ISBN, STOREID, MYDATE)
);
When I execute this query:
SELECT count(*) FROM FOR_SALE
nothing