Here’s an email from a good friend of mine that may be of interest. It is done
in Ruby.
From: Brad Robel-Forrest [mailto:b...@gigglewax.com]
Sent: Sunday, May 15, 2011 7:01 PM
To: Daevid Vincent
Subject: MySQL shell...with parameters
Remember a long while back I was bitching about the need
Hi,
I'm finding the description of character_set_connection unclear. Does
this influence the encoding of queries, but not of results? I'm
wondering about the effect of connection encoding.
Is there documentation on how exactly character set settings affect
BLOBs? For example, "this is what
led documentation on the possible
> parameters? I am doing a quick google and can't find it.
>
>
>
> Thanks!
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=mart...@crys
Is there a place on the net that has detailed documentation on the possible
parameters? I am doing a quick google and can't find it.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi,
> Please check:
> http://bugs.mysql.com/bug.php?id=33455
>
> That bug has been closed because it has been fixed in version 6.x
Thanks but - to MySQL - no thanks. In version 6? This is a bug that should
have been taken care of as soon as the INFORMATION_SCHEMA got
release... :-(
Once more, a
.
Regards,
Santo Leto.
--
From: "Martijn Tonies" <[EMAIL PROTECTED]>
Sent: Friday, November 07, 2008 2:23 PM
To:
Subject: Stored Routines, INFORMATION_SCHEMA and parameters
Hi,
Is it possible to get info about stored routine pa
Hi,
Is it possible to get info about stored routine parameters via the
INFORMATION_SCHEMA views? From checking the docs
and the schema, I cannot find anything related to parameters.
How should you get this info if you don't have access to the
"mysql.procs" table?
Martijn
I don't know whether I got your mean or not.
I advise that you should take a look at this url.
http://www.day32.com/MySQL/
On Sun, Jun 22, 2008 at 12:41 AM, Atle Veka <[EMAIL PROTECTED]> wrote:
> I don't think anyone answered your actual question, so here's my attempt..
>
> http://dev.mysql.com
I don't think anyone answered your actual question, so here's my attempt..
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html
"Many status variables are reset to 0 by the FLUSH STATUS
statement."
Atle
On Fri, 20 Jun 2008, Venu Madhav Padakanti wrote:
I am us
I would also add Baron's maakit http://www.maatkit.org/ ( innotop ) for
innodb details to the arsenal.
On Fri, Jun 20, 2008 at 3:11 PM, Ian Simpson <[EMAIL PROTECTED]> wrote:
> I tend to use the 'mytop' program, which shows the average
> queries/second for the entire lifetime and for the last 5
I tend to use the 'mytop' program, which shows the average
queries/second for the entire lifetime and for the last 5 seconds, as
well as showing a bunch of other statistics and a list of running
queries. It's a handy little monitoring tool.
On Fri, 2008-06-20 at 12:17 +0530, Venu Madhav Padakanti
if using innodb do
show innodb status\G.
Here u will see real time insert,delete,update and selects.
On 6/20/08, Venu Madhav Padakanti <[EMAIL PROTECTED]> wrote:
>
>
> I am using MySQL version 5.0.22, I am interested in knowing the current
> performance on the MySQL.
>
> With the status comman
I am using MySQL version 5.0.22, I am interested in knowing the current
performance on the MySQL.
With the status command we can get the queries per second but it will
average since the beginning of time when SQL was up and running and not
the current rate?
Is there any way to reset that p
Hi All,
We are setting up a new db with myisam storage engine.
Its runing on debain, with 8 CPU, 8 GB RAM.
Can you please let me know what all parameters i need to setup for only
myisam storage engine and also their values for better performance.
regards
anandkl
On 6/20/07, Andrey Kumykov <[EMAIL PROTECTED]> wrote:
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is: mysql> show variables;
Native
./configure --..., ...
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is: mysql> show variables;
Native
./configure --..., ...
-- Forwarded Message --
Subject: Re: How to know configure parameters on compiled MySQL
Date: Monday 18 June 2007
From: David Southwell <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
> Hello,all.
> There is
Hello,all.
There is the function "phpinfo" in the PHP interpreter, which allows to know
configure options.
Is there analog ability in Mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Paul,
I've spent the past two days trying to reproduce my problem and I think
I may have brought this on myself. I've had been trying to create a
procedure with the Query Browser GUI and was unable to do so. So I tried
to create them with MySQL-Front and MySQL Control Center and somehow I
was
At 11:34 AM -0800 12/1/06, Chris White wrote:
On Friday 01 December 2006 11:22, Ed Reed wrote:
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create Procedu
Got it.
Thanks
>>> Chris White <[EMAIL PROTECTED]> 12/1/06 11:34 AM >>>
On Friday 01 December 2006 11:22, Ed Reed wrote:
> I have a problem/question I'd like to find someone else to
verify/answer
> for me.
>
> I'm using MySQL 5.1.09 running on Netware. I've created a stored
> procedure that has
On Friday 01 December 2006 11:22, Ed Reed wrote:
> I have a problem/question I'd like to find someone else to verify/answer
> for me.
>
> I'm using MySQL 5.1.09 running on Netware. I've created a stored
> procedure that has one parameter,
>
> Create Procedure MyTest(strVal VarChar)
> Begin
> Selec
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create Procedure MyTest(strVal VarChar)
Begin
Select Field1, Field2, Field3 From MyTable
Where Field3=strVal;
En
How do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I've got the following Stored Procedure defined in my database:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo Va
How do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I've got the following Stored Procedure defined in my database:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo V
Ravi Malghan wrote:
Hi: I have a statement such as follows
SELECT EVENT_DATA.dstport WHERE
FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
Instead of using a value of 1 for interval, I want to
pass parameters so it will ask for the value wh
--- Ravi Malghan <[EMAIL PROTECTED]> wrote:
> Hi: I have a statement such as follows
>
> SELECT EVENT_DATA.dstport WHERE
> FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
> INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
>
> Instead of using a value of 1 for int
Hi: I have a statement such as follows
SELECT EVENT_DATA.dstport WHERE
FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
Instead of using a value of 1 for interval, I want to
pass parameters so it will ask for the value when the
sql statement
Hi,
When I use the MySQL Migration Toolkit to transfer a Database from one
Mysql server to another, the table parameters configured do not seem to
be transferred as well. Fields specified as Primary keys that
autoincrement do not autoincrement in the transferred database and
fields set as null
The interface includes the feature of making multiple executions of prepared
statements, binding the parameters to different values before each execution.
In the Oracle code, obndra() was used to bind the parameters, and I have
replaced this with mysql_stmt_bind_param().
However, I noticed that
t is all my databases except mysql are of innoDB type.
In such circumstances the question is if default myISAM settings affect
performance of database - are they only maximal values dynamically
allocated or inflexible parameters (what would mean that every
connection is net_buffer + thread_stack +
Gleb Paharenko wrote:
Hello.
Use skip-innodb, this should prevent MySQL from InnoDB initialization.
Remigiusz Soko$owski <[EMAIL PROTECTED]> wrote:
Hello!
Do You know if myISAM-specific settings have any impact on database
performance,
if the only MyISAM database is mysql?
I know that ther
Hello.
Use skip-innodb, this should prevent MySQL from InnoDB initialization.
Remigiusz Soko$owski <[EMAIL PROTECTED]> wrote:
> Hello!
> Do You know if myISAM-specific settings have any impact on database
> performance,
> if the only MyISAM database is mysql?
> I know that there are som
Hello!
Do You know if myISAM-specific settings have any impact on database
performance,
if the only MyISAM database is mysql?
I know that there are some default settings and I wonder if for example
memory buffers are allocated even if they are not used? Is it necessary
to disable those setting
hi,
look at insert buffer and buffer pool. This is quite interesting :
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/InnoDB_Insert_buffering.html
mathias
Selon Manoj <[EMAIL PROTECTED]>:
> Dear All,
> I am trying to tweak some server parameters to fine tune my MyS
Dear All,
I am trying to tweak some server parameters to fine tune my MySQL
(4.0.15) server on a linux box (with 6GB of ram)
All my tables/databases use InnoDB. My question is : What is the InnoDB
equivalent of the server parameters "Key_read_request & key_reads". I
had
Hello.
You may use something like:
prepare stmtl from 'select * from ren1 where yo like concat("%",?,"%")';
set @a='1';
execute stmtl using @a;
Nathan Coast <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to modi
Hi,
Is it possible to modify parameters passed to prepared statements?
e.g.
select ...
where username like '%?%'
I'd like to put wildcard chars '%' on either end of a parameter. Is
this legal? or do I have to modify the parameter before passing it to
mysql.
than
Hi,
I'm having serious trouble getting prepared statements with bound parameters
in the where clause to work over the C API with MySQL 4.1.3. The Bugtracker on
mysql.com has similar bugs for 4.1.2, which are marked as closed and fixed in
4.1.3 so I wanted to make sure that I'm do
hello list,
i have high performance dell server. i want to
increase Read_Buffer_Size server variable to 5 MB.
i have found docs on this in mysql site. like this
mysqld_safe --key_buffer_size=64M --table_cache=256 \
--sort_buffer_size=4M --read_buffer_size=1M
&
where i type that
Hi all,
It is better i got the settings for *BitKeeper Wizard*
parameters. Becaz when i run it shows parameters and i
select one out of them as;
description : MySQL Source
category : development/building
email: [EMAIL PROTECTED]
name : Arun
street :
city
To make it simple, is it possible to make function having many undecided parameters
with MySQL 5.0 stored procedure/function?
For example,
add(3)
add(3,5)
add(3,5,1,4,9)
add(3,5,1,4,9,8,6,7,2)
In C, we use pointer to handle this,
but I don't know how to code this at stored function C
To make it simple, is it possible to make function having many undecided parameters
with MySQL 5.0 stored procedure/function?
For example,
add(3)
add(3,5)
add(3,5,1,4,9)
add(3,5,1,4,9,8,6,7,2)
In C, we use pointer to handle this,
but I don't know how to code this at stored function C
"Prasad Budim Ram" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> If this possible in MYSQL (capability of procedure with
> parameterized parameters).
>
> Assume a procedure with parameters a1,a2,a3
>
> test(a1,a2,a3)
> begin
> .
> .
Hi,
If this possible in MYSQL (capability of procedure with
parameterized parameters).
Assume a procedure with parameters a1,a2,a3
test(a1,a2,a3)
begin
.
.
end
Can I call the procedure test by following way
call test(a2 = 5, a1 = 4, a3 = 7);
i.e changing the
Are you sure you want to add two strings together? That's a math
operation, and you'll just get zero. You probably want
WHERE last_name LIKE concat(?, "%")
or WHERE last_name LIKE ?
, and make sure the string you're passing in has a % at the end.
Note that only MySQL
I need to use this sentence with parameter but I couln't have which is the symbol that
is equal to parameter.
For instance: SELECT * FROM EMPLOYEES WHERE last_name LIKE ? + "%"
? means parameter
This sentence is right in SQL and also you can use in Access or SQL SERVER but MySql
say there is
MySQL List,
MySQL was working fine until today. I hadn't used it for a
month or so but now, I try to restart the MySQL Daemon and I get this
error:
030331 12:32:27 mysqld started
/usr/local/mysql/mysql-3.23.55-max/bin/mysqld: Too many parameters
/usr/local/mysql/mysql-3.23.55-ma
SQL_SUCCESS.
Instead, SQL_NEED_DATA is returned and the returned pointer shows to the
second parameter (which i bound NOT with DATA_AT_EXEC)!
I browsed the ODBC documentation and found no restriction which forbids the
mix of binding parameters directly and with data at execution time.
Only restriction
aul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 6:26 PM
To: David Rock; [EMAIL PROTECTED]
Subject: RE: PHP4 Secure connection parameters
At 16:52 -0700 1/11/03, David Rock wrote:
>Show variables says have_openssl = NO for the binary version. I compiled
>and installed t
hen I start the server, just no SSL
support. I'm hoping someone can throw some thoughts out here.
Thanks,
David
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 12:07 PM
To: David Rock; [EMAIL PROTECTED]
Subject: Re: PHP4 Secure conn
he server, just no SSL
support. I'm hoping someone can throw some thoughts out here.
Thanks,
David
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 12:07 PM
To: David Rock; [EMAIL PROTECTED]
Subject: Re: PHP4 Secure connection parameters
27;t it already "SSL ready"? Where do I add the --with-vio
--with-openssl parameters and does --with-openssl need a path also? What
should it point to? Any help appreciated.
--with-vio and --with-openssl are for configuring from source. If you
installed a -max server from a binar
Where do I add the --with-vio
--with-openssl parameters and does --with-openssl need a path also? What
should it point to? Any help appreciated.
Thanks,
David Rock
-
Before posting, please check:
http://www.mysql.com/man
I sent a previous question about having problems with SQL statements
using parameters not working in MySQL when they worked in Access. I am
using the ODBC driver and ADO and have had no problems at all to date.
Upon some further research the problem seems limited to SELECT
statements
On Fri, 15 Nov 2002, Joseph D. Wagner wrote:
> OK OK! You've proved me wrong IN THIS PARTICULAR EXAMPLE. The fact
> remains that plenty other examples exist where MySQL could benefit from
> the .NET Framework.
>
> WILL MYSQL BE USING THE MICROSOFT .NET FRAMEWORK IN FUTURE DEVELOPMENT
> OF THE WIN
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Friday, November 15, 2002 12:56 PM
To: Joseph D. Wagner; 'MySQL'; [EMAIL PROTECTED]
Subject: Re: Offer to Help MySQL Win32 Port -- Passing Command
Parameters
Hi,
Apropos by VB or VB.NET
If you use WIN32 API(RegOpenKey,RegCreateK
: MySQL-List
Subject: parameters?
I'm a newbie to MySql / Php and heres what i'm trying to accomplish:
I have a set of hard coded links that each have a sql parameter value like
below:
http://www.foo.com/agent_result.php3?$agent_id=9805";>My Link
Text
I'm trying to pass that pa
I'm a newbie to MySql / Php and heres what i'm trying to accomplish:
I have a set of hard coded links that each have a sql parameter value like
below:
http://www.foo.com/agent_result.php3?$agent_id=9805";>My Link
Text
I'm trying to pass that parameter into a query on another page and have it
di
Hello,
Is there a way to get parameters list for compiled UDF without its source
available? If there, how can I get this parameters list?
Best regards,
Igor Brynskich
Database
-
Before posting, please check
Hi
how can I recive parameters from an external aplications in my MySql queries.
for example in MS Access I do this in this way:
PARAMETERS (variable AS type)
SELECT ..
I want to do the same thing in MySql
the combination is unique so
iyou dont get an error
On Fri 6. July 2001 14:04, you wrote:
> Hi all!
>
> Sorry for the dumb question, but am I right in the following suggestion:
>
> I have the following table:
>
> create table tab_1 (
> field_1 integer not null,
> field_2 integer not
üÄÕÁÒÄ óÕÒÏ× wrote:
>
> Hi all!
>
Hi,
> Sorry for the dumb question, but am I right in the following suggestion:
>
> I have the following table:
>
> create table tab_1 (
> field_1 integer not null,
> field_2 integer not null,
> primary key (field_1, field_2));
>
> Do
Hi all!
Sorry for the dumb question, but am I right in the following suggestion:
I have the following table:
create table tab_1 (
field_1 integer not null,
field_2 integer not null,
primary key (field_1, field_2));
Does it mean that this key requires unique COMBINATION
HI,
Is it possible to do a select-statement like this:
select * from @parameter ?
Thanks,
Marijke
Find the best deals on the web at AltaVista Shopping!
http://www.shopping.altavista.com
-
Before posting, please check:
http:/
second row of parameter data. */
> > sOrderID = 1002;
> > sCustID = 501;
> > dsOpenDate.year = 1996;
> > dsOpenDate.month = 3;
> > dsOpenDate.day = 9;
> > strcpy(szSalesPerson, &quo
with second row. */
> retcode = SQLExecute(hstmt);
> }
>
> Regards,
> Miguel
>
>
> >I have trouble writing a character into the database (the column is
> >declared as char(2) not null) because I figured that if it appends a null
> >at the end of the character d
hat if it appends a null
>at the end of the character data I want to insert (i.e.'A\0'), it would
>still fit. I bound the parameters first before assigning the data and
>executing a statement to write into the database. This is how I bind it:
>
>---
I have trouble writing a character into the database (the column is declared as
char(2) not null) because I figured that if it appends a null at the end of the
character data I want to insert (i.e.'A\0'), it would still fit. I bound the
parameters first before assigning the data and
At 09:48 12/01/2001 +0100, Alain Vigne wrote:
Hi!
>Hi !
>How can i set parameters for my mysql server daemon when i start it as a
>Windows NT service ?
Use the my.cnf or my.ini file.
Regards,
Migue
>-
>Before
Hi !
How can i set parameters for my mysql server daemon when i start it as a
Windows NT service ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
72 matches
Mail list logo
