Hi, may be my english is poor, sorry for this.
I'll be trying with odbc 3.51 and sp on 5.0 that returns out params and didn't
work (at least for me). In parameters works fine.
From mysql client command line out parameters works fine.
The sp makes about 50 selects, this increase a lot the traffic
matt on Thursday, July 15, 2004, 11:58:31 AM, wrote:
>>Consider replicating to some slave servers and dividing reads among them.
mr> I already replicate to slaves, and sites will do read only queries off
mr> these slaves
mr> 99.9 % of the tables are read only anyway, the only tables we update o
I'll be trying to make a SP on 5.0 that returns values through odbc but
it doesn't work, mysql client works fine; there is a limitation or
odbc not support return values yet?
ODBC Version 3.51.06
--
Greetings, Alejandro
mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives
A heap table isn't a view, it's just a table in memory, when you stop mysql the table disappear. Are usefull for speed selects; you don't need access hd.
In the other hand views are definitions from other(s) table(s) stored in the db, are permanent and can be updated
Alejandro.
--
Vinay, u can create a temporary table
CREATE TEMPORARY TABLE TMP
Select * from ORIGINAL WHERE 'records to preserve';
TRUNCATE TABLE ORIGINAL;
INSERT INTO ORIGINAL SELECT * FROM TMP;
DROP TABLE TMP;
Alejandro.
---Mensaje original---
De: Vinay
Fecha: 06/02/04 08:32:
ECTED]
Asunto: Re: Problem creating sp
"adburne" <[EMAIL PROTECTED]> wrote:
> I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the
> mysql's page example to test but makes an error:
>
> mysql> delimeter |
I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the
mysql's page example to test but makes an error:
mysql> delimeter |
-> create function hello (s char(20)) returns char(50)
-> return concat('Hello, ',s,'!');
ERROR 1064 (42000): You have an error in your SQL syntax.
Someone can give me a hand with this:
I'll be fighting with rights over tmp tables time ago, basically I want give
full temporary tables management but not for other all tables, including
select right.
The only way to do that work was insert in tables_priv for each user a
user/tmp_table_name" r
Where can I find scripts or documentation to make SPs?
Thnx! Alejandro
---Mensaje original---
De: [EMAIL PROTECTED]
Fecha: miércoles 24 de diciembre de 2003 05:10:36
A: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Asunto: MySQL 5.0.0 has been released
Hi,
MyS
ALUES ('host.localdomain','db1','user1','TMP_Liq', USER(), 'Select,Insert,Update,Delete,Alter,Drop,Index','')
and this work!
Alejandro
---Mensaje original---
De: Matt W
Fecha: sábado 13 de diciembre de 2003 22:36:54
A: adburne
Hi, I'm granting users to use temporary tables as:
GRANT CREATE TEMPORARY TABLES ON db1.* TO user1;
and having grants on many other tables as:
GRANT SELECT, INSERT, UPDATE, DELETE ON db1.table1 TO user1;
GRANT SELECT, INSERT, UPDATE, DELETE ON db1.table2 TO user1;
but how make t
de 2003 18:41:48
A: adburne; [EMAIL PROTECTED]
Asunto: Re: Execute shell script
At 14:05 -0600 11/18/03, Paul DuBois wrote:
>At 4:47 PM -0300 11/18/03, adburne wrote:
>>There is a command or function to call a shell script through mysql?
>
>Invoke mysql, then issue a \h command
Right, I've a linux box running apache and another running mysql both on my private lan and I want to connect from internet through a firewall, to do that I'm using nat and forward with iptables.
First I try setup it for apache (just for test) and things go right, all it's ok; but with mysq
There is a command or function to call a shell script through mysql?
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Someone can make nat with mysql? I can do it with apache without problems, but mysql client freeze trying to connect.
Thanx, Alejandro.
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
15 matches
Mail list logo
