In the mysql documentation on upgrading on the mysql website it is
said that it's a better idea to upgrade on a step-by-step bases using
the direct-followup versions of MySQL every time and not to upgrade
jumping a couple versions (ex. from 3.22 to 4.0, skipping 3.23). I would
like to know
Does anybody know what the planned release date is for MySQL 4.1
Official release (not Gamma).
--
Petrus Venter
Hetzner Africa
Tel: +27 21 970 2000
Fax: +27 21 970 2001
Email Disclaimer: http://www.hetzner.co.za/index.php?id=245
[ * Awarded Top 50 ICT Company in South Africa for the period
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String = Green Apple
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type like '%Green
Hi,
I'm doing a query on the following table:
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| time_utc | int(11) | | PRI | 0 | |
| prefix |
Just to let people know. And BTW, you have to say that you want the
account. Reply off list.
Onlist, I'd like to know how most people back up their Mysql dbs? XML
or direct SQL file? I prefer the latter, although I'd like to hear
from proponents of the former.
--
MySQL General Mailing List
On Thu, 23 Sep 2004, John Meyer wrote:
Just to let people know. And BTW, you have to say that you want the
account. Reply off list.
Onlist, I'd like to know how most people back up their Mysql dbs? XML
or direct SQL file? I prefer the latter, although I'd like to hear
from proponents of
In article [EMAIL PROTECTED],
Dan Tappin [EMAIL PROTECTED] writes:
-Original Message-
From: Harald Fuchs
Sent: Wednesday, September 22, 2004 9:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Custom Auto-Increment Problem
The only difference is when you delete rows inbetween. In this
Last week, I asked this list had others had problems contacting MySQL
AB. I promptly received a short note from
[EMAIL PROTECTED]
It suggested I could respond to that address which I tried to do, but
I get this:
- The following addresses had transient non-fatal errors -
[EMAIL
hello,
I have database with 30 tables [some have over 2000k some other over 4000k rec]
when I want to run a sql with a few conditions the answer is dramatically slow
[over 70 seconds!]
sql-s with one condition usually works well..
how is the corrcet way to optimize the database and sql
Hi,
I want to swap the data in two fields
eg
t1.beds to t1.beds2
and
t2.beds2 to t1.beds
Do i need to temporarily store one of the fields (thinking like a programmer)?
Can you suggest what query I need here pls?
zzapper (vim, cygwin, wiki zsh)
--
vim -c
* DeRyl
I have database with 30 tables [some have over 2000k some other
over 4000k rec]
when I want to run a sql with a few conditions the answer is
dramatically slow
[over 70 seconds!]
sql-s with one condition usually works well..
how is the corrcet way to optimize the database and sql
This is probably due to having indexed only single columns. MySQL uses only
one index per column, meaning if you have a where with two conditions you
need a combined index for the columns used. If there are only indeces for the
single columns, only one index for one condition will be used, the
explain example sql question gives:
table type possible_keys key key_len ref rows Extra
klientslowo range PRIMARY,klientslowo klientslowo 40 NULL 351 Using where; Using
temporary
klientslowa ref klientslowoid klientslowoid 4 klientslowo.klientslowoid 19 Using
index
klient ref
Am Thursday 23 September 2004 13:22 schrieb Stefan Kuhn:
This is probably due to having indexed only single columns. MySQL uses only
one index per column, meaning if you have a where with two conditions you
Sorry, this should read one index per table...
need a combined index for the columns
Hi,
I'm trying to compile my own mysql client program under solaris 9 without luck.
I have the mysql libraries under :
/usr/local/mysql-standard-4.0.20-sun-solaris2.9-sparc/lib and has the
following files:
libdbug.a
libmysqlclient.a
libmysqld.a
libmysys.a
libmygcc.a
libmysqlclient_r.a
Don't I
Hello:
I am having a problem with an (not)updatable ResultSet that I cannot
figure out. The problem is not consistent in that the exact SQL
statements and tables involved will work one time and then fail the
next. There does not appear to be any rhyme or reason as to when or why
it fails. Once
Thanks for the responses, but this isn't what I'm looking for. I'm
looking for a way to make a field or record unchangeable for ANYONE,
including the system administrator. That way, I can have a fairly high
level of assurance that the record is valid and hasn't been tweaked in
any way.
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
- Original Message -
From: B Wiley Snyder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 2:09 AM
Subject: newbie green pea
Hello everyone, I know Rhino gave me a link or something a month ago
but. can anyone give me a link to a tutorial on how to
* DeRyl
explain example sql question gives:
[...]
The first thing to notice: Using temporary... this is to be avoided, if
possible.
The first table read is klientslowo based on the criteria
klientslowo.klientslowo LIKE 'sam%'. Is this a reasonable approach to
solving the query, giving your
I don't think indexes have anything to do with it, unless you have an
index on the prefix field, in which case it might use it for the
grouping. But regardless, you are selecting all 160M records (no index
used) AND doing 160M calculations (no index used) and then grouping
160M records (maybe
Hello guys...
I trying to connect on LOCAL MYSQL SOCKET in
/kiko_SMS/kart/mysql.sock
using Connector/J but the sintax of URL only accept HOSTNAMES...
how connect on Local MySQL Sockets using Connector/J
My system is a Debian Box 3.1 using kernel 2.6.7 and Java ;)
Tnks..
Ricardo,
The best performance solution is to create another column to contain
(time_utc-1004127737) div 86400
Update the table to set this value correctly for every row, then calculate
the value for this column every time you insert more data.
Create an index on prefix and the new column and
The first thing to notice: Using temporary... this is to be avoided, if
possible.
## how is the correct way to avoid that?
The first table read is klientslowo based on the criteria
klientslowo.klientslowo LIKE 'sam%'. Is this a reasonable approach to
solving the query, giving your knowledge of
Hi Everyone.
I'm not sure if this is possible of not, but I want to sort a query by a
comma list. Here is what I'm doing:
SELECT id, title, description
FROM table1
WHERE id IN (4,1,3,6,8,2)
This returns the results ok but they are not in any particular order. I want
the result in the order
This is the third time you have asked this, and it has been answered twice.
Once is enough.
Rui Monteiro wrote:
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String = Green Apple
The fact that you are joining 10 tables together in one query may be a
major portion of your performance problem. Even if the *average* size of
each table is only 10 rows, the MySQL engine will have to pour over
10x10x10x10x10x10x10x10x10x10 = 10 to the 10th power = 1e10 =
10,000,000,000 (10
In article [EMAIL PROTECTED],
Andrew Dixon - MSO.net [EMAIL PROTECTED] writes:
Hi Everyone.
I'm not sure if this is possible of not, but I want to sort a query by a
comma list. Here is what I'm doing:
SELECT id, title, description
FROM table1
WHERE id IN (4,1,3,6,8,2)
This returns the
Try the following sintax:
Select * from fruits
where
(fruits.color like '%Green%' or
fruits.color like '%Apple%')
or
(fruits.type like '%Green%' or
fruits.type like '%Apple%');
Regards,
Laercio.
-Original Message-
From: Rui Monteiro [mailto:[EMAIL PROTECTED]
Sent: quarta-feira,
It won't be fast, but
SELECT id, title, description
FROM table1
WHERE id IN (4,1,3,6,8,2)
ORDER BY FIND_IN_SET(id, '4,1,3,6,8,2');
See the manual for more
http://dev.mysql.com/doc/mysql/en/String_functions.html.
Michael
Andrew Dixon - MSO.net wrote:
Hi Everyone.
I'm not sure if this is
Hi,
help me in getting answer for the following
What is the difference in MySql between transaction-safe tables (like Innodb or BDB)
and non-safe
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to this
Excellent. Worked like a dream. Thanks.
Andrew
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Harald Fuchs
Sent: 23 September 2004 15:14
To: [EMAIL PROTECTED]
Subject: Re: Sorting by a comma list
I think
SELECT id, title, description
FROM table1
WHERE id
Nissim Lugasy wrote:
Hi,
I'm trying to compile my own mysql client program under solaris 9
without luck.
I have the mysql libraries under :
/usr/local/mysql-standard-4.0.20-sun-solaris2.9-sparc/lib and has the
following files:
libdbug.a
libmysqlclient.a
libmysqld.a
libmysys.a
libmygcc.a
I'm interested in this, too. We have a logging table that
sees hundreds of rows per second, and we do a ton of monthly
reports. We just bit the bullet and added an indexed DATE
column. Is there a better strategy?
Eamon Daly
-
I installed PHP 4.3.1 via source and used the following option when
configuring:
./configure --with-mysql
The database has worked great for a couple of years, however I noticed a
problem today.
Phpinfo() returns MySQL Version 3.23 from a php script.
Client API version
DeRyl [EMAIL PROTECTED] wrote on 09/23/2004 09:51:45 AM:
The fact that you are joining 10 tables together in one query may be a
major portion of your performance problem. Even if the *average* size of
each table is only 10 rows, the MySQL engine will have to pour over
On Thursday 23 September 2004 04:44 am, Patrick Connolly wrote:
Last week, I asked this list had others had problems contacting MySQL
AB. I promptly received a short note from
[EMAIL PROTECTED]
It suggested I could respond to that address which I tried to do, but
I get this:
- The
Hello,
I have a db with abount 8 lines in it. I now like to count the lines
where the first char of the id is d:
mysql select count(id) from test where left(id,1) = d;
+---+
| count(id) |
+---+
| 0 |
+---+
1 row in set (1.83 sec)
mysql
On Thu, 23 Sep 2004 11:03:08 +0100, wrote:
Hi,
I want to swap the data in two fields
eg
t1.beds to t1.beds2
and
t2.beds2 to t1.beds
do I need to store one of the fields temporarily?
Hey chums you normally get me an answer in minutes, is my question too easy?
zzapper (vim, cygwin, wiki
Alexander Newald [EMAIL PROTECTED] wrote on 23/09/2004 15:57:51:
Hello,
I have a db with abount 8 lines in it. I now like to count the lines
where the first char of the id is d:
mysql select count(id) from test where left(id,1) = d;
+---+
| count(id) |
I installed PHP 4.3.1 via source and used the following option when
configuring:
./configure --with-mysql
The database has worked great for a couple of years, however I noticed a
problem today.
Phpinfo() returns MySQL Version 3.23 from a php script.
Client API version
On 09/23/2004 9:37 AM, Stembridge, Michael [EMAIL PROTECTED] wrote:
I installed PHP 4.3.1 via source and used the following option when
configuring:
./configure --with-mysql
The database has worked great for a couple of years, however I noticed a
problem today.
Phpinfo() returns
Problem: Trying to install php-mysql on a Fedora2 opteron box.
error: Failed dependencies:
libmysqlclient.so.10()(64bit) is needed by php-mysql-4.3.8-2.1
I know... Its an old one, but a good one. I thought I had jumped through all
the backwards compatabile hoops...
The thing is:
rpm -qa | grep
alter table keywords change key_id page_id int(10) unsigned NOT NULL PK
auto_increment;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'PK auto_increment' at line 1
I'm trying to change
Please, NOTE : if you wish to have news about the 2005 Erice meeting,
Evolving Methods in Macromolecular Crystallography, 12 to 22 May
then click ontohttp://crystalerice.org
Coming soon after :
2006: Structure and Function of Macromolecular
So I assume the version of MySQL bundled with PHP 4.3.1 is in fact
3.23.49
and this is overriding my standalone installation.
It's not overriding anything, it's doing what you asked: in your configure
you told PHP to use its built-in (MYSQL_MODULE_TYPE) MySQL support.
Without
I am running MySQL 4.0.17 on QNX 6.2.1B.
When I run the mysql client, mysql, it hangs. There is no output even
when I do:
mysql -v -v -v
I can see that the MySQL daemon is running:
# ps -ef | grep mysql
0 901147 1 - Sep23 ?00:00:00 /bin/sh
I have a table that i am modifying the schema of, and am having a particular
problem with my data migration program. The old format has a column defined
as:
Range char(3) not null default '',
which is either'' or contains a number (1 or 2 digits), and is sometimes
followed by a direction
Stembridge, Michael wrote:
So I assume the version of MySQL bundled with PHP 4.3.1 is in fact
3.23.49
and this is overriding my standalone installation.
It's not overriding anything, it's doing what you asked: in your configure
you told PHP to use its built-in (MYSQL_MODULE_TYPE) MySQL support.
On 09/23/2004 11:11 AM, Stembridge, Michael [EMAIL PROTECTED] wrote:
Without recompiling, is there a way to upgrade the bundled client?
No - I believe you need to recompile PHP (this path assumes an RPM
installation of MySQL):
Yes, MySQL is installed via RPM.
So, when I recompile PHP I
Hi,
I'm using Between to fetch rows whose date column is between two dates.
The thing is, sometimes it brings all the rows including those with a
date similar to the upper limit ( which is the correct behaviour,
according to the manual)
and in other cases it brings al the rows excluding those
Hi there,
I'm finding that DELETE IGNORE doesn't actually ignore all errors when using
InnoDb and trying to remove rows that would result in a foreign key error.
I've checked the docs and think that what I'm doing should work, but
doesn't - I'm using server 4.1.4-gamma:
Welcome to the MySQL
Mauricio Pellegrini wrote:
Hi,
I'm using Between to fetch rows whose date column is between two dates.
The thing is, sometimes it brings all the rows including those with a
date similar to the upper limit ( which is the correct behaviour,
according to the manual)
and in other cases it brings
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 5:27 PM
Subject: Re: Using keys and left()
Alexander Newald [EMAIL PROTECTED] wrote on 23/09/2004 15:57:51:
Hello,
I have a db with abount 8 lines in it. I now
At 10:04 AM 9/23/2004, you wrote:
On Thu, 23 Sep 2004 11:03:08 +0100, wrote:
Hi,
I want to swap the data in two fields
eg
t1.beds to t1.beds2
and
t2.beds2 to t1.beds
do I need to store one of the fields temporarily?
Hey chums you normally get me an answer in minutes, is my question too
Thanks,but I've also tried the date() function
to compare only the date part of the column
like this
select * where date(date_col) between date(startdate) and
date(enddate)
and the result is the same.
On Thu, 2004-09-23 at 11:04, gerald_clark wrote:
Mauricio Pellegrini wrote:
Hi,
On Thu, 23 Sep 2004 13:31:03 -0500, wrote:
At 10:04 AM 9/23/2004, you wrote:
On Thu, 23 Sep 2004 11:03:08 +0100, wrote:
Hi,
I want to swap the data in two fields
eg
t1.beds to t1.beds2
and
t2.beds2 to t1.beds
do I need to store one of the fields temporarily?
Hey chums you
MySql doesn't support Guids but we were attempting to use a VarChar. We set
the VarChar to binary, but from what I'm reading the binary setting doesn't
affect storage just sorting and evaluations.
I was able to get the binary storate I needed in a TinyBlob but I can't set
this to a primary
Can I run two different versions of MySQL on the same server? I've got a
commercial application for which the vendor will only support MySQL 3.x
and makes no guarantees if running MySQL 4. But I'd like to migrate a
number of our own web applications to MySQL 4. My choices are take my
Sorry ,
You were right. I was mistaken the results
Between works just fine. It was me.
I'm Very sorry
Thank you all
On Thu, 2004-09-23 at 15:45, Mauricio Pellegrini wrote:
Thanks,but I've also tried the date() function
to compare only the date part of the column
like this
select *
Yes
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 3:44 PM
To: [EMAIL PROTECTED]
Subject: Two versions on same server?
Can I run two different versions of MySQL on the same server? I've got a
commercial application for which the vendor
At 12:12 -0400 9/23/04, leegold wrote:
alter table keywords change key_id page_id int(10) unsigned NOT NULL PK
auto_increment;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'PK
Good Afternoon.
I'm interested if any DBAs on the list have a set of scripts they run
after a server restart to pull commonly accessed data into the the query
and key caches. I'm currently working on a script that will run various
queries from our application against the database servers
See the manual http://dev.mysql.com/doc/mysql/en/Multiple_servers.html for
details.
Michael
Tucker, Gabriel wrote:
Yes
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 3:44 PM
To: [EMAIL PROTECTED]
Subject: Two versions on same server?
Can
On Thu, 23 Sep 2004 08:20:39 -0400, Jesse W. Asher
[EMAIL PROTECTED] wrote:
Thanks for the responses, but this isn't what I'm looking for. I'm
looking for a way to make a field or record unchangeable for ANYONE,
including the system administrator. That way, I can have a fairly high
level
On Thu, 23 Sep 2004 15:51:56 -0500, Paul DuBois [EMAIL PROTECTED] said:
At 12:12 -0400 9/23/04, leegold wrote:
alter table keywords change key_id page_id int(10) unsigned NOT NULL PK
auto_increment;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that
Everyone,
Thanks for the help. I'm not sure why because I swear on everything
holy that I didn't change anything, but the query now works as desired.
Rather than using BETWEEN, I'm just using = and =. Perhaps I was
missing a quote or something in my old query that was causing it to
return
Never mind. I installed MySQL from a different location and now it
works.
...Stephen
-Original Message-
From: Stephen Rasku [mailto:[EMAIL PROTECTED]
Sent: September 23, 2004 9:32 AM
To: [EMAIL PROTECTED]
Subject: MySQL client hangs
I am running MySQL 4.0.17 on QNX 6.2.1B.
On 23-Sep-2004 Eamon Daly wrote:
I'm interested in this, too. We have a logging table that
sees hundreds of rows per second, and we do a ton of monthly
reports. We just bit the bullet and added an indexed DATE
column. Is there a better strategy?
I do something similar but with MEDIUMINT.
First, you should keep threads on the list.
Second, I'm confused. Didn't you say that you already have
libmysqlclient.so.10 in /usr/local/openv/lib?
If you need to get a new one, it apppears that to get it on Solaris, you
need to build from source.
Michael
Nissim Lugasy wrote:
where can I
At 4:00 7/27/04, Paul DuBois wrote:
At 16:22 -0500 7/26/04, Ghate, Shishir wrote:
I looked at the SHOW COLUMNS statement and they have what I want,
but I need to condition off them. For example, I don't want to
execute an ALTER TABLE command to add a column if that column is
already there.
On Thu, 23 Sep 2004 17:20:17 -0700, Kyle Kirkland [EMAIL PROTECTED] wrote:
Any chance 'IF EXISTS' being added to the 'ALTER TABLE' statements?
It sure would be nice to execute something like:
ALTER TABLE tmp ADD INDEX joy ( to, the, world ) IF EXISTS;
Make that 'IF NOT EXISTS'. Sorry...
Dear All,
Siapa mau account gmail?
Gratis 2 account.. Tanpa bayaran, tanpa uang..
Silahkan pm saya..
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I was wondering if anyone wants to help me with this project.
I already have a test database we can use, I just need help making the team
pages.
please take a look and reply if interested.
thanks in advance
I'm a noobie in regards of php but I am trying to learn.
Hi Haitao.
I'm in the process of developing one of these for the company I work for.
Feel Free to drop me a line and we'll see how we can get it going for you.
Regards
Ian
Haitao Jiang wrote:
Hi,
We want to test our MYSQL (4.1.4g) server's query performance, and I
just wondering if there is a tool
75 matches
Mail list logo