; on query 'CREATE
TEMPORARY TABLE book_continue_target_data SELECT t1.***, t2.id AS ***,
t2.* , t2.*** AS last_day FROM *** AS t1, *** AS t2, service AS t3
WHERE (DATE_FORMAT(t2.***, "%Y-%m-%d") BETWEEN '2004-10-21' AND
'2004-10-25') AND t1.id=t2.*** AND t2.service_i
Speaking of the --read-only option, I don't suppose there's
any way to run --read-only but allow CREATE TEMPORARY TABLE,
is there? We run several reports against a slave server
which require temporary tables for speed, and have had a
problem with the occasional accidental write to the
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
nct(myData) from myTable -> 1411000
I presume there's a typo here: count(*) should have returned a
larger number than distinct(myData), not smaller.
> So I created a temporary table to store distinct records and want to do a
> join with original table to see what records are duplicates.
&g
, 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
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]
to do a
join with original table to see what records are duplicates.
Create Temporary Table A
Select distinct(mydata),rowID from myTable;
When I run this it says that the temp table has only 1000 rows. Why?
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web techno
On Friday 11 June 2004 06:59 pm, Robert Paulsen wrote:
> I must be missing something about "create temporary table". Here are two
> sql commands. The first works the second fails:
>
> CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data
> varc
I must be missing something about "create temporary table". Here are two sql
commands. The first works the second fails:
CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data
varchar(255), PRIMARY KEY (id) );
CREATE TEMPORARY TABLE mytable2 (id int(10
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:
I am trying to create a temporary table through code in my DB. I can do
it when I use MySQL Control Center or something like that, but when I
try to do it through my VB program it doesn't work.
Here is the sql string:
CREATE TEMPORARY TABLE IndenturedList (Level_1 TEXT, Level_2
experience the problem at all even though he's using
4.0.13 on 2000/XP.
- Original Message -
From: "Russell R Snella" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 5:57 PM
Subject: Create Temporary Table
> Hello,
>
> Mysql Version
Hello,
Mysql Version 4.0.11a-gamma
When I try and run the following query
create temporary table russ1 as
select rcust.*
from rcust;
and I receive the error message:
Error Code : 1044
Access denied for user: '[EMAIL PROTECTED]' to database 'customer'
(0 ms take
> > 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 << "
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 <<
grading to v4.0.13 the "CREATE
TEMPORARY TABLE " part is failing with this error:
Access denied for user: '@localhost' to database 'uclan_database'
Any ideas?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t; <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 06, 2003 2:29 am
Subject: Re: [PHP-DB] Create Temporary Table
> Does the ip address of where you are trying to access the mysql database
>
;s the only reason I can think for intermittent problems.
Cheers,
~Steve
Phil Dowson wrote:
Hi,
PHP Version 4.3.1
Mysql Version 4.0.13
When I try and run the following query
CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable;
on each database, the first one will run it with no problem
Hi,
PHP Version 4.3.1
Mysql Version 4.0.13
When I try and run the following query
CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable;
on each database, the first one will run it with no problems at all. The
second returns the error:
[server] ERROR 1044: Access denied for user
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
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.mysql.com/mysql
To unsubscribe:http://lists.m
It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE
statements from the log bin.
Because such statements are really used not for updating a DB, but for
constructing intermediary statements that eventually derive in a final
INSERT/ UPDATE. I believe only this final statement
Alec,
Saturday, October 05, 2002, 5:14:59 PM, you wrote:
>>Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a
>> global level privilege:
>> http://www.mysql.com/doc/en/News-4.0.2.html
AdCaQdC> Thank you. That page says that "To use these, you must have run the
AdCaQdC> my
Victoria Reznichenko said:
>Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a
> global level privilege:
> http://www.mysql.com/doc/en/News-4.0.2.html
Thank you. That page says that "To use these, you must have run the
mysql_fix_privilege_tables script after upgrading."
----+
>AdCaQdC> 2 rows in set (0.00 sec)
>
>AdCaQdC> mysql> use alec ;
>AdCaQdC> Database changed
>AdCaQdC> mysql> create table perm (col int) ;
>AdCaQdC> Query OK, 0 rows affected (0.02 sec)
>
>AdCaQdC> mysql> create temporary table temp (col int
'.* TO 'alec'@'%' |
AdCaQdC> | GRANT ALL PRIVILEGES ON 'alec'.* TO 'alec'@'%' |
AdCaQdC> ++
AdCaQdC> 2 rows in set (0.00 sec)
AdCaQdC> mysql> use alec ;
AdCaQdC> Database changed
AdCaQdC> mysql> create table perm (
---+
| GRANT ALL PRIVILEGES ON 'test'.* TO 'alec'@'%' |
| GRANT ALL PRIVILEGES ON 'alec'.* TO 'alec'@'%' |
++
2 rows in set (0.00 sec)
mysql> use alec ;
Database changed
mysql
Hi,
There is a bug in GRANT for CREATE TEMPORARY TABLE privilege which is fixed
now in the 4.0.3 tree.
Regards,
Jocelyn
- Original Message -
From: "Philip Mak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 7:38 PM
Subject: How to
>I can't get CREATE TEMPORARY TABLE to work due to a privilege problem.
Run the mysql_fix_privilege_tables script. There are new privileges
in 4.0.2, one of which applies to temporary tables.
>Does anyone know what I'm doing wrong?
>
>mysql> update user set create_tmp_
I can't get CREATE TEMPORARY TABLE to work due to a privilege problem.
Does anyone know what I'm doing wrong?
mysql> update user set create_tmp_table_priv='Y';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges;
Query
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
0 PM
>To: mysql
>Subject: CREATE TEMPORARY TABLE
>
>
> 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 "CR
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 table_name" and more than one person hits
I use the following for creating a temporary table:
CREATE TEMPORARY TABLE IF NOT EXISTS tbl SELECT ...
This query may be run multiple times by the same client connection since
it's part of a Web application. The problem is that if 'tbl' *does* exist,
the select command is exe
ler [EMAIL PROTECTED]
Software DevelopmentFive Elements, Inc
http://www.five-elements.com/~jsw/
mysql> CREATE TABLE language_en (id INT NOT NULL);
Query OK, 0 rows affected (0.04 sec)
mysql> CREATE TEMPORARY TABLE language (id INT NOT NULL) TYPE=MERGE
UNION=(langu
40 matches
Mail list logo
