Hi,
I donot even get that with an additional backslash
also.In my case it just ignores the backslash and goes
ahead with the search .
Regards,
Ravi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM
> Ravikumar Sarma Chengalvala wrote:
> >
> > Even after
On Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
>
> Even after escaping mysql just seems to be ignoring it.
Odd. I'm seeing something other than what I first expected. Watch
this...
---snip---
mysql> CREATE TABLE slash_test ( foo VARCHAR(30) );
Query OK, 0 rows
Hi,
Can someone get back to me at the earliest regarding
mysql's support for backslash characters in pattern
search.I am not able to search based on the string
which contains a backslash character even after
escaping..
Regards,
Ravi
Do
It is not working even after escaping it.I am working
on WINNT4.0 and mysql 3.23
--Regards,
Ravi
--- Scott Baker <[EMAIL PROTECTED]> wrote: > It
depends on what you mean by pattern search? You
> probably have to escape
> the "\" character. If you put a "\" in front of a
> character it means th
Hi,
Even after escaping mysql just seems to be ignoring
it.
Regards,
Ravi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM
> Ravikumar Sarma Chengalvala wrote:
> > Hi,
> >
> > Did mysql pattern search support a backslash
> character?
>
> Yes.
>
> Sin
It depends on what you mean by pattern search? You probably have to escape
the "\" character. If you put a "\" in front of a character it means this
next character is what I say it is not it's MySQL representation. This
would allow you to put a ";" or ")" in your query. Simply put "\\" to m
On Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
>
> Did mysql pattern search support a backslash character?
Yes.
Since it is a special character, make sure it is properly escaped.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
De
Hi,
Did mysql pattern search support a backslash
character?
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-
Hi,
I am facing the following problem in pattern matching:
I want to check the pattern matching using LIKE on a
field that is declared as Binary and also contains
back slashes.
eg:
ID INT,
NAME VARCHAR(128) BINARY
I am using C-API of mysql to escape the characters
like '\' for this field.
The s
ut and process
> it, sometimes it better to do a little of both.
> Without details I am afraid
> I can't help much.
>
> -Original Message-
> From: VVM Ravikumar Sarma Chengalvala
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 7:45 AM
> To: [EMAI
Hi,
I wonder to know which of the following is better in
performance and faster .
Using table joins for queries.
OR
Multiple queries without joins using MySql C API
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk a
Hi,
I am using my sql CAPI.I am able to access the
database well but there is one performance issue that
came into my mind.
Is it better to have a single query on multiple tables
using joins?
(OR)
Multiple queries without joins on each table,in a
sequential order .
If I use
Hi,
I donot think it is supposed to show the number of
rows deleted or it should not show anything at all.I
agree if it is not a bug,at least it is an unwanted
thing .
When it always shows the affected number of rows as
zero though it actually deletes a million records,it
must be removed or made o
t;
Sent: Thursday, May 31, 2001 8:06 AM
Subject: Re: ASP and my sql??
> Hi everyone,
> 1)
> Thanks for all your ideas.
> 2)
> Infact I am already using C-API for data retrieval
> from mySQL and I want to provide admin utility to my
> application which runs on a web server.
Hi,
i)
I am using mysql.exe.
ii)
I could observe a small bug.Whenever I use a delete or
update command,it always gives a message on my console
window stating that zero rows affected.Ofcourse the
actual statement works fine.Only the post command
message on console window misleads me many times.
Re
VVM Ravikumar Sarma Chengalvala writes:
> Hi everyone,
> 1)
> Thanks for all your ideas.
> 2)
> Infact I am already using C-API for data retrieval
> from mySQL and I want to provide admin utility to my
> application which runs on a web server.I donot want to
> use ODBC.It tends to bind my applicat
m/
> /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
> <___/
>
> - Original Message -
> From: "Dennis Salguero" <[EMAIL PROTECTED]>
> To: "VVM Ravikumar Sarma Chengalvala"
> <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
lvala" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 7:06 PM
Subject: Re: ASP and my sql??
> It depends on what you mean by "without using ODBC".
>
> You CAN connect to a MySQL database without a DSN name, you can just
declare
> an IP address
If you are good with C++, you can probably write an ActiveX wrapper for
MySQL++ yourself. MS Visual C++ has some wizards that will help you with
ActiveX controls. My company considered doing this for a project until
we decided to make the app web-based.
Ben
On Wednesday, May 30, 2001, at 04:
Sent: Wednesday, May 30, 2001 1:03 PM
Subject: ASP and my sql??
> Hi,
> I wonder to know of any other ways to connect to mySQL
> from ASP without using ODBC
>
> Regards,
> Ravi
-
Before posting, please
Hi,
There is a company called Scibit that develops a commercial AcitveX (COM)
object called MySQLX that can be used to access directly MySQL from ASP or
any other COM supporting language.
the url is www.scibit.com
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_
Hi,
I wonder to know of any other ways to connect to mySQL
from ASP without using ODBC
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.i
At 3:13 PM +0100 5/30/01, VVM Ravikumar Sarma Chengalvala wrote:
>Hi,
>I wonder to know whether declaring a column as BINARY
>will take the characters like \,' etc into binary form
>and stores it in the database?
>
>Then we may not need to specify the escape sequences..
You need to properly esca
Hi,
I wonder to know whether declaring a column as BINARY
will take the characters like \,' etc into binary form
and stores it in the database?
Then we may not need to specify the escape sequences..
Regards,
Ravi
Do You Yahoo!?
Get yo
]
Subject: My sql and system time
Hi,
Can some one let me know how can I insert current time
into the MySQL table's time column.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your
TED]>
Sent: Tuesday, May 29, 2001 10:07 AM
Subject: My sql and system time
> Hi,
> Can some one let me know how can I insert current time
> into the MySQL table's time column.
>
> Regards,
> Ravi
>
>
>
Hi,
Can some one let me know how can I insert current time
into the MySQL table's time column.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yah
i would like to convert my sql server data into
mysql, how can i do ??
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If y
On Thu, May 24, 2001 at 04:07:48PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> I would like to have answers/confirmation regarding
> the following:
> i)
> Primary and Unique key fields are autoindexed by
> mysql.
Yes.
> ii)
> Indexing on a single or multiple fields will create a
> overhead
Hi,
I would like to have answers/confirmation regarding
the following:
i)
Primary and Unique key fields are autoindexed by
mysql.
ii)
Indexing on a single or multiple fields will create a
overhead on database memory.To what extent
iii)
Indexing Vs Perfromance based on a query frequency on
a part
VVM Ravikumar Sarma Chengalvala wrote:
>
> Hi,
> 1.
> How much memory does mysql allocate by default to a
> database?Any default table wise memory limitations as
> well?
Its doesn't allocated very much by default ( < 10M ? ),
and there is no per table memory allocation.
> 2.
> Is mysql's memor
Hi,
Do someone have answers to these questions:
1.
Maximum table size myISAM type tabes can handle?
2.
Default maximum database size for a particular
database.
Your help will be highly appreciated.
Regards,
Ravi
Do You Yahoo!?
Get you
Hi,
1.
How much memory does mysql allocate by default to a
database?Any default table wise memory limitations as
well?
2.
Is mysql's memory management and Oracle's memory
management similar?Or altogeather different?
Regards,
Ravi
Do Yo
> 2.
> The following is the extract from mysql documentation:
> "
> In MySQL Version 3.23.7 and above, you can insert rows
> into MyISAM tables at the same time other threads are
> reading from the table. Note that currently this only
> works if there are no holes after deleted rows in the
> table
Hi,
1.
Does mysql inherently implement locking implicitly?
2.
The following is the extract from mysql documentation:
"
In MySQL Version 3.23.7 and above, you can insert rows
into MyISAM tables at the same time other threads are
reading from the table. Note that currently this only
works if there a
Hi,
I have installed mysql on WIN NT4.0.By default ,will
mysql use ISAM as the default?
When to opt for BDB?
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at h
Can some one let me know about the URL to go through
the mysql Admin issues.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
---
Hi,
I was going through my sql documentation and found the
stability of mysql for locking is "Gamma".Does mysql
recommend the usage of explicit locking for sensitive
data or will it automatically handle concurrent
requests?
Reg
Hi,
I wonder whether any of the database has support for
the following situation:
I created a database in mysql with the name "SAMPLE".
Now whenever I change this database in any manner ie
by adding one additional table or an additional column
to the database table,I would like to have a version
Hi,
I wonder whether mysql has any default memory
allocation and has a similar procedure for extending
the memory as does Oracle.
Can someone throw some light on this?
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at h
Hi,
1.
What is the default memory allocated by mysql to a
newly created database?
2.
If I make any changes to a database(either by adding a
new table or by adding or deleting a column of a
table) is there a way ,I can have a version control of
my database and retain the old tables and new tables
o
Hi,
Can some one tell me the default memory the mysql
allocates when we initially create a database and how
to increase the memory subsequently.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
VVM Ravikumar Sarma Chengalvala writes:
> Hi Sinisa,
>
> Thanks for spending the time.Here are few observations
> on mysql_escape_string().I have checked it up and
> found to be working but with the following problems.
> i)
> It works well when I want to insert strings like:
> "'xyz" or "x'yz".
>
Hi Sinisa,
Thanks for spending the time.Here are few observations
on mysql_escape_string().I have checked it up and
found to be working but with the following problems.
i)
It works well when I want to insert strings like:
"'xyz" or "x'yz".
ii)
When I use "x\yz" with the function I see a junk
char
VVM Ravikumar Sarma Chengalvala writes:
> Hi Sinisa,
> Thanks for the detailed mail.Can you send me the
> syntax for mysql_escape_string() please so that I can
> check up with what I have been trying out.
>
> Regards,
> Ravi
Here is an example from C++ :
char* s = new char[in.size()*2+1
Hi Sinisa,
Thanks for the detailed mail.Can you send me the
syntax for mysql_escape_string() please so that I can
check up with what I have been trying out.
Regards,
Ravi
--- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: > VVM
Ravikumar Sarma Chengalvala writes:
> > Sinisa,
> > 1.
> > Thanks for
VVM Ravikumar Sarma Chengalvala writes:
> Sinisa,
> 1.
> Thanks for the mail.
> 2.
> I observed that mysql_escape_string()soes not work
> either.If I want to store a file name with back
> slashes,I feel mysql_escape_string() should introduce
> the additional backslash required .But it does not do
Sinisa,
1.
Thanks for the mail.
2.
I observed that mysql_escape_string()soes not work
either.If I want to store a file name with back
slashes,I feel mysql_escape_string() should introduce
the additional backslash required .But it does not do
so.It is just copying from source string to
destination
VVM Ravikumar Sarma Chengalvala writes:
> Hi,
> 1.
> I am using MySQL3.23 on WindowsNT4.0 platform.
> 2.
> Whenever I try to use mysql_real_escape_string()
> method,it works well with the compiler and fails while
> linking.I am using VC++6.0 as environment .The reason
> that I have traced out is:
Hi,
Can some one send me the sample working code of C API
for MYSQL for the following functions(The platform on
which MySQl data base was downloaded is WINDOWS NT-4.0
work station):
Functions for which I need the dample code:
mysql_real_escape_string()
mysql_escape_string()
Regards,
Ravi
___
Hi,
I want to use mysql_escape_string(0 to store the File
Names with back slash character('\').
Unless I enter \\ in the File name it is not taking
in.
Will the function automatically add the additional
'\'
required.
What is the exact role of this function?
Regards,
Ravi
__
Hi,
1.
I am using MySQL3.23 on WindowsNT4.0 platform.
2.
Whenever I try to use mysql_real_escape_string()
method,it works well with the compiler and fails while
linking.I am using VC++6.0 as environment .The reason
that I have traced out is:
i)
The function mysql_real_escape_string() is not coming
so-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?=
> <[EMAIL PROTECTED]> wrote:
> To:[EMAIL PROTECTED]
>
From:=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?=
> <[EMAIL PROTECTED]>
> Date:Fri, 11 May 2001 16:35:21 +0100 (BST)
> Subject: My Sql C_API(Urgent)
>
- Original Message --
=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= <[EMAIL PROTECTED]> wrote:
To:[EMAIL PROTECTED]
From:=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= <[EMAIL PROTECTED]>
Date:Fri, 11 May 2001 16:35:21 +0100 (BST)
Subject: My Sql C_A
Hi ,
Can some one send the exact function description of
the following CAPI function:
mysql_escape_string
I need to use mysql_escape_string as the
mysql-real_escape_string is not present in the .def
file and is giveing linker error while linking.
The C-API documentation says to refer
mysql_real
Hi,
MySQL API is giving the followwing linker problem.I am
using MYSQL3.2.3 and I observed that Libmysql.lib does
not contain mysql_real_escape_string()
Can some one guide me out to what to do in such cases.
The error:
dbObject.obj : error LNK2001: unresolved external
symbol _mysql_real_escape_s
Hi,
Does Mysql 3.2.3 support mysql_real_escape_string()?
I donot find it included in the Libmysql.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mai
Hi,
I am using my_sql_real_escape_string and in that the
strmov function of mysqlclient library.
I am getting the following errors while compiling:
d:\program files\mysql\include\m_string.h(143) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(146) : error
At 5:49 PM +0100 5/10/01, VVM Ravikumar Sarma Chengalvala wrote:
>Can some one let me know all possible ways to provide
>escape characters in MYSQL inserts.
>
>I am using C API.
If you're asking how to escape special characters:
http://www.mysql.com/doc/m/y/mysql_escape_string.html
http://www.my
Can some one let me know all possible ways to provide
escape characters in MYSQL inserts.
I am using C API.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at h
VVM Ravikumar Sarma Chengalvala wrote:
>
> Hi,
> How can I have an UNIQUE key in MYSQL which
> differentiates between case sensitive strings.i.e If I
> want to store "XYZ","XYz" and "xyz"
> differently.Currently mySQl is not accepting this type
> of strings and treating them as the same.
>
> Reg
Hi,
How can I have an UNIQUE key in MYSQL which
differentiates between case sensitive strings.i.e If I
want to store "XYZ","XYz" and "xyz"
differently.Currently mySQl is not accepting this type
of strings and treating them as the same.
Regards,
Ravi
__
Try mysql_real_query(). This function takes three parameters, the first two
are the same as mysql_query(). The third is the length of the query string.
Regards.
Alec
At 06:51 PM 5/7/01, VVM Ravikumar Sarma Chengalvala wrote:
>Hi,
>I am having a peculiar problem with C_API.How to
>execute a quer
On Tue, May 08, 2001 at 12:51:02AM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
> I am having a peculiar problem with C_API.How to
> execute a query string with its length more than 255
> characters using mysql_query() function.My sql query
> is
> more than 255 characters long and is getti
Hi,
I am having a peculiar problem with C_API.How to
execute a query string with its length more than 255
characters using mysql_query() function.My sql query
is
more than 255 characters long and is getting
truncated.
Regards,
Ravi
Do
hi ,
would any one suggest me a downloading site to download complete set of
MySQL windows 32bit.
Shall i have to register at any place to have the complete MySQL package.
Please help me.
thank you
Peri
_
Get Your Private,
/mysql, substitute
the proper directory.
2. Get the corrected RPMs from RedHat.
3. Get the RPMs from mysql.com.
If this does't help post the contents mysql's error log.
Maybe someone can help with this aditional information.
Rajat Rajvanshi wrote:
>
> hi
> i am installing My
hi
i am installing My Sql on Linux 7
i was trying it for the whole day..the only problem i
am facing since morning is that..
the SQL server starts during the booting of system
when i go in bin and give mysqladmin command it gives
error - Can't connect to server..
either the server is not ru
Explorer open the MySQL Manual at:
c:\mysql\docs\Manual.html.
Regards,
Miguel
>Hello,
>I am new to the list and new to My-SQL. I want to test My-SQL on my NT,
>but have trubble to get it to work.
>
>I have downloaded the shareware release of MySQL for Win32 and installed it.
>Accor
Hello,
I am new to the list and new to My-SQL. I want to test My-SQL on my NT, but
have trubble to get it to work.
I have downloaded the shareware release of MySQL for Win32 and installed it.
According to the manual I should use "C:\mysql\bin\mysqld-nt" to start the
server, but t
101 - 170 of 170 matches
Mail list logo