Create temporary table

------=_NextPart_000_002B_01C5614F.29455F10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello..

I am beginner in mysql and i am using version 4.1 for windows.

I have many problems to create temporary tables.

Already run SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql to =
give privileges to user, and reinitiate the service at win2000.

Do not erros in create temporary table command, but the table do not =
created.

Can somebody help - me ?

Sorry vocabulary=20

Regards

Ezequiel Marin
GVM - Inform=E1tica S/S LTDA
Brazil / S=E3o Paulo / Ja=FA
(14)-3621-7111
www.gvmsistemas.com.br
suporte@gvmsistemas.com.br
------=_NextPart_000_002B_01C5614F.29455F10--

RE: Create temporary table

We will need more details to help you.

How are you submitting the command to create the table?

What is the exact CREATE TABLE statement you have submitted?

How do you know the table has not been created?

What does SHOW TABLES give you?

John Bonnett

-----Original Message-----
From: GVM - UOL [mailto:gvm.jau@uol.com.br]=20
Sent: Thursday, 26 May 2005 5:58 AM
To: win32@lists.mysql.com
Subject: Create temporary table

Hello..

I am beginner in mysql and i am using version 4.1 for windows.

I have many problems to create temporary tables.

Already run SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql to =
give privileges to user, and reinitiate the service at win2000.

Do not erros in create temporary table command, but the table do not =
created.

Can somebody help - me ?

Sorry vocabulary=20

Regards

Ezequiel Marin
GVM - Inform=E1tica S/S LTDA
Brazil / S=E3o Paulo / Ja=FA
(14)-3621-7111
www.gvmsistemas.com.br
suporte@gvmsistemas.com.br

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Create temporary table

Thanks John Bonnett

I found error..

The problem was in the Mysql Query Browser what doesnt show table created
temporary !!

Using mysql console, all work perfectely. I not understandy what happend,
but i can to go head.

Do you know if Query Browser have some bugs ?

Thanks a lot for your attention

Regards

Ezequiel Marin


----- Original Message -----
From:
To: ;
Sent: Sunday, May 29, 2005 7:33 PM
Subject: RE: Create temporary table


We will need more details to help you.

How are you submitting the command to create the table?

What is the exact CREATE TABLE statement you have submitted?

How do you know the table has not been created?

What does SHOW TABLES give you?

John Bonnett

-----Original Message-----
From: GVM - UOL [mailto:gvm.jau@uol.com.br]
Sent: Thursday, 26 May 2005 5:58 AM
To: win32@lists.mysql.com
Subject: Create temporary table

Hello..

I am beginner in mysql and i am using version 4.1 for windows.

I have many problems to create temporary tables.

Already run SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql to give
privileges to user, and reinitiate the service at win2000.

Do not erros in create temporary table command, but the table do not
created.

Can somebody help - me ?

Sorry vocabulary

Regards

Ezequiel Marin
GVM - Informática S/S LTDA
Brazil / São Paulo / Jaú
(14)-3621-7111
www.gvmsistemas.com.br
suporte@gvmsistemas.com.br



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Create temporary table

I think the only question is that the displays do not automatically =
refresh so you do not see tables as soon as they are created. They =
probably need a "Refresh" button.

John

-----Original Message-----
From: GVM - UOL [mailto:gvm.jau@uol.com.br]=20
Sent: Monday, 30 May 2005 9:18 PM
To: John Bonnett, R&D Australia
Cc: win32@lists.mysql.com
Subject: Re: Create temporary table

Thanks John Bonnett

I found error..

The problem was in the Mysql Query Browser what doesnt show table =
created
temporary !!

Using mysql console, all work perfectely. I not understandy what =
happend,
but i can to go head.

Do you know if Query Browser have some bugs ?

Thanks a lot for your attention

Regards

Ezequiel Marin


----- Original Message -----=20
From:
To: ;
Sent: Sunday, May 29, 2005 7:33 PM
Subject: RE: Create temporary table


We will need more details to help you.

How are you submitting the command to create the table?

What is the exact CREATE TABLE statement you have submitted?

How do you know the table has not been created?

