Paul DuBois wrote:
At 21:44 -0400 3/24/04, WebMaster Informática007 wrote:
Hi
I have problem with a Query.
It does not recognize EXISTS.
My version is MySQL 4.0.11a-gamma
Subqueries are supported beginning with MySQL 4.1.0.
http://www.mysql.com/doc/en/Subqueries.html
http://www.mysql.com/doc/
At 21:44 -0400 3/24/04, WebMaster Informática007 wrote:
Hi
I have problem with a Query.
It does not recognize EXISTS.
My version is MySQL 4.0.11a-gamma
Subqueries are supported beginning with MySQL 4.1.0.
http://www.mysql.com/doc/en/Subqueries.html
http://www.mysql.com/doc/en/Nutshell_4
Hi
I have problem with a Query.
It does not recognize EXISTS.
My version is MySQL 4.0.11a-gamma
The query is:
SELECT U.usu_id, U.usu_login
FROM cva_usuario U
WHERE NOT EXISTS (SELECT * FROM cva_grupo_usuario GU WHERE GU.usu_id=U
usu_id Where GU.gru_id=4)
Help please.
Yakari,
- Original Message -
From: "Yukari Iwatani" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 14, 2003 3:36 PM
Subject: Hard, unrecoverable InnoDB crash with MySQL 4.0.11
> Hi:
>
> I'm running MySQL 4.0.11 (MySQL.com bin
Hi:
I'm running MySQL 4.0.11 (MySQL.com binary RPMs) on Red Hat Linux 7.3, all
errata applied (kernel 2.4.18-26.7.xsmp).
This morning, our server died hard, with the following error:
030314 2:44:13 InnoDB: Assertion failure in thread 7938074 in file
btr0btr.c line 298
When the server
I tried to use MySql 4.0.11-gamma-max gebug on W2K.
Mysql Service hang on "delete from tbl_listdat;"
Do you want to get further information about this problem?
I' m an experienced MySql user since years. I think this is a problem caused by a
combination of the table structure
Hi,
> Now my problem is, a user with no privilege is able to
> run SQL command TRUNCATE to empty any table!
Thanks for the bug report.
The bug has been entered into our bug database as bug #138:
http://bugs.mysql.com/bug.php?id=138
This will be fixed in the next release, 4.0.12.
Rgds,
Indrek
At 21:41 -0600 3/9/03, Charles Lewis wrote:
I was reading somewhere that MySQL 4.1 UPDATE syntax will allow
update to table with values from another table in the following
manner:
update client, zip
set client.st = zip.st, client.city = zip.city
where client.zip = zip.zip;
Is there a creative wa
I was reading somewhere that MySQL 4.1 UPDATE syntax will allow update to
table with values from another table in the following manner:
update client, zip
set client.st = zip.st, client.city = zip.city
where client.zip = zip.zip;
Is there a creative way to do this in 4.0.11?
chas
Hi!
On Mar 05, Dr. R. Rajaraman wrote:
> Hi,
>
> I am a new user (hardly a month old) to mysql.
>
> My configuration:
> P4 with Windows 2000 prof, apache, PHP4.3, Mysql
> 4.0.11-gamma, phpmyadmin
> 2.4.0.
>
> Now my problem is, a user with no privilege is able to
Hi,
I am a new user (hardly a month old) to mysql.
My configuration:
P4 with Windows 2000 prof, apache, PHP4.3, Mysql
4.0.11-gamma, phpmyadmin
2.4.0.
Now my problem is, a user with no privilege is able to
run
SQL command TRUNCATE to empty any table!
First I reported it to phpmyadmin team and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 26 Feb 2003, Benjamin Pflugmann wrote:
> On Wed 2003-02-26 at 18:36:07 +0100, [EMAIL PROTECTED] wrote:
> [...]
> > As Mark has already stated, this is a typo - it should have read "GAMMA"
> > instead. Sorry for the confusion.
>
> Would yo
Hi.
On Wed 2003-02-26 at 18:36:07 +0100, [EMAIL PROTECTED] wrote:
[...]
> As Mark has already stated, this is a typo - it should have read "GAMMA"
> instead. Sorry for the confusion.
Would you mind to elaborate a bit on the current state of the 4.0
cycle? Since Monty suggested in the 4.0.8 releas
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 26 Feb 2003, Mark Matthews wrote:
> Ken Menzel wrote:
>
> > How come there is not a source download for 4.0.11??? The source
> > download is still 4.0.10! Did some one miss the source tar ball?
>>
> The source release will be 4.0.11a, w
.
I have now removed that DBUG_ASSERT from 4.0.12.
You should use a non-debug version of mysqld to convert your table, like it
advises below.
Regards,
Heikki
Innobase Oy
sql query
...
Subject: The Error in INNODb with MySQL 4.0.11
From: Dyego Souza do Carmo
Date: Wed, 26 Feb
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 26 Feb 2003, Salada, Duncan wrote:
>
> This is a new beta development release, adding new features and fixing
> recently discovered bugs.
>
>
> Has the release gone backward to beta?
As Mark has already stated, this is a typo - it should ha
I'm using MySQL-PRO 4.0.11 and I have a error on
SELEC/DROP/ALTER/INSERT one specific table:
Version: '4.0.11-gamma-debug-log' socket: '/tmp/mysql.sock' port: 3306
InnoDB: Error: table ./webescriba/webtest has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
InnoDB: If y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ken Menzel wrote:
Hi,
How come there is not a source download for 4.0.11??? The source
download is still 4.0.10! Did some one miss the source tar ball?
Thanks,
Ken
The source release will be 4.0.11a, with patches for compilation on
HP/UX (as it state
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Salada, Duncan wrote:
>
> This is a new beta development release, adding new features and fixing
> recently discovered bugs.
>
>
> Has the release gone backward to beta?
>
> Duncan
No, the release has a 'typo'. The release is 4.0.11 GAMMA.
-Mark
t;; <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 9:47 AM
Subject: MySQL 4.0.11 is released
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi,
>
> MySQL 4.0.11, a new version of the popular Open Source Database, has
been
> released. It is now available in
Grimmer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 9:47 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: MySQL 4.0.11 is released
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.11, a new version of the popular Open Source Database, has been
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.11, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that
Luc,
- Original Message -
From: ""Luc Foisy"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, February 25, 2003 9:09 PM
Subject: RE: mysql 4.0.11
>
> Did I miss the global release message for this version?
> I got the InnoDB re
Did I miss the global release message for this version?
I got the InnoDB release message but no other...
> -Original Message-
> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 25, 2003 10:53 AM
> To: [EMAIL PROTECTED]
> Subject: re: mysql 4.
On Friday 21 February 2003 19:05, Reetz Wendy wrote:
> Does anyone know when the release date for the mysql 4.0.11 version? I
> was just about to rebuild everything (apache,php,etc), but if it's next
> week, I'd rather wait for it.
You can find 4.0.11 at:
http://www.
Does anyone know when the release date for the mysql 4.0.11 version? I
was just about to rebuild everything (apache,php,etc), but if it's next
week, I'd rather wait for it.
Thanks,
Wendy
-
Before posting, please chec
26 matches
Mail list logo
