On Tuesday 06 July 2004 15:30, Paul McNeil might have typed:
When I run this it says that the temp table has only 1000 rows. Why?
Are you using mysqlcc?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A more direct way to find dupes ...
SELECT id, COUNT( id ) AS cnt,
FROM myTable
GROUP BY id
HAVING cnt 1
PB
- Original Message -
From: Paul McNeil
To: MySQL General
Sent: Tuesday, July 06, 2004 9:30 AM
Subject: Create Temporary Table, incorrect rows
Good day to all.
, 2004 11:11 AM
To: Paul McNeil; MySQL General
Subject: Re: Create Temporary Table, incorrect rows
A more direct way to find dupes ...
SELECT id, COUNT( id ) AS cnt,
FROM myTable
GROUP BY id
HAVING cnt 1
PB
- Original Message -
From: Paul McNeil
To: MySQL
On Tue, Jul 06, 2004 at 10:30:38AM -0400, Paul McNeil wrote:
Good day to all.
I have a table and want to find duplicate info in the table. I know
duplicated info exists by running the following...
Select count(*) from myTable - 141123
Select distinct(myData) from myTable - 1411000
I
11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Create Temporary Table, incorrect rows
On Tuesday 06 July 2004 15:30, Paul McNeil might have typed:
When I run this it says that the temp table has only 1000 rows. Why?
Are you using mysqlcc?
--
MySQL General Mailing List
For list archives: http
On Tuesday 06 July 2004 17:20, Paul McNeil wrote:
Yes I am using mysqlcc. Is that why the 1000 row limit?
Yes. It's under the server options tag (don't have it in front of me to give
exact details). If you right click the server connection, under I think
properties, there's a query limit.