Gyurasits Zoltán wrote:
Hi,
Yes! And the "SELECT" contain some table!
SELECT (??) .... FROM table1 INNER JOIN table2....
I have a problem with the follow solution:
SET @count:=0;
SELECT @count:[EMAIL PROTECTED] AS `count`, `value` FROM `table`;
I can't execute more select in my system. (Delphi software) :(
Couldn't you use the index of the row of the result set to define that
"serial"?
Only 1 select allowed! Because it is the reporting system...
1 output is 1 select!
Best Regards!
Zoli
----- Original Message ----- From: "Jason Pyeron" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, August 25, 2005 5:23 PM
Subject: Re: create "serial number" by select
On Thu, 25 Aug 2005, Pooly wrote:
Why not adding an auto_increment column to your data ?
2005/8/25, Gyurasits Zoltán <[EMAIL PROTECTED]>:
I can't build "serial number" in table1!
Because he is not allowe to modify the table, pick any reason.
--
Nuno Pereira
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
