Yes this is the same issue I've reported previously. Unless literally
'select' the database, the query is never written to the binary log.
- Original Message -
From: "Ross Davis - DataAnywhere.net" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 12, 2003 12:38 PM
Subject
Hi,
I've setup a mysql table field which is a SET type, but it seems to be
completely pointless. I can't see why I should use a SET type rather than a
string for the following reasons:
1. I appear to be able to store whatever I want in there. MySQL doesn't
enforce the rule that what I stick in
Hello.
On Sun 2003-01-12 at 11:18:08 +, [EMAIL PROTECTED] wrote:
>
> I've setup a mysql table field which is a SET type, but it seems to be
> completely pointless. I can't see why I should use a SET type rather than a
> string for the following reasons:
>
> 1. I appear to be able to store
At 11:18 + 1/12/03, Jeff Snoxell wrote:
Hi,
I've setup a mysql table field which is a SET type, but it seems to
be completely pointless. I can't see why I should use a SET type
rather than a string for the following reasons:
1. I appear to be able to store whatever I want in there. MySQL
lo everyone,
I have two tables Both have a DebtCode VARCHAR(6) in them, and both has
UNIQUE Indexes on them. How can I select DebtCode as being unique in both
tables?
DebtCode in both tables, will be three alphabetical characters, followed by
three numbers, like ABC001 ... ABC999, etc etc et
OK, this just doesn't make sense to me
mysql> SELECT COUNT(DISTINCT table1.DebtCode) AS table1, COUNT(DISTINCT
table2.DebtCode) AS table2 FROM table1, table2 WHERE (table1.DebtCode LIKE
'CHR%' OR table2.DebtCode LIKE 'CHRI%');
+++
| table1 | table2 |
+++
|
Hi
I"m getting a "connection timed out" on my web page when I try and add
information to the database. This happen regardless if I use a
"comm.setautocommit( true) or 'false'.
Also, it's not just ANY information that causes the time out. It's when
I add info to my Questions table, then try and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Bateman wrote:
Hi
I"m getting a "connection timed out" on my web page when I try and add
information to the database. This happen regardless if I use a
"comm.setautocommit( true) or 'false'.
Also, it's not just ANY information that causes the
--- Adolfo Bello <[EMAIL PROTECTED]> wrote:
>
> > As far as I know and how I understand it, the relationships are basically
> all
> > in your head... You just have to coordinate it in your queries and other
> functions
>
> This is not true. Fot type innodb tables, you can define REFERENCES
> usin
Hi,
One of my new years resolutions was to spend some quality time Mysql.
Yesterday I started installing it and I have some problems.
I have downloaded two different packages
1. Mysql 4.0.8 for Freebsd:
Is this actually a freebsd package that you need to install with pkg_add?
I tried this
I have a table in a database. I'm trying to delete 5 million rows from
it. But whenever I try to do this, while the delete command is
executing access to the other tables in the database are blocked
(which freezes up a website that runs off that database, even though
that website doesn't use the ta
I have the following table,
CREATE TABLE cp (
id INT(11) NOT NULL auto_increment,
fileVARCHAR(128) NOT NULL,
content LONGTEXT,
UNIQUE KEY keyword(id,file),
PRIMARY KEY (id)
) TYPE=INNODB;
I want to insert into "content" an entire text document. How do I do that wit
Anyone know where I can find a compiled version of mysql 4.x for debian linux?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
Im not sure what has gone wrong but the mysql.users table is set as
read only. I am trying to grant user privileges but cant because of
this. How can I change the status so that I can add to it?
I am logging in (localhost) using the (unchanged default) u root
account, so I know thats not t
Did you ever get any confirmation that it will be added to the official
bug list?
-Original Message-
From: Jason Brooke [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 12, 2003 3:14 AM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]
Subject: Re: Replication bug?
Yes this is the
Yes, the slaves are doing the replication. (didn't know you could set
it up any other way)
As far as I am concerned this is a BIG bug. Anything that happens on
the master should replicate to the slaves.
Any chance this could get fixed in the next release?
-Original Message-
From: Fre
> Greetings all. Hope someone could give me some pointers on this.
>
> I am working at a small ISP in Montreal. Some of our corpo users. have
> access to a MySQL database, that we created for them (usually, this DB is
> named after there username). The way we configured our mysql installation,
> w
No, I've been ignored on this problem for 18 months now, for some reason.
Quite peculiar.
- Original Message -
From: "Ross Davis - DataAnywhere.net" <[EMAIL PROTECTED]>
To: "'Jason Brooke'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 9:16 AM
Subject: RE: Rep
Nosso detector de vírus bloqueou a mensagem que você enviou:
Para: <[EMAIL PROTECTED]>
Assunto: Glob ter
Data: Mon Jan 13 00:20:00 2003
Partes infectadas da mensagem não foram entregues.
Essa mensagem é apenas um aviso que seu computador provavelmente
está infectado com vírus e precisa ser
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Zak & George --
...and then Zak Greant said...
%
% On Fri, Jan 10, 2003 at 11:50:28PM -0500, David T-G wrote:
% >
% > ...and then Gman said...
% > %
% > % How can I delete a database in MySQL so I recreate it?
% >
% > echo 'drop database dbname'
From: Philip Mak <[EMAIL PROTECTED]>
> I'm trying to delete 5 million rows...
Do you have to do this often?
> ...access to the other tables in the database are blocked...
How do you mean "blocked"? Do you mean that you're getting an error message someplace,
or that other operations take way t
On Sun, Jan 12, 2003 at 08:12:35PM -0700, Rodney Broom wrote:
> > I'm trying to delete 5 million rows...
>
> Do you have to do this often?
Sort of. I have a process that logs to MySQL, and I want to delete old
log entries. I haven't been deleting old entries at all recently
because it will freeze
> > > I'm trying to delete 5 million rows...
Can you drop the table, then re-create it for further use?
Anything besides the 5,000,000 you want to keep?
> >
> > Do you have to do this often?
>
> Sort of. I have a process that logs to MySQL, and I want to delete old
> log entries. I haven't been
I would suggest appending an "ORDER BY atomtype" first of all.
I say this because if you scan your results, you have duplicates...
| 165 |
| 166 |
| 167 | <---
| 168 |
| 169 |
| 170 |
| 171 |
| 172 |
| 173 |
| 174 |
| 175 |
| 167 | <--
Also, don't confuse the RANGE of values that the atomtype can be (0-255)
if set to be UNSIGNED with the NUMBER OF ROWS in your output. The
TINYINT is working. You have no values greater than 255 in there. You
just have duplicates which gives you more rows than you were expecting I
think. ;-)
> ---
While trying to build 4.0.7-gamma from the source rpm with this
incantation:
rpmbuild -bb mysql-4.0.7-gamma.spec
on an old machine which has seen several Red Hat upgrades (ever since
version 6.0), the build continues for nearly an hour until it gets this
error:
make[1]: Leaving directory `/usr/s
hi
I am facing a problem in adding a new function to MySQL
I created a function in C and compiled and build it
successfully.
these files were successfully created--
funmysql.c
funmysql.o
funmysql.so
I even attached the funmysql.so library's path in the
LD_LIBRARY_PATH
environment
I am using MYSQ
hi
I am facing a problem in adding a new function to MySQL
I created a function in C and compiled and build it
successfully.
these files were successfully created--
funmysql.c
funmysql.o
funmysql.so
I even attached the funmysql.so library's path in the
LD_LIBRARY_PATH
environment
I am using MYSQ
hi All,
has anyone been able to setup ssl secure replication for mysql? how do i
know whether the replication is actually done over ssl? there seem to be a
lack of documentation on this part. appreciate a lot if someone could
provide some feedback on this. i m currently running mysql-4.0.7-gamma
(
Hola,
Tengo la versión 3.23.54 instalada sobre Windows. He esta leyendo algunos
documentos acerca de el soporte de claves foraneas y he visto que para ello
dicha versión necesita un patch llamado MySQL-MAX. En la sección de
downloads he visto que existe la versión 3.23.54-MAX, ¿es este el patch
ne
30 matches
Mail list logo
