Description:
Hello,
We are working with mysqld-max-nt 4.0.14 under Win2000 service-pack4.
We have a server with two Pentium-III MMX 500Mhz proccesors and 780MB Ram.
We work with InnoDB tables. We have reserved 300MB to InnoDB and use
a RAID 5.
We were working when Mysql/I
Description:
Hello,
When I run the following query:
Select Can as MiCantidad, MiCantidad * 2 from Stocks limit 10
I get the following error:
'The column 'MiCantidad' in field list is unknown'
So, Can I reference to a column by its alias in a
select statement?
Description:
Hello Peter,
Have you explained to Heikki this problem?
Have you fixed it?
Please, tell me about it.
Regards,
Rafa
How-To-Repeat:
Select ... from giros ...
Fix:
-
Synopsis:optimizer bug in the index used by mysql/Inno
Description:
Hello Peter,
I have sent to ftp://support.mysql.com/pub/mysql/secret the table definition
and data (Giros.txt) in a compressed file named Giros.zip so you can
invetigate it.
You can see the following queries:
SELECT TIPO,DOC,NRE
FROM GIROS
WHERE (GIROS.TIPO
Hello,
I am using mysql 4.0.11 and MyODBC 3.51.05 and
Crystal 9 cannot see the tables of a database.
Any ideas?
thanks, Rafa.
__
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/brows
Description:
Hello Alexander,
You wrote:
>From EXPLAIN result output you can do only opposite conclusion: With InnoDB MySQL
>chooses
>to use Index TipoFeVCod for which it expects to match 9417 rows. This is about twice
>less
>rows than expected with PRIMARY key in second explain
Description:
Hello,
I am working with mysql/InnoDb 4.0.11 under Windows 2000.
I have the following table:
CREATE TABLE `giros` (
`Doc` varchar(10) NOT NULL default '',
`Tipo` char(1) NOT NULL default '',
`NRe` varchar(5) NOT NULL default '',
`FoP` char(2) N
Description:
Hi Heikki,
In your case:
>CREATE TABLE t (a INT NOT NULL, PRIMARY KEY (a)) TYPE = INNODB;
>INSERT INTO t VALUES (90); INSERT INTO t VALUES (110);
>User 1:
>SELECT * FROM t WHERE a >= 100 FOR UPDATE;
>User 2:
>SELECT * FROM t WHERE a >= 100 FOR UPDATE;
>
>Now if user 1 tries to
Description:
Hello,
I have a deadlock problem when I try to execute some update sentences
using 'Lock For Update'.
I need to create a new document which is identified by a unique number,
which is stored in the field 'Ped' of the table 'Pedidos'.
To obtain a new document number I add 1 to the co
Hello,
I have some doubts about the index behaviour in InnoDB.
I have a table named 'Albaranes'. The definition is as follow:
CREATE TABLE `albaranes` (
`Cli` varchar(6) NOT NULL default '',
`Alb` varchar(8) NOT NULL default '',
.
.
.
PRIMARY KEY (`Alb`),
UNIQUE KEY `Cliente` (`
Hello,
I have some doubts about the index behaviour in InnoDB.
I have a table named 'Albaranes'. The definition is as follow:
CREATE TABLE `albaranes` (
`Cli` varchar(6) NOT NULL default '',
`Alb` varchar(8) NOT NULL default '',
.
.
.
PRIMARY KEY (`Alb`),
UNIQUE KEY `Cliente` (`
Description:
Hello,
We reported a problem about selecting fields that some of them didn´t belong to
the used index on September.
We have already installed MySql 4.0.4 and we have a similar problem
(and also we are still having the original problem) when we select fields which some
Description:
Hello,
I wrote the following text in my last message (It was an answer to Monty):
>Hello,
> Monty
> I have already sent to pub/mysql/secret the table definition and data
(clientes.txt)
> and my.ini file in a compressed file named clientes.zip.
> You
MySql doesn´t support boolean data type.
Try TinyInt unsigned, with two values: 0 False, 1 True.
Regards,
Rafa
RE: Boolean Data Type in MySQL
__
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscap
Description:
Hello Monty,
I have already sent to pub/mysql/secret the table definition and data (clientes.txt)
and my.ini file in a compressed file named clientes.zip.
You can import clientes.txt and test it.
I have only then problem with InnoDb tables.
I tell you my test
Description:
Heikki,
1) There is only one record with 'GARCIA MANCILLA,S.L'.
2) Mysql reported 53 scanned rows when I ran your mock-up query on your mock-up
table. This is ok.
3) I'm using mysql.exe client (sometimes I use front-end) and i don´t think it
removes the LIMIT 50
Description:
Hello,
I am working with mysqld-max-nt under windows 2000 and unsing InnoDb
tables.
I have the following table:
CREATE TABLE clientes (
Cod varchar(6) NOT NULL default '',
Nom varchar(40) NOT NULL default '',
Nif varchar(10) NOT NULL default '',
Hello,
I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables.
After running the following select:
Select cod,nom from grupos where cod <'005' order by cod desc limit 1
mysqld crashes.
Also it crashes whith limit 10, limit 50, or whatever limit
18 matches
Mail list logo
