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
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
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
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
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!
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)
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 do INSERT
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
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 can
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!
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
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