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_i
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 `main_gue
deID, @last + 1, 1)) is
> not null
>and (@NodeID := NodeID) is not null
>and (@last > @keeplast)
> ;
>
>
> -Original Message-
> From: joe [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 16, 2008 8:12 PM
> To: 'Santosh Killedar'
>
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
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 suppos