What does SHOW TABLES give you?

John Bonnett

-----Original Message-----
From: GVM - UOL [mailto:gvm.jau@uol.com.br]
Sent: Thursday, 26 May 2005 5:58 AM
To: win32@lists.mysql.com
Subject: Create temporary table

Hello..

I am beginner in mysql and i am using version 4.1 for windows.

I have many problems to create temporary tables.

Already run SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql to =
give
privileges to user, and reinitiate the service at win2000.

Do not erros in create temporary table command, but the table do not
created.

Can somebody help - me ?

Sorry vocabulary

Regards

Ezequiel Marin
GVM - Inform=E1tica S/S LTDA
Brazil / S=E3o Paulo / Ja=FA
(14)-3621-7111
www.gvmsistemas.com.br
suporte@gvmsistemas.com.br



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Create temporary table

In the Query Browser if you right click on a database in the Schemata =
window and choose Refresh, it should show you all the tables, including =
any you have just created in that database.

-----Original Message-----
From: GVM - UOL [mailto:gvm.jau@uol.com.br]=20
Sent: Monday, 30 May 2005 9:18 PM
To: John Bonnett, R&D Australia
Cc: win32@lists.mysql.com
Subject: Re: Create temporary table

Thanks John Bonnett

I found error..

The problem was in the Mysql Query Browser what doesnt show table =
created
temporary !!

Using mysql console, all work perfectely. I not understandy what =
happend,
but i can to go head.

Do you know if Query Browser have some bugs ?

Thanks a lot for your attention

Regards

Ezequiel Marin


----- Original Message -----=20
From:
To: ;
Sent: Sunday, May 29, 2005 7:33 PM
Subject: RE: Create temporary table


We will need more details to help you.

How are you submitting the command to create the table?

What is the exact CREATE TABLE statement you have submitted?

How do you know the table has not been created?

What does SHOW TABLES give you?

John Bonnett

-----Original Message-----
From: GVM - UOL [mailto:gvm.jau@uol.com.br]
Sent: Thursday, 26 May 2005 5:58 AM
To: win32@lists.mysql.com
Subject: Create temporary table

Hello..

I am beginner in mysql and i am using version 4.1 for windows.

I have many problems to create temporary tables.

Already run SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql to =
give
privileges to user, and reinitiate the service at win2000.

Do not erros in create temporary table command, but the table do not
created.

Can somebody help - me ?

Sorry vocabulary

Regards

Ezequiel Marin
GVM - Inform=E1tica S/S LTDA
Brazil / S=E3o Paulo / Ja=FA
(14)-3621-7111
www.gvmsistemas.com.br
suporte@gvmsistemas.com.br



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Create temporary table

--=_alternative 0051704B85257013_=
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

I don't think that MySQL Query Browser (QB) is broken. Temporary tables=20
are only visible to the connection that creates them. Were you using MySQL =

Query Browser to create a temporary table and then looking for that table=20
*using the same connection* ? If QB had opened a connection, created some =

temporary tables, and returned control to you (possibly closing the=20
connection) then the temporary tables would have gone away. I am not 100%=20
certain that QB creates connections on an as-needed basis, but my=20
recollection is that it does.

In contrast, when you connect with the console (CLI), you open a=20
connection and keep it open. The connection will only die if you=20
intentionally disconnect or close the client or kill a thread from the=20
server. Until one of those events happen, any temporary tables you create=20
(or variables you define) will exist and continue to exist until you lose=20
that connection. You can easily see this in action. Open TWO console=20
window and log into the same server, twice. Use one window to create a=20
temporary table and declare a variable like this:

SET @testvalue =3D 'canyouseeme';

CREATE TEMPORARY TABLE tmpUsers
SELECT * from mysql.user;

Then in both windows, test the results:

SELECT @testvalue;
SELECT * FROM tmpUsers;

In the original CLI session, both values will return with no problem. In=20
the second, you will get a NULL value and an error. You may also be able=20
to perform a SHOW TABLES in the first window and see your temporary table. =

It definitely WILL NOT be listed in the second window.

