Hello sheeri,
Friday, May 5, 2006, 9:25:18 PM, you wrote:
sk You're comparing apples to oranges -- your where clauses are
sk different. The first query uses the primary key because you're
sk actually comparing 'account' to something. The second query doesn't
sk because you're using the
Hello All,
I have a next problem. After upgrade from 4.1 branch to 5.0,
the productivity of our applications has decreases too much.
Below is a tipical case.
Table 'account' has primary(department,account) and 40777 records.
Table 'payment' primary(department,account,year,month) and 3831797
Hello mysql,
May be, I'm a stupid...
create procedure test () select 1;
mysql call test();
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.05 sec)
In C:
mysql=mysql_init(NULL);
mysql_real_connect(mysql, NULL, User, pwd, test, MYSQL_PORT, NULL, 0);
mysql_query(mysql, call test());
Hello Juri,
Tuesday, April 25, 2006, 5:49:25 PM, you wrote:
JS mysql=mysql_init(NULL);
JS mysql_real_connect(mysql, NULL, User, pwd, test, MYSQL_PORT, NULL, 0);
JS mysql_query(mysql, call test());
JS results to error: PROCEDURE test.test can't return a result set in the
given context
JS
Hello mysql,
Union on zerofilled fields eats 'zerofilling'.
How to repeat:
create table a (id integer zerofill);
insert into a values(1),(2),(3);
select * from a;
++
| id |
++
| 01 |
| 02 |
| 03 |
++
select * from a
Hello mysql,
When trigger on table uses select from same table, then bulk insert into
this table cause error.
How to repeat:
create table t(i int not null, j int not null, n numeric(15,2), primary
key(i,j));
create table s(i int not null, n numeric(15,2), primary key(i));
delimiter //
Hello All!
left(),right(),mid(),etc functions
+
with fixed point return value for function (or out parameter for sp)
---
result has been truncated
How to repeat:
mysql drop function if exists test;
mysql drop function if exists test1;
mysql delimiter //
mysql
Hello mysql,
Is mysqldump from 5.0 dumping a stored procedures?
If it isn't, then when (if planned)?
--
Best regards,
Juri mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello miguel,
Tuesday, October 19, 2004, 10:52:03 PM, you wrote:
ms Hi,
ms Thank you for reporting this bug, I already opened the below
ms bug report:
ms http://bugs.mysql.com/bug.php?id=6165
How to repeat:
create table t0 (id int not null auto_increment primary key,
foo enum('a','b','o')
Hello mysql,
Using 'int not null' make next enum (using cp1251) corrupted in
mysqldump output on W2000.
Is this a known issue?
How-to-repeat:
---
drop table if exists t1;
drop table if exists t2;
create table t1 (a int, b enum('','')) DEFAULT CHARACTER SET cp1251;
create
Hello mysql,
This bug make impossible to use backup with 'mysqldump','mysql' pair.
How-to-repeat:
---
drop table if exists t1;
drop table if exists t2;
create table t1 (a int, b enum('','')) DEFAULT CHARACTER SET cp1251;
create table t2 (a int not null, b enum('',''))
Hi!
Win2000, MySql 4.1.1-alpha, cp1251
select '' like '%%'- 1
select ' ' like '%%'- 0
It's a pity 8(
Hint :
select ' ' like '%%%'- 1(change leading % to %%)
Variables:
character_set_system=utf8
character_set_server=cp1251
character_set_database=cp1251
Hi!
Was 'mysql_connect' purposely excluding from libmySQL.dll export clause or
by accident?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 1:36 PM
Subject: Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?
You can use:
SELECT SUBSTRING_INDEX(CONVERT(USER() USING cp1251),'@',1);
SELECT
Thanks for reply!
1. mysql -u root -e create database t; show create database t; drop
database t
2. mysql -u root -e use_mysql; create database t; show create database
t; drop database t
1.| t| CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET
cp1251 */
2.| t| CREATE
I have the same problem with cp1251 and, seems, it's a bug. I have posted
correspoding message two days ago. Without any reply 8(((
I migrate 3.23.55 - 4.1.1 and I don't know about existing such problem in
4.0.
Look in your table.frm - your field is in correct charset. More of,
inserts and
Hi!
Latin1 is the default as i know.
Let's check:
2.3.3 Typical configure Options
4.7 MySQL Localisation and International Usage
I know this. BUT, when I set def char set = cp1251 and do
CREATE DATABASE lalala
I get new database created in latin1
Is this a bug?
--
MySQL General Mailing
Hi! Is this a bug?
in my.cnf:
[mysqld-4.1]
skip-locking
default-character-set=cp1251
default_collation=cp1251_general_ci
key_buffer=16M
skip-innodb
skip-bdb
after server start:
show variables like '%character_set%'
character_set_servercp1251
character_set_systemutf8
- Original Message -
From: Juri Shimon [EMAIL PROTECTED]
To: Victoria Reznichenko [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 12:56 PM
Subject: Re: Bug in 4.1.1 Internationalization on Windows2000 ?
Hi!
What does 'SHOW CREATE DATABASE database_name;' show
Hi!
How I can set server variable character_set_system to cp1251 ?
I can use xxx'char' construction - but I need a downward compatibility.
I can select USER() and parse result on clientside - but I wan't rewrite
existing client apps.
mysql -u root -e select
Hi!
create table t(a enum ('','',''));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
and this is a bug!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi!
create table t(a enum ('','',''));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
But a bug in what?
CREATE TABLE `t` (
`a` enum('','','') default NULL
) TYPE=MyISAM
Which sounds fine to me (except
Hi!
create table t(a enum ('','',''));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
firstly, upgrade you mysql to current stable version (4.0.16).
I need 4.1, not 4.0 8)
and imho you need
Hi!
In my.cnf:
[mysqld]
...
default-character-set=cp1251
default_collation=cp1251_general_ci
...
Then, after
show variables like '%character%'
I have:
character_set_servercp1251
character_set_clientcp1251
character_set_connectioncp1251
character_set_resultscp1251
Hi!
Is it a bug?
C:\mysqlmysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 3.23.55-max-nt
mysql create database R;
Query OK, 1 row affected (0.06 sec)
mysql grant all privileges on `R%`.* to b;
Query OK, 0 rows affected
Hi!
Is it a bug?
C:\mysqlmysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 3.23.55-max-nt
mysql create database R;
Query OK, 1 row affected (0.06 sec)
mysql grant all privileges on `R%`.* to b;
Query OK, 0 rows affected
26 matches
Mail list logo