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
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.
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
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
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 for
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
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
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
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
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 is
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 build.
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
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;
Have
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
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
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 transaction,
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
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
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
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
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
likeabc\def.
If we enter the string as abc\\def then it is
21 matches
Mail list logo