The opposite effect can occur if you share connections between threads.=20
Assume for a second that you are using a "pooling" connection provider=20
(like ODBC) to connect an application (like a web site) to a MySQL=20
database. The pool manager (part of most ODBC installations) will open as=20
many connections as its client applications need in order for each thread=20
to make the connections they need. If there are 3 threads all needing or=20
using their own connection at the exact same time, the pool will contain 3 =

connection objects. As each thread "turns in" their connection (by=20
attempting to close the connection) the pool says "thank you" and pretends =

to close the connection.=20

What actually happens is that the pool manager keeps the thread open in an =

idle state for some period of time. If no other thread needs that=20
particular connection before the end of the time-out (and if the pool=20
manager has not been instructed to keep some minimum number of connections =

open at all times) then the pool manager closes the connection with the=20
database server. The side effect of this is that your application may=20
"inherit" a connection where some values are already set and some=20
temporary tables still exist (because the thread that used that connection =

before didn't clean up after itself). This is almost the opposite=20
behavior that you describe from QB but you may run into it as well (same=20
objects appearing on different threads) depending on how you connect to=20
your MySQL server.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine



"GVM - UOL" wrote on 05/30/2005 08:47:54 AM:

> Thanks John Bonnett
>=20
> I found error..
>=20
> The problem was in the Mysql Query Browser what doesnt show table=20
created
> temporary !!
>=20
> Using mysql console, all work perfectely. I not understandy what=20
happend,
> but i can to go head.
>=20
> Do you know if Query Browser have some bugs ?
>=20
> Thanks a lot for your attention
>=20
> Regards
>=20
> Ezequiel Marin
>=20
>=20
> ----- Original Message -----=20
> From:
> To: ;
> Sent: Sunday, May 29, 2005 7:33 PM
> Subject: RE: Create temporary table
>=20
>=20
> We will need more details to help you.
>=20
> How are you submitting the command to create the table?
>=20
> What is the exact CREATE TABLE statement you have submitted?
>=20
> How do you know the table has not been created?
>=20
> What does SHOW TABLES give you?
>=20
> John Bonnett
>=20
> -----Original Message-----
> From: GVM - UOL [mailto:gvm.jau@uol.com.br]
> Sent: Thursday, 26 May 2005 5:58 AM
> To: win32@lists.mysql.com
> Subject: Create temporary table
>=20
> Hello..
>=20
> I am beginner in mysql and i am using version 4.1 for windows.
>=20
> I have many problems to create temporary tables.
>=20
> Already run SOURCE C:\mysql\scripts\mysql=5Ffix=5Fprivilege=5Ftables.sql =
to=20
give
> privileges to user, and reinitiate the service at win2000.
>=20
> Do not erros in create temporary table command, but the table do not
> created.
>=20
> Can somebody help - me ?
>=20
> Sorry vocabulary
>=20
> Regards
>=20
> Ezequiel Marin
> GVM - Inform=E1tica S/S LTDA
> Brazil / S=E3o Paulo / Ja=FA
> (14)-3621-7111
> www.gvmsistemas.com.br
> suporte@gvmsistemas.com.br
>=20
>=20
>=20
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Dsgreen@unimin.com
>=20

--=_alternative 0051704B85257013_=--

Re: Create temporary table

Query Browser and the Administrator make use of two connections, one
of them is the interactive that keeps open till you close the program,
and another connection is used to send queries to the server, closing
right after it, so, Shawn is right, you can't see the temporary table
for two reasons:

1) The connection that created it was closed and the table no longer exists=
..
2) The Query Browser is using another connection to give you the table
list, so, it can't see your temp table anyway.

Best regards,

