Re: Multistatement Seperator

2002-09-23 Thread Michael T. Babcock 

Davis, Tim wrote:

select count(*) from table1
go
select count (*) from table2
go

This will return 2 results, with count of each table.  How would I do the
same thing in MySQL?
  

I'm not sure if you can; I tried:
select count(table1.id) as table1_count, count(table2.id) as 
table2_count from table1, table2;
... and it returned the greater value of the two for both counts.

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Multistatement Seperator

2002-09-20 Thread Davis, Tim 

In MS SQL, I can do the following statement

select count(*) from table1
go
select count (*) from table2
go

This will return 2 results, with count of each table.  How would I do the
same thing in MySQL?

Tim Davis
Sunbelt Systems Concepts, Inc
[EMAIL PROTECTED]
Client/Server Database Programmer/Analyst

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php