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.
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
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 -> 141100
, 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: My
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.
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]
In my original post I didn't add that I close the connection just before
I exit the function.
If lngRecordAffected <> 0 Then ' if the execute was successful then
let's commit the updates
cn.CommitTrans
WriteData = lngRecordAffected
Else ' otherwise let's rollback to before
In your VB code, are your connections pooled, or are you using the same
connection for each database call?
>> Original Message <<
On 3/3/04, 1:12:07 PM, Jacque Scott <[EMAIL PROTECTED]> wrote regarding
CREATE TEMPORARY TABLE:
> I am trying to create a temporary
For what it's worth, I get the same problem with 4.0.13, and have posted the
same question a few times with no response.
It works fine at the command line, but not through the mysql++ API.
It doesn't work on my home/work machines (both running XP), though my
colleague doesn't experience the problem
> > Further to this, I should point out everything works fine in mysql-front
> > or at the mysql console.
> >
> > The problem shows up when using mysql++, a BadQuery exception is thrown.
> >
> > query.reset();
> > query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
> >
Further to this, I should point out everything works fine in mysql-front or
at the mysql console.
The problem shows up when using mysql++, a BadQuery exception is thrown.
query.reset();
query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
MAX_ROWS=1 " << subselect
Sorry the problem fixed itself, and I mistakenly sent this email
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 9:01 am
Subject: Re: CREATE T
"Phil Dowson" <[EMAIL PROTECTED]> wrote:
>
> I am running two identical systems, the only difference between the two are
> the database name and username. The problem I am getting only occurs on one
> of the systems. I am running
What exactly problem do you have?
--
For technical support cont
And what would that be?
Phil Dowson wrote:
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives: http://lists.m
On Mon, Apr 08, 2002 at 01:40:02PM -0500, Steve Buehler wrote:
> If I want to use temporary tables I know I can create tables
> that are unique without using "CREATE TEMPORARY TABLE table_name".
> What I want to know, because it might be more efficient, is if I use
> "CREATE TEMPORARY TABLE
Thank You. That is what I was hoping for. I would assume that this would
be faster than actually coming up with a random name, using srand and rand,
for a table, creating it and deleting it when done.
Thanks
Steve Buehler
At 02:19 PM 4/8/2002, you wrote:
>Yes a TEMPORARY TABLE is specific to
16 matches
Mail list logo