-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> If you're using PHP you want the Perl DBI stuff. The C API
> is for C apps. If you are compiling a C application and
> are having trouble linking, post your specific issues and
> I'll be glad to help.
Well, I tried it many times... here is the las
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> 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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> gcc: cannot specify -o with -c or -S and multiple compilations
> make[2]: *** [libmysql.lo] Error 1
> make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.16/libmysql_r'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/usr/
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 OPTIO
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.
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 the
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..
/usr/local/ope
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..
/usr/local/ope
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 m
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
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 custom
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 y
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 adv
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 unreac
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!
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 p
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 pac
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
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 of
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 M
* 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 pro
* 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 inte
-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 wor
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 values
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 Ge
"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 T
"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 MySQ
28 matches
Mail list logo