Ok, I'm going to make a guess here. You're using Apache web server with
php4 to store and retrieve info from a mysql DB, right?
If this is correct then this is not a mysql problem but an apache/php
problem. Go to the php site and have a read of the user commented on-line
manual. In the installa
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 am working on with mysql_escape_string() what it
does precisely is to copy the content from source
string to destination string.
It's not introducing the additional backslash
character ("\\") required if I need to save a string
like"abc\def".
If we enter the string as "abc\\def" then it is
Am I correct in assuming you are on a Windows based system? As you've never
heard of tar, you probably never touched a unix system before. If I'm wrong
and your system is unix based, you will need to study unix a lot more.
A lot of files that have .gz or .tar are usually for unix based systems
Can someone help me with a query to pull all possible values for an enum
column? I found this in the online manual, but it doesn't seem to work for
me.
If you want to get all possible values for an ENUM column, you should use:
SHOW COLUMNS FROM table_name LIKE enum_column_name and parse the ENUM
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
__
I think I have a corrupt table and my most recent backup is too old to use.
Here's the scenario:
I started getting duplicate key errors for no apparent reason. The column is
a medium int, the highest value was 260 (or there abouts) and it was trying
to insert a 0. So I whipped out my MySQL Manua
Heikki Tuuri wrote:
>
> Steve,
>
> you should set autocommit=0 and only call commit after the
> whole batch of inserts.
>
so then if I'm inserting via a mysqldump file I should
append commit; to the last line of the file?
> If you use autocommit=1 and insert each row in a separate transact
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
I appreciate the replies. I have decided to keep it all in one table
for the following reason. First, on the one hand five attributes that
describe a customers education could arguably be a separate table, since
they describe the education, however, they still describe the customer
-- Harvard ed
> SQL STATEMENT:
>
> SELECT
> players.playerid,name,
> count(goals.goalid) AS goals,
> count(penalties.penaltyid) AS penalties
> FROM players
> LEFT JOIN goals ON (players.playerid=goals.playerid)
> LEFT JOIN penalties ON (players.playerid=penalties.playerid)
> GROUP BY players.playerid
I have a table of hockey players with goals and penalty minutes in a MySQL database. I
want to display a list of players in the roster (using the table 'players') along
with a count of all goals and penalties for each player. However, I seem to be
getting an error in my results, and I can't fig
Well,
This email also broke KDE Mail (note the date in the quotation).
This would be my first UT (Unix timestamp) glitch. Congratulations!!
You're about 20 years ahead of what I expected :O)
GB
On Wednesday 31 December 1969 04:00 pm, I thought root said:
> >Description:
>
> Linux Alpha buil
On Sat, May 12, 2001 at 03:45:50PM +0200, Warren van der Merwe wrote:
[major snip]
> As said above, these times include the time taken to add the rows
> using a while, wend statement to a grid in my application. The timer
> is at the exact same point, and is logged into a file therefore
> there
Hi ,
Infact I tried it out that way.There is a problem with
my_sql_real_escape_string() .I.e at the time of
linking it is giving an Unresolved External Symbol for
this function.For rest of the API functions it's OK.
I checked up with the .def file in the includes
directory and found that this func
Bonjour Warren,
What about InnoDB tables ? Could you change the TYPE to INNODB and
run the same test ? This would be great to compare MYISAM, GEMINI
and INNODB.
Regards,
Alex.
WvdM> Goodday to you all
WvdM> For those that are interested, I have managed to get my GEMINI tables
Wv
Goodday to you all
For those that are interested, I have managed to get my GEMINI tables
working successfully, and changed one of my reports to use the MYSQL tables
instead of my original MSACCESS ones. Had a couple problems with the initial
altering of some tables from MYISAM to GEMINI, but mana
Hi,
I'm new to mySQL and have a quick question. I'm trying to install
ShowTable-3.3. I must be downloading this incorrectly, as it never shows up
on my hard drive. Now I'm assuming that I just ftp to the site, download it,
untar (whatever that might be) it and then use perl to put it toget
On 09 May 2001 09:43:59 +0100, Eugénio Veiga wrote:
> Hi
>
> Does any body if is possible in windows 9x to implement odbc for MySql
> with ssl ?
> There exists any driver for this ?
Well, I do not know much about ODBC. But anyway if you tell "MySQL with
SSL" then you mean my work on SSL support
On 09 May 2001 11:00:49 +0300, Andis wrote:
> I'm from Latvia. Currently my database contain words, which contain Latvian specific
>characters.
> MySQL works under RedHat6.2.
>
> Is anybody now how is possible to teach MySQL correctly sort textual strings with
>Latvian characters?
Yes it is p
Steve,
you should set autocommit=0 and only call commit after the
whole batch of inserts.
If you use autocommit=1 and insert each row in a separate transaction,
the database has to flush the log physically to disk after each
insert, which means only some 50-200 insertions per second, depending
o
Can anyone share the experiences with mysql
Full-text Search indexes? I have been reading here and
there about how slow it can be to create/update a
text index.
Also, are there any benchmarks on query results
on searching such indexes?
Christopher Lambrou,
CGL Computer Services, Inc.
Empire
Having some troubles coping with this issue using MySQL 3.23.31 on a
Linux box.
Brief explanation of what's going on:
I have a table setup that requires two negative values in an
AUTO_INCREMENT field (not my choice, nor is there anything I can do to
correct this issue at this time), '-10' and '-
23 matches
Mail list logo
