Juha,
select dep.Ref, dep.ActionDate as Departure, arr.ActionDate as Arrival,
dlv.ActionDate as Delivery
from
Table1 dep left join Table1 arr on (dep.Ref = arr.Ref and arr.Timestamp =
'ARR')
left join Table1 dlv on (dep.Ref = dlv.Ref and
dlv.Timestamp = 'DLV')
where
Devi,
As I understand you need to update timestamp field in some tables.
And you have only 4-5 milliseconds for it?
Is it correct? What is the problem?
Best regards,
Mikhail.
- Original Message -
From: Devi Annisetty [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Mikhail
in the documentation.
Thank you.
Best regards,
Mikhail.
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 21, 2002 1:20 PM
Subject: Re: Timestamp field in the InnoDB table
Mikhail,
- Original
Hi,
I have found one unclear place for me regarding to the timestamp field in
the InnoDB table.
Please, explain me am I correct or not.
Let's say we have a table Test with 'timestamp' field:
CREATE TABLE `Test` (
`id` int(3) NOT NULL auto_increment,
`UpdateDate` timestamp(14) NOT NULL,
Hi
mysql SELECT prezzo, totale FROM ordini WHERE numordine=1157;
mysql UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
WHERE numordine1385 AND dataord'2003-06-01';
You are selecting data for numordine = 1157, but are updating all records
that have
numordine 1385. 1157 1385.
Try to use 'concat()' function.
if ('stop' 'start', stop, concat(stop,'+++'))
Best regards,
Mikhail.
- Original Message -
From: Fabrizio Tivano [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 13:07
Subject: possible query?
hello dear all,
i need to make a
Hi all,
My MySQL crashed during simultaneous execution of ALTER TABLE ... ENABLE
KEYS
and SHOW TABLE STATUS statements.
There were 2 threads: #3 and #4.
In thread #4 I executed:
4 Query DROP TABLE IF EXISTS History
4 Query CREATE TABLE History ...
4 Query
I am new to MySQL, can any body tell me how to write store procedures in
MySQL.
MySQL doesn't support stored procedures yet.
and How to run the same in command line. This will help me very much.
But you can create text fle with SQL commands and then run it from command
line:
mysql -h host
Hi all!
I am using MySQL (version 3.23.51-max-log). I have a problem with locking.
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(10)
All I need is a list on the Usernames that are in one column but not the
other.
SELECT table1.Username
FROM table1 left join table2 on (table1.Username = table2.Username)
WHERE table2.Username is NULL;
Mikhail.
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: Mysql
When I run this comman I insert 253 records into ur_rights. If I runn the
comman without the insert statement it returns 33,483 records.
As result of insert command you have to receive stat info like this:
---
Records: 100 Duplicates: 0 Warnings: 0
---
Which values do you
I just tried to do this on my MySQL server (version 3.23.51-max-log). It
works fine.
Mikhail.
- Original Message -
From: Anil Garg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 4:59 PM
Subject: Lost Connection to mysql server during query
Hi,
Here is a
Hi all,
I am using MySQL (version 3.23.51-max-log). I have a problem with locking.
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(10)
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, June 28, 2002 1:29 AM
Subject: InnoDB: Lock wait timeout problem. Please help.
Hi all,
I am using MySQL (version 3.23.51-max-log). I have a problem with
locking.
Let's assume
test where id = 3 with lock in share mode;
or
Conn2: select id, name from test where id = 3 with for update;
then everything works perfect...
Mikhail.
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent
(C.CompanyID) = 2. In
this case it will take:
C.CompanyIDC.B2bCount(C.CompanyID)
77N2
Best regards,
Mikhail.
- Original Message -
From: Arul [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Saturday, June 29
Jonas,
try to execute this command:
SELECT count(1) FROM table_name;
Result should be 28. Do you have 28?
Mikhail.
- Original Message -
From: Jonas Olofsson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 29, 2002 11:20
Subject: Hidden rows in table.
Hi.
I have just
Joonas,
checking for MySQL library directory... configure: error: Didn't find
the mysql library dir in ''
I had the same problem couple days ago, and I fixed it manually (just edit
configure.in file).
In this file path to MySQl library directory is
/usr/local/mysql/lib/mysql, I changed it to
Jesse,
try to make dump (mysqldump) with option --add-drop-table or --opt (it
will be faster).
Description of this options see here
http://www.mysql.com/doc/m/y/mysqldump.html
Best regards,
Mikhail.
- Original Message -
From: Jesse Sheidlower [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Marek,
check this URL http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Best regards,
Mikhail.
- Original Message -
From: Marek Wysmulek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 01, 2002 6:56 PM
Subject: efficiency of mysql 2.23
Dear group.
I have on server Intel
select u.userid , c.companyname from
users u left join company c on (u.companyid = c.companyid)
where u.status = 'ACT'
Best regards,
Mikhail.
- Original Message -
From: Arul [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 5:15 PM
Subject: help me with this
Hi Mike,
I am not sure, but as I remember Microsoft SQLServer has Import/Export
utility (standard installation) that can import data from different sources
(Oracle?! why not).
Best regards,
Mikhail.
- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I had the same problem.
It occurs when you try to load (3.23.51 or higher) dump file to lower
version of MySQL.
Look at this line...
/*!4 ALTER TABLE mobile_dev DISABLE KEYS */;
As soon as version is not equal 4 everything in comments will be
deleted.
So we have
;
empty query.
* Pushkar Pradhan
I'm trying to enforce one column of my table to contain strictly 6 chars.
string. However I've some columns of type VARCHAR (e.g name, etc.) so
mysql silently changes the column to VARCHAR.
It is ok for MySQL. You can find some info here :
Oleh,
SELECT t1.id, Max(t2.data)
FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id
GROUP BY t1.id
HAVING Max(t2.data) IS NULL;
As temporary solution try to use next query:
SELECT t1.id, Max(t2.data) as MaxData
FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id
GROUP BY t1.id
Reinier,
It seems that when i do a select and the result is minimal it uses the
index(fast about 3 sec), but when the result is much more it is not using
the index. this results in a lot of disk io and taking to much time.
It is correct, because
...I'm really hoping to
find is a GUI that updates itself on the fly, kind of like the Win2k
Task Manager processes tab. Anybody got anything like this?
I am really happy with this one http://www.anse.de/mysqlfront/
It can do that and a lot of other nice features.
Best regards,
Mikhail.
Max,
What's wrong with your PC speaker in mysql console?!
I am using the same version and have no problem with it.
Best regards,
Mikhail.
- Original Message -
From: Max Morawski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 10:36 AM
Subject: mysql console
speaker in OS settings.
3. Just turn off speaker totally (remove it from your PC :)
Best regards,
Mikhail.
- Original Message -
From: Max Morawski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 10:45 AM
Subject: Re: mysql console buzzer problem
Mikhail Entaltsev wrote
Mikhail Entaltsev wrote:
It's making loud noise on each error. It is *extremely* annoying.
Try to use these ways:
1. -s, --silent option in mysql console. I don't know what does it mean
(in
doculmentation I found only Be more silent.), but may be it will help
you.
No change.
2. Generally
I'd like to find all the records that contains this : wr??
That's why I did this query : SELECT * FROM table WHERE rights LIKE
'wr??'
Try to use this one:
SELECT * FROM table WHERE rights LIKE 'wr%' (It means everything that
begins from 'wr')
Next point:
'?' - it is not pattern in
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
Best regards,
Mikhail.
- Original Message -
From: Nicolas Ivering [EMAIL PROTECTED]
To: [EMAIL
Answer a left join Account c on (a.AccountID = c.AccountID) left join
Person p on (c.PersonID = p.PersonID)
:)
Best regards,
Mikhail.
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: Nicolas Ivering [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, August 19, 2002 10
Robert,
... WHERE field LIKE '%search%'
means everything that contains search.
Examples: abcsearch, searchabc, abcsearchabc.
But it doesn't mean abcearch, searcabc, searc.
Best regards,
Mikhail.
- Original Message -
From: Robert Macwange [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
select
m.Name,
mp1.Points as Round1,
mp2.Points as Round2,
mp3.Points as Round3,
mp4.Points as Round4,
mp5.Points as Round5
from
member m,
member_points mp1,
member_points mp2,
member_points mp3,
member_points mp4,
member_points mp5
where
m.Id = mp1.Member__id
and m.Id =
As first step, try to optimize table with help of
OPTIMIZE TABLE MyTable
command.
Any progress?
Best regards,
Mikhail.
- Original Message -
From: David BORDAS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 12:34 PM
Subject: Slow select query, need some clues to
Already done something like optimize :
myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
And? No result?
Mikhail.
P.S. Can you send a copy to mysql-list, please.
- Original Message -
From: David BORDAS [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Sent
Check the query plan
EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR
Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
Mikhail.
- Original Message -
From: David Bordas [EMAIL
Can you send result of the query, please:
select * from MyTable PROCEDURE ANALYSE();
Mikhail.
- Original Message -
From: David Bordas [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 2:13 PM
Subject: Re: Slow select query
IMHO the problem is in this condition
...Field5 LIKE '%John'...
Can you remove it from query and try again?
Mikhail.
- Original Message -
From: David Bordas [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 2:49 PM
Subject
actually need this condition? ;)
Best regards,
Mikhail.
- Original Message -
From: David Bordas [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 3:31 PM
Subject: Re: Slow select query, need some clues to speed it up please
be occasionally anybody run another big query in parallel? in other case
I have no idea... :(
Mikhail.
- Original Message -
From: David Bordas [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 4:28 PM
Subject: Re: Slow select query
PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 5:16 PM
Subject: Re: Slow select query, need some clues to speed it up please ...
ME In this case...
ME Can you try again?
Sure.
query 1 :
SELECT Field1,Field2,Field3,Field4,Field5,Field6
Wouter,
set @ID = 173633;
select @Name := Name from MyTable where ID = @ID;
select @Name;
Best regards,
Mikhail.
- Original Message -
From: Wouter van Vliet [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Wouter @ Witbier [EMAIL PROTECTED]
Sent: Friday, August 30, 2002 5:59 PM
Subject:
Xavier,
select
ID,
description,
if (ifnull(date1, 20201231) ifnull(date2, 20201231), ifnull(date1,
20201231), ifnull(date2, 20201231)) as date
from MyTable
order by date
I didn't test it, but it should work.
Any questions? don't hesitate to ask.
Best regards,
Mikhail.
- Original
Roman,
try to execute this query:
select e.cid,d.amount,dd.amount
from eee e
left join ddd d on (d.cid=e.cid and d.c=2 and d.c=3)
left join ddd dd on (dd.cid=e.cid and dd.c=3)
and after that try to group by them manualy. What do you have as result?
Best regards,
Mikhail.
- Original
Prafulla,
please check documentation http://www.mysql.com/doc/en/DATETIME.html
...
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
multiple TIMESTAMP columns, only the first one is updated
Check TIMESTAMP type in the documentation.
Best regards,
Mikhail.
- Original Message -
From: neal [EMAIL PROTECTED]
To: mySQL [EMAIL PROTECTED]
Sent: Wednesday, September 18, 2002 10:32 AM
Subject: date field - default value = current date
Is there a wat to have mySQL auto fill in
Peter,
If you would like to get such resultset
namefield1 field2 field3field4 field5 field6
-
test 12 5 6 9 10
test 12 5
[EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 11:56 AM
Subject: Re: Re: JOIN-Question
Hi Mikhail!
The query should be released automaticly and it shoulb be something like:
SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5
Hi
I have 2 MySQL servers:
Server1 is 3.23.55-max-log
Server2 is 4.0.13-standard-log
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name`
this. You are probably using the query cache in 4.0. Then
SELECT can return immediately without acquiring any locks.
Of course, it can be discussed if the query cache, too, should respect
LOCK
TABLES. I am forwarding this to Sanja.
Thank you,
Heikki
- Original Message -
From: Mikhail
Paul,
if your MySQL server is runnign under Linux then try to play with
innodb_flush_method variable.
I've changed it to O_DSYNC and InnoDB became ~ 9 times faster (Suse 8.2
Linux 2.4.20-4GB i386).
Also check that you didn't allocate too much memory (OS shouldn't swap).
Best regards,
Mikhail.
fdatasync() or O_DSYNC
because there have been problems with them on many Unix flavors.
**
Mikhail.
- Original Message -
From: Paul Gallier
To: Mikhail Entaltsev ; [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 4:24 AM
Subject: Re: InnoDB slow?
Thanks
Hi,
I've found the phrase in MySQL documentation
http://www.mysql.com/doc/en/Temporary_table_problems.html
You can't use temporary tables more than once in the same query. For
example, the following doesn't work.
mysql SELECT * FROM temporary_table, temporary_table AS t2;
Does it mean that I
Hi,
IMHO it's nice idea...
http://www.ashleyit.com/blogs/brentashley/archives/000339.html
Best regards,
Mikhail.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Edwin,
check this link. Hope it will help you.
http://www.mysql.com/doc/en/Resetting_permissions.html
Best regards,
Mikhail.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 12, 2003 7:22 PM
Subject: How to recovery the root password?
Dear
Hi,
Does InnoDB use any of these variables:
bulk_insert_buffer_size
join_buffer_size
key_buffer_size
read_buffer_size
read_rnd_buffer_size
sort_buffer_size
table_cache
thread_concurrency
Thanks in advance,
Mikhail.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi,
You need to use UNION, but it's not possible in version 3.23.*
So it's better to upgrade MySQL server first.
SELECT table1.cod
FROM table1
LEFT JOIN table4 ON table1.cod=table4.cod
WHERE table4.cod IS NULL
UNION
SELECT table2.cod
FROM table2
LEFT JOIN table4 ON table2.cod=table4.cod
WHERE
Hi,
I am using these lines in my.cnf at [mysqld_safe] section.
[mysqld_safe]
timezone = GMT
It works fine for me.
Best regards,
Mikhail.
- Original Message -
From: Juan Antonio Ruiz Zwollo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 5:38 PM
Subject: Setting
variable into [mysqld]
section,
but you need to put it into [mysqld_safe] section. But I am not sure. Check
it, please.
Best regards,
Mikhail.
- Original Message -
From: Juan Antonio Ruiz Zwollo [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October
Hi,
If I understand you correctly the this query should help you:
select
date_format(date_add(DateTime, interval 7 hour), %Y%m%d) as Date,
count(1)
from Table1
group by Date
order by Date
Best regards,
Mikhail.
- Original Message -
From: Graeme B. Davis [EMAIL PROTECTED]
To:
Hi,
I would create one field (char(200) or char(255)) for all criteria.
After that I will store:
in the first byte of that string Y if hotel has swimming pool, N - doesn't
have, Q - no idea
in the second byte of that string Y if hotel has TV, N - doesn't have, Q -
no idea
in the third byte of
show statusHi all,
I am running MySQL version 4.0.14-standard-log on Suse Linux 2.4.20 i686.
All tables in my db are InnoDB tables.
Today morning I've got troubles with perfomance...
Generally all queries are slower in 4-5 times than usually.
Also I see that number of deadlocks is in 10-15
Forgot to mention...
OS is not swapping... The load on MySQL server is the same...
Usually my system has ~100 selects/sec and 0.2 inserts/sec.
And I found that during inserts MySQL uses 100% of CPU,
before it used ~5-10% CPU maximum...
I understand that it's difficult to say what is going
Matthijs,
in the bug report Heikki Tuuri wrote:
***
[13 Apr 20:59] Heikki Tuuri
The bug was introduced in 4.0.24 and 4.1.10. The fix will be in 4.1.12 and
5.0.5.
***
Best regards,
Mikhail.
- Original Message -
From: Matthijs van der Klip [EMAIL PROTECTED]
To: MySQL mailing list
Hi Eric,
you can setup replication on your laptop (master) and your PC (slave).
http://dev.mysql.com/doc/mysql/en/replication.html
Best regards,
Mikhail.
- Original Message -
From: Eric Dahlenburg [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, August 08, 2005 4:12 PM
Hi,
insert into 321st_stat select * from stat_in group by primary key fields
from 321st_stat table;
did you try to use this query?
Best regards,
Mikhail.
- Original Message -
From: matt ryan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 6:06 PM
Subject: 1
Could you execute show create table 321st_stat and show create table
stat_in
and send results back?
Best regards, Mikhail.
- Original Message -
From: matt ryan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, August 27, 2004 4:45 PM
Subject: Re: 1 day 28 min insert
Mikhail
: [EMAIL PROTECTED]
Sent: Friday, August 27, 2004 9:25 PM
Subject: Re: 1 day 28 min insert
Mikhail Entaltsev wrote:
Could you execute show create table 321st_stat and show create table
stat_in
and send results back?
I have no key's on the temp table, stat_in, do you think adding keys
You _could_ try adding an identical primary key to the stat_in table as
you have on the 321st_stat table. However, since we need all of the rows
from stat_in in the results, I am not sure that it will help speed up the
join (because it's a left join). Even though I think the index would be
: [EMAIL PROTECTED]
To: Mikhail Entaltsev
Cc: matt ryan ; [EMAIL PROTECTED]
Sent: Friday, August 27, 2004 10:40 PM
Subject: Re: 1 day 28 min insert
If that were a valid SQL statement, I would agree with you. What you wrote
**only** functions through a MySQL-specific SQL extension that permits
non
select concat(ifnull(Field1,'NULL'), Filed2) from My Table;
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 2:25 PM
Subject: Concat
Hi,
Concat() returns Null if any field in the field list
is Null. How can I use it to return
abs()
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 12:59 PM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where
Hi,
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_buffer_pool_size = 6G
it looks like your InnoDB tablespace is less than 2G.
If it is true then IMHO it doesn't make any sense to allocate 6G for
innodb_buffer_pool.
InnoDB won't use it.
Best regards,
Mikhail.
-
Hi,
I have noticed also that SHOW TABLE STATUS became slower in 5 times at least
(from 1 sec to 5-6 secs).
Since I've switched to version 3.23.53 to version 4.0.14.
But I have changed type of all my tables (~30 tables) from MyISAM to InnoDB
as well.
How long does an ls command in the database
Hi,
First of all, thanks a lot.
I have installed MySQL 5.0.0 on my test machine (Suse Linux 8.2 kernel
2.4.20 i586)
and have populated data (~40 InnoDB tables with max. 50 000 000 rows)
So far it works stable and I didn't have any big problem, but I have found
that speed of inserting data is
Hi,
I have found slides show
http://mysql.progen.com.tr/events/uc2003/slides/stored-procedures.pdf
and examples in mysql-5.0/mysql-test/t/
- sp.test
- sp-error.test
Best regards,
Mikhail.
- Original Message -
From: Rick Robinson [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Sent:
.
Mikhail.
- Original Message -
From: Rick Robinson [EMAIL PROTECTED]
To: 'Mikhail Entaltsev' [EMAIL PROTECTED]; 'Mysql'
[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 2:27 AM
Subject: RE: 5.0 binary question
Hi Mikhail-
Thanks for responding; the presentation is very helpful; However, I
Hi Terence,
Just a dumb question perhaps, but I am looking at upgrading to 5.0, and as
we are
happy with the performance and features on 4.1, can we expect the same
features
to have the same level of stability on 5.0?
I wouldn't expect the same level of stability if you would like to use
you have been using as a test.
- Forwarded message from Mikhail Entaltsev [EMAIL PROTECTED] -
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: MySQL list [EMAIL PROTECTED]
Subject: Re: MySQL 5.0.0 has been released
Date: Mon, 29 Dec 2003 14:45:24 +0100
Hi,
First of all, thanks
Hi
You need to install first rpm with dynamic client libraries
(including 3.23.x libraries). You can find them on
http://www.mysql.com/downloads/mysql-4.0.html
Best regards,
Mikhail.
- Original Message -
From: Carlos Andre Moura de Amorim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Try to change localhost in connection string to real IP address or
127.0.0.1.
Actually it is not the fix of the problem it is a workaround.
Best regards,
Mikhail.
- Original Message -
From: Carlos Andre Moura de Amorim [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL
Hi Tom,
Look at the docs:
http://www.mysql.com/doc/en/DROP_TABLE.html
Happy New Year and best regards,
Mikhail.
- Original Message -
From: tom poe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 8:33 AM
Subject: dropping multiple tables with one command
But you can do DROP table1; DROP table2; DROP table3; etc..
You can do even better:
drop table table1, table2, table3;
:)
Best regards,
Mikhail.
- Original Message -
From: Arne K. Haaje [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 02, 2004 12:29 PM
Subject: Re:
Hi,
try to use group by clause in your select, e.g.
select name, city from mytable group by name, city order by name, city;
Best regards,
Mikhail.
- Original Message -
From: Veysel Harun Sahin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 02, 2004 4:42 PM
Subject:
Hi,
Look at /usr/local/mysql/support-files directory.
There are several examples of my.cnf files for different configurations
there (my-huge.cnf, my-large.cnf, ...).
Best regards,
Mikhail.
- Original Message -
From: Kirti S. Bajwa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
Hi Leandro,
It is absolutly correct. Please read in doc about timestamp data type
http://www.mysql.com/doc/en/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you
Hi Asbjørn,
try to use replace function:
http://www.mysql.com/doc/en/String_functions.html
update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ;
Best regards,
Mikhail.
- Original Message -
From: Asbjørn Konstad [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
Hi,
since MySQL stores stored procs in mysql db you need to make backup of
mysql db.
But it would be nice to have a possibility to make backup of stored procs in
readable format.
Best regards,
Mikhail.
- Original Message -
From: Bing Du [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hi Massimo,
May be after some minutes of inactivity client closes connection to MySQL
server?
In this case MySQL deletes all temp tables that were created by this client.
Best regards,
Mikhail.
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 11:08 AM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
no; because the client have still the result of the query on the screen
and
on the server the thread is still
I believe that this will flush those logs:
mysql reset master;
No.. It won't shrink any of InnoDB datafiles:
101Mib_logfile0
101Mib_logfile1
1.9Gibdata1
1.5Gibdata2
It could help if you have some MySQL binary logs:
hostname-bin.001
...
hostname-bin.00N
Best regards,
select t2.* from TableTwo t2 left join TableOne t1 on (t2.ID = t1.ID)
where t1.ID is NULL
- Original Message -
From: Phillip S. Baker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 23, 2004 7:26 AM
Subject: Comparing Table IDs
Greetings all,
I have 3-4 tables of
.
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Sent: Friday, January 23, 2004 5:11 PM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client
running xp
1) yes, I am sure because the problem is reproducible also
Hi,
I have email from Georg Richter about this problem in my MySQL archive:
From: Georg Richter [EMAIL PROTECTED]
Hi,
From http://www.mysql.com/doc/en/Mathematical_functions.html:
Note that the behaviour of ROUND() when the argument is half way between two
2004, Mikhail Entaltsev wrote:
Date: Fri, 23 Jan 2004 09:34:52 +0100
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: Gregory Newby [EMAIL PROTECTED], Asif Iqbal [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: data file too big
I believe that this will flush those logs
Hi,
I'm newbie in MYSQL. Would please tell me about Mysql Security ?
Generally you can find a lot of information about MySQL on
http://www.mysql.com/doc/en/
About your question you can read here:
http://www.mysql.com/doc/en/Privilege_system.html
Mikhail.
- Original Message -
From:
Hi,
show table status;
In the last field (Comment) you could find it.
Mikhail.
- Original Message -
From: Tile Tatonko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 10:48 AM
Subject: available spaci in InnoDB data files !??!
I need help (ASAP).
I'm
Hi,
I am not sure, but may be you had Key_read_requests overflow.
Best regards,
Mikhail.
- Original Message -
From: John David Duncan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 11:40 PM
Subject: key_reads key_read_requests
Hi,
key_reads is usually a
1 - 100 of 109 matches
Mail list logo