Looks like you're missing a comma after comm_id, before
the @num := line?
andy
Santosh Killedar wrote:
I am trying the following code on 4.1.2 and getting a
syntax error that I could not figure out. It works
fine on 5.x. Any suggestion/alternate
CREATE TEMPORARY TABLE Temp
(Node INT,
comm_id
I am trying the following code on 4.1.2 and getting a
syntax error that I could not figure out. It works
fine on 5.x. Any suggestion/alternate
CREATE TEMPORARY TABLE Temp
(Node INT,
comm_id INT, INDEX USING BTREE (comm_id))
ENGINE = MyISAM;
INSERT INTO Temp
SELECT recipient, id
FROM
and (@last @keeplast)
;
-Original Message-
From: joe [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 16, 2008 8:12 PM
To: 'Santosh Killedar'
Subject: RE: MYSQL Limit
http://www.xaprb.com/blog/2006/12/15/advanced-mysql-user-variable-techniques
/
-Original
On Sunday 04 July 2004 02:52 am, Gary Mack wrote:
Hi there,
I recently learned about LIMIT so that I can page
through records on a web page I am creating.
However, when coupled with ORDER BY, the sorting
does not work anymore. Can someone look at my below
query and point out what I am
Arvin Bautista wrote:
I'm new to mysql/sql thing
thus mysql can efficiently handles a database even it has a hundred tables
Yes, but you need to make sure to set your table cache large enough
to cache all these tables to stay fast. This is for MyISAM tables,
the default. BDB supposedly