[EMAIL PROTECTED] wrote:
I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18
Distrib 3.23.54, for sun-solaris2.9 (sparc)
on Solaris 9.
the app runs fine during the day, but when I come back to work in the
morning, I see that the database connection has died and mySQL does not
You can try UTF-8.
- Cs.
I guess you'd have to use MySQL 4.1 to assign different character sets
to different columns. Should be straight-forward at time of table creation.
David
***
Hello,
I'm interested in building a translation dictionary:
russian -
Hi,
I am planning to run an instance of MySQL 3.23.55 and 4.0.11-max on the
same machine. The question is: what do I do with DBD::mysql ? Can I
leave it intact? The install note says I have to recompile modules that
link against libmysqlclient... but do I really have to do that? Or can I
[EMAIL PROTECTED] wrote:
I could be lame, but I couldn't reproduce the error.
The query worked ok for me -- using 4.0.4-beta-max-nt
Isn't Lauren using a language that uses \ as an escaping character? And
then tries to do something with \f? If it works form the mysql comman
line, then this can
I get this message back:
Failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.55-1
I know I have this dependency installed, but I think I know where the
problem is just not sure how to fix it. Here is what I get when I do a
'rpm -qa | grep DBI-perl':
Kees Hoekzema wrote:
Hello,
On Tuesday 04 February 2003 14:46, Grover Cussi N. wrote:
restore to the original size ?, I see that the tendence of the innodb
tables is to grow, and grow, and never will reduce the size, it is
posible to control this?
I had the same problem, it went on
Stefan Hinz, iConnect (Berlin) wrote:
Murthy,
how to insert only blank spaces into a field using insert query. Its
getting
trimmed off.
If you are using VARCHAR for this, you're right. It's a documented
behaviour of MySQL (Values are not padded; instead, trailing spaces are
While Csongor Fagyal (I belive) is correct about current behavior, the DBI
documentation explicitly says that this will break:
Currently, a new hash reference is returned for each
row. This will change in the future to return the
same hash ref each time, so don't
Csongor Fagyal wrote:
Jeff Snoxell wrote:
Hi,
if I call:
my $record = $sth-fetchrow_hashref();
then:
$sth-finish();
How valid is it for me to keep referring to my $record hash pointer?
Especially if I use $sth in a subsequent transaction.
It is absolutely legal. Your $record
Jeff Snoxell wrote:
Hi,
I've got a varchar field in a mysql table that contains 'N' numbers
(each a maximum of 4 digits, not zero padded) separated by spaces when
more than 1 number is present.
eg. field content might be any of the following
''
'123 4567 1234 45 3'
'3'
'3 4 6'
I want to
Hello, I'm in the process of moving from Postgres to MySQL and I have a
question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL auto_increment,
`somevalue1` varchar(35) NOT NULL,
Jeremy Zawodny wrote:
On Fri, Jan 10, 2003 at 01:59:07PM +0100, Csongor Fagyal wrote:
Hi,
I have a RedHat 8 box /w MySQL 3.23.54, /w 640M RAM.
It looks like there are some sort of a memory leakage somewhere in the
system, because slowly (in a day or two) I run out of memory. Even SWAP
would like to help you but I can't. This is PHP issue, not MySQL-s.
SSL connections are supported by MySQL, they are also available in C API
but I am not sure if and how PHP uses them.
Looking up into PHP manual http://www.php.net/manual/en/ref.mysql.php
won't show up needed functionality for
Hi,
I have a RedHat 8 box /w MySQL 3.23.54, /w 640M RAM.
It looks like there are some sort of a memory leakage somewhere in the
system, because slowly (in a day or two) I run out of memory. Even SWAP
space gets used up at the end (slowly but steadily, fluctuating). If I
restart MySQL, nothing
Hi,
Sorry if this had been asked on this list previously.
If you had an auto_increment field in a table (let's name it id),
previously (in 3.23.x, 4.0.x) the following (legal) SQL statement
resulted in a duplicate key error:
UPDATE whatevertable SET id = id +1;
Will this be fixed in 4.1.x?
Hi,
I have a 3.23.52-3 MySQL RPM installed (I think it is a RedHat version)
and I would like to upgrade to 5.23.54a. What is the easiest way to do
this? Download the new RPM-s and make an update/freshen? Or should I
better remove the RPM and do a source install? What about my config
files,
Hi,
I was trying to upgrade my 3.23.52 MySQL to 5.23.54a using rpm -U. The
system just hangs. (I am running RedHat 8.0)
This is what I get running a strace on rpm -U MySQL-whatever:
[...]
stat64(/, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
stat64(/var/, {st_mode=S_IFDIR|0755, st_size=4096,
Dana Diederich wrote:
This is a related but different question/comment.
In the six or so years of using MySQL, my various teams have never used
anything except an unsigned INT and UNIX Epoch time to record timestamps.
The given is, of course, we have always been a Perl/C/C++/UNIX shop, and we
I personally prefer TAI64 time (sub-second precision; see
http://cr.yp.to/libtai/tai64.html). For a comparison of how this
differs from UNIX time, see http://cr.yp.to/proto/utctai.html at the
same site. I'm surprised SQL hasn't been updated to support new time
formats yet, but oh well.
MySQL may be new compared to Oracle, for example, but many other
in-use DBs are in fact fairly new designs. They just happen to be
written by* large companies you recognize every day.
Any ideas about Postgresql vs. MySQL? I have always preferred MySQL
because of the speed, but I have heard
Michael She wrote:
It's bad for business : )
Maybe they're taking the MS route.
I second this. These vulnerabilities are serious, they must be given
more attention. Apache, PHP, RedHat and so on and so on are very careful
with issues like this, all vulnerabilities/exploits are immediately
I have two tables: one holding bids for an auction (table bids) and
one holding user data who placed the bids (users). I would like to get
the highest bid, the user who placed the bid and the number of bids
placed, so I use the following query:
SELECT MAX(bids.amount) AS amount,
W. D. wrote:
At 10:40 12/18/2002, Jocelyn Fournier wrote:
Hi,
I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some
tables contains more than 40 millions of rows) under quite high stress
(about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables)
I never experienced
What you need to have is a _good_ install, and then MySQL is superb. But
to have a good install is not as easy as it sounds.
Can you list the elements of a good install?
Well...
One which does not make mysqld hang once in every hour (or minute).
Seriously speaking, this is what I
Hi,
I have two tables: one holding bids for an auction (table bids) and one
holding user data who placed the bids (users). I would like to get the
highest bid, the user who placed the bid and the number of bids placed,
so I use the following query:
SELECT MAX(bids.amount) AS amount,
Subject: Remote Connection, please help
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using
Mike(mickako)Blezien wrote:
Hello all,
Is there away, within the sql query, to sort the query results in
alphabetical order, IE... going from A... to ..Z. This would be like
titles of mailing lists.
Well... you mean other than ... ORDER BY 'fieldname' ??
- Csongor
Lefevre, Steven wrote:
I'm still getting the error 'Can't find hosts.frm' when I try to laund the
mysql daemon.
I've run the mysql_install_db script several times.
I've changed the user and group ownership for all the files in the
/usr/libexec/mysql directory, and also in /var/lib/mysql to
Michelle de Beer wrote:
I have two tables. One with names and one for
excluding certain names. Exclude-table contains the
uid for the name excluded.
If I want to see which names has been excluded, this
query does the job:
Select n.uid, n.name from names_tables n, exclude
WHERE n.uid =
Hi,
I am having a problem wiht MySQL 3.23.53
The logs tell all:
021211 18:40:42 mysqld started
/usr/libexec/mysqld: ready for connections
Number of processes running now: 1
mysqld process hanging, pid 6066 - killed
021211 19:14:43 mysqld restarted
/usr/libexec/mysqld: ready for connections
30 matches
Mail list logo