MySQL Forums
Forum List  »  Sybase

SELECT statement that should not return the "XXX rows affected line"
Posted by: Muslim Abdul KADER
Date: April 23, 2009 08:47AM

I need to write a select statement, that should produce just the output and should not show up the "no of rows affected" in its output.
for example

1> select * from Tester

TesterId TestCompId TestprovId -----------
0 0 0
2280638 2280638 1000
2280639 2280639 1000
2280640 2280640 1000
2280641 2280641 1000
2280642 2280642 2000
2280643 2280643 2000
2280644 10270970 1000
2280645 2280645 2000
2280646 2280646 2000
5300522 5300522 2000
5300523 5300523 2000
5300524 5300524 2000
5309074 5309074 2000
5573907 5573907 2000
5909156 5909156 1000
5915339 5915339 1000
6879589 6879589 1000
8155084 8155092 2000
10270973 10270973 1000
12746835 12746837 1000
14197273 14197273 1000

(22 rows affected)

I do not want the (22 rows affected) line. What do i need to add in the select statement to eliminate this?

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT statement that should not return the "XXX rows affected line"
8909
April 23, 2009 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.