On 6/1/05, SGreen@unimin.com wrote:
> I don't think that MySQL Query Browser (QB) is broken. Temporary tables
> are only visible to the connection that creates them. Were you using MySQ=
L
> Query Browser to create a temporary table and then looking for that table
> *using the same connection* ? If QB had opened a connection, created som=
e
> temporary tables, and returned control to you (possibly closing the
> connection) then the temporary tables would have gone away. I am not 100%
> certain that QB creates connections on an as-needed basis, but my
> recollection is that it does.
>=20
> In contrast, when you connect with the console (CLI), you open a
> connection and keep it open. The connection will only die if you
> intentionally disconnect or close the client or kill a thread from the
> server. Until one of those events happen, any temporary tables you create
> (or variables you define) will exist and continue to exist until you lose
> that connection. You can easily see this in action. Open TWO console
> window and log into the same server, twice. Use one window to create a
> temporary table and declare a variable like this:
>=20
> SET @testvalue =3D 'canyouseeme';
>=20
> CREATE TEMPORARY TABLE tmpUsers
> SELECT * from mysql.user;
>=20
> Then in both windows, test the results:
>=20
> SELECT @testvalue;
> SELECT * FROM tmpUsers;
>=20
> In the original CLI session, both values will return with no problem. In
> the second, you will get a NULL value and an error. You may also be able
> to perform a SHOW TABLES in the first window and see your temporary table=
..
> It definitely WILL NOT be listed in the second window.
>=20
> The opposite effect can occur if you share connections between threads.
> Assume for a second that you are using a "pooling" connection provider
> (like ODBC) to connect an application (like a web site) to a MySQL
> database. The pool manager (part of most ODBC installations) will open as
> many connections as its client applications need in order for each thread
> to make the connections they need. If there are 3 threads all needing or
> using their own connection at the exact same time, the pool will contain =
3
> connection objects. As each thread "turns in" their connection (by
> attempting to close the connection) the pool says "thank you" and pretend=
s
> to close the connection.
>=20
> What actually happens is that the pool manager keeps the thread open in a=
n
> idle state for some period of time. If no other thread needs that
> particular connection before the end of the time-out (and if the pool
> manager has not been instructed to keep some minimum number of connection=
s
> open at all times) then the pool manager closes the connection with the
> database server. The side effect of this is that your application may
> "inherit" a connection where some values are already set and some
> temporary tables still exist (because the thread that used that connectio=
n
> before didn't clean up after itself). This is almost the opposite
> behavior that you describe from QB but you may run into it as well (same
> objects appearing on different threads) depending on how you connect to
> your MySQL server.
>=20
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>=20
>=20
>=20
> "GVM - UOL" wrote on 05/30/2005 08:47:54 AM:
>=20
> > Thanks John Bonnett
> >
> > I found error..
> >
> > The problem was in the Mysql Query Browser what doesnt show table
> created
> > temporary !!
> >
> > Using mysql console, all work perfectely. I not understandy what
> happend,
> > but i can to go head.
> >
> > Do you know if Query Browser have some bugs ?
> >
> > Thanks a lot for your attention
> >
> > Regards
> >
> > Ezequiel Marin
> >
> >
> > ----- Original Message -----
> > From:
> > To: ;
> > Sent: Sunday, May 29, 2005 7:33 PM
> > Subject: RE: Create temporary table
> >
> >
> > We will need more details to help you.
> >
> > How are you submitting the command to create the table?
> >
> > What is the exact CREATE TABLE statement you have submitted?
> >
> > How do you know the table has not been created?
> >
> > What does SHOW TABLES give you?
> >
> > John Bonnett
> >
> > -----Original Message-----
> > From: GVM - UOL [mailto:gvm.jau@uol.com.br]
> > Sent: Thursday, 26 May 2005 5:58 AM
> > To: win32@lists.mysql.com
> > Subject: Create temporary table
> >
> > Hello..
> >
> > I am beginner in mysql and i am using version 4.1 for windows.
> >
> > I have many problems to create temporary tables.
> >
> > Already run SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql to
> give
> > privileges to user, and reinitiate the service at win2000.
> >
> > Do not erros in create temporary table command, but the table do not
> > created.
> >
> > Can somebody help - me ?
> >
> > Sorry vocabulary
> >
> > Regards
> >
> > Ezequiel Marin
> > GVM - Inform=E1tica S/S LTDA
> > Brazil / S=E3o Paulo / Ja=FA
> > (14)-3621-7111
> > www.gvmsistemas.com.br
> > suporte@gvmsistemas.com.br
> >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe: http://lists.mysql.com/win32?unsub=3Dsgreen@unimin.c=
om
> >
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org