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) :(
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.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218 -
- -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately. Any other use of the email by you
is prohibited.
--------------------------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
