Hi All,
I can't seem to find any documentation or opinions that would help me decide
if it is better to run mysqld-max-nt over the non-max server.
Opinions and pointers to supporting docs would be very welcome (especially
pointer to docs).
Thanks to All in advance.
Allen
Allen Weeks [EMAIL PROTECTED] wrote:
I can't seem to find any documentation or opinions that would help me decide
if it is better to run mysqld-max-nt over the non-max server.
Opinions and pointers to supporting docs would be very welcome (especially
pointer to docs).
All MySQL servers
William IT [EMAIL PROTECTED] wrote:
Does MySQL support update from other table?
I run this query and get error:
UPDATE TableA SET Division=TableB.Division
FROM TableB
WHERE TableA.Code=TableB.Code
Since version 4.0.4 you can do:
UPDATE TableA, TableB
SET
In InnoDB, the VACUUM is called the purge. In InnoDB purge happens
automatically in the background, the user does not need to explicitly run
VACUUM, like in PostgreSQL. Also in Oracle purge is automatic.
Recent versions of PostgreSQL have the ability to this automagically too.
Kaarel
--
MySQL
Hello!
I'm trying to write some kind of small accounting software and I got
stuck with the problem that doing a SUM() on values of a DECIMAL(7,2)
row did show problems with (relatively) small values (like 173.58). I
found a message explaining that mysql uses doubles internly to compute
the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I'm currently writing a Services Daemon for a new IRC Network. We're using
MySQL, because it's fast, and we easy can access it via PHP.
But then the problem is, how to access in C? I saw the C API, tried to include
it many times - it didn't
* Jean-Pierre Schwickerath
I'm trying to write some kind of small accounting software and I got
stuck with the problem that doing a SUM() on values of a DECIMAL(7,2)
row did show problems with (relatively) small values (like 173.58). I
found a message explaining that mysql uses doubles
* Lay Hoon Tan
I've just installed MySQL on my PC but do not know which program to access
in order to use it. Does anyone knows ?
MySQL is first and foremost a database server. To use any server software,
you must run it, and then access it using separate client programs.
The MySQL server
Shane,
it is not an InnoDB error message. InnoDB messages are always prefixed with
InnoDB:
The error means that there is an inconsistent row in the db.MYD system table
of MySQL.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for
We are replicating our database server in the interests of
having a hot spare with a fully up to date dataset.
Every so often, I'll get a page from a watchdog script[1] telling
me that the slave has fallen out of sync. Perhaps every 10 days
this occurs.
I notice there's always a coincidence
10/25/03 4:38:26 AM, Patrik Fimml [EMAIL PROTECTED] wrote:
I'm currently writing a Services Daemon for a new IRC Network. We're using
MySQL, because it's fast, and we easy can access it via PHP.
But then the problem is, how to access in C? I saw the C API, tried to include
it many times - it
Hi,
Does MySQL use other port(s) for network communicaton than the default 3306, or this
is the only one.
The reason why I ask it that I set up a firewall and I left this port open. But
somehow, I cannot login from outside. The firewall is definitely configured well, and
lets the 3306 port
Hi!
Have you added users that are allowed to log in from hosts other than
localhost?
Regards,
Chris
Daniel Kiss wrote:
Hi,
Does MySQL use other port(s) for network communicaton than the default 3306, or this is the only one.
The reason why I ask it that I set up a firewall and I left this
Does Mysql support repeatability of fields and subfields?
and would it be well suited for a bibliographic database?
Regards,
Miguel Maloney
Email: [EMAIL PROTECTED]
Website: http://maloneyja.com
Hi,
Yes, I have configured MySQL users as well.
Anyway, I have a user who is allowed from anywhere.
I have no other idea. The problem must be the firewall somehow, because if I switch it
off, everything is ok. But when I switch it back on (with port 3306 opened) my MySQL
server becomes
Does Mysql support repeatability of fields and subfields?
and would it be well suited for a bibliographic database?
Regards,
Miguel Maloney
Email: [EMAIL PROTECTED]
Website: http://maloneyja.com
What is the best method to use to include pictures in tables? I am using
PHP. I have several customers that I maintain their real estate site and
the maintenance is sometimes hectic. I am thinking that having the photos
in a mysql table will make it easier to maintain these sites.
Thanks in
Daniel Kiss wrote:
Anyway, I have a user who is allowed from anywhere.
I have no other idea. The problem must be the firewall somehow,
because if I switch it off, everything is ok. But when I switch
it back on (with port 3306 opened) my MySQL server becomes
unreachable from outside.
When
http://php.dreamwerx.net/forums/viewtopic.php?t=6
This code has served millions of binary objects (pics, files, etc)
for me with no problems.. good luck.
On Tue, 1 Jan 2002, Braulio wrote:
What is the best method to use to include pictures in tables? I am using
PHP. I have several
On Sat, Oct 25, 2003 at 12:47:16PM -0600, Miguel Maloney wrote:
Does Mysql support repeatability of fields and subfields?
and would it be well suited for a bibliographic database?
What is a 'subfield'? And what do you mean by 'repeatability'?
Regards,
Miguel Maloney
Email: [EMAIL
On Sat, 25 Oct 2003 15:41:10 -0400, Brian Reichert [EMAIL PROTECTED] wrote:
On Sat, Oct 25, 2003 at 12:47:16PM -0600, Miguel Maloney wrote:
Does Mysql support repeatability of fields and subfields?
and would it be well suited for a bibliographic database?
What is a 'subfield'? And what do you
dear list,
i've got the folowing compile error.
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/data/mysql\
-DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I. -I.
-I.. -I./../include -I../include -I./.. -I.. -I..
dear list,
i've got the folowing compile error.
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/data/mysql\
-DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I. -I.
-I.. -I./../include -I../include -I./.. -I.. -I..
Martijn,
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, October 24, 2003 4:08 PM
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
Hi Heikki,
As you know - I'm a transaction zealot :-)
Is there a way
I have a select statement that selects two string (text) fields. In some
cases, the first of them may be NULL. In this case, I would like the second
field to be selected instead. It is also possible that in rare cases that
the second string may be NULL, in which case it should just return NULL.
Hi,
I just installed MySQL version 4 and as usual, trying to set up users
and grant permissions is a nightmare.
I followed the instructions in the MySQL manual and granted permissions
to a user, like below:
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'12345678' WITH GRANT
26 matches
Mail list logo