In the last episode (Oct 30), Mark said:
> > MySQL 4.0.22, a new version of the popular Open Source/Free
> > Software Database Management System has been released. It is now
> > available in source and binary form for a number of platforms from
> > our download pages at http://dev.mysql.com/downloa
Matt Wagner wrote:
> Hi,
>
> MySQL 4.0.22, a new version of the popular Open Source/Free Software
> Database Management System has been released. It is now available in
> source and binary form for a number of platforms from our download
> pages at http://dev.mysql.com/downloads/ and mirror sites.
Hi,
I a facing a situation where I have two database server in two different
places that has exactly the same database. The thing is if the database
is modified in either one of the places, both database has to be updated
lively.
Can someone tell me who done this already? Please help.
I am looking
I am just now getting the hang of searching through 2 tables, and
getting the corresponding information using a pri & foreign key
(ID1=ID1) kinda thing. How is this done with more than 2 tables?
I had asked on a different forum, but I got some funky select statement
using a left inner join, an
Hi,
How can i increase the size of the log file and log buffer size?
i tried to change it on my.cnf file but it return this error message:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880
bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
041028 0:10:49 C
On Thu, Oct 28, 2004 at 11:50:12AM +0200, Jigal van Hemert wrote:
...
> Fortunately there is function COALESCE() that will return the first argument
> that is not NULL. In case of NULL values you can use a default value for an
> expression: COALESCE( `col`*2, 14) will produce 14 if `col` is NULL.
Hi,
MySQL 4.0.22, a new version of the popular Open Source/Free Software
Database Management System has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all mirror site
I installed mySQL v4.1.7 on windows xp
I changed my.ini file two times with different character set.
First :default-character-set=utf8
and in my application : codepage=utf8
Second : default-character-set=greek
and in my application : codepage=greek
(I live in Greece)
Running my application I see
>
> > I use the following to extract the version number. But it throws an
error
> on
> > newer version 5.xx. It works on version 4.0 and below.
> >
> > SELECT SUBSTRING(VERSION(),1,LOCATE("-",VERSION())-1) AS VERSION
> >
> > On version 5.0.1-alpha-nt-log I get an error...
> > Illegal mix of colla
- Original Message -
From: "Fredrick Bartlett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 29, 2004 12:08 PM
Subject: Extract MySQL Version
> I use the following to extract the version number. But it throws an error
on
> newer version 5.xx. It works on version 4.0
Hi,
I am using MySQL 5.0.1 (snapshot) and PHP 5.0.2 with mysqli interface
(latest snapshot) under Linux (SUSE 9.1).
I would like to call a SP using PHP 5, and I want to get back the SELECT
results.
This is my SP:
CREATE PROCEDURE `test`()
BEGIN
SELECT * FROM t1;
END
From the comments in http:
Hi.
Please read the notes about MySQL on Linux:
http://dev.mysql.com/doc/mysql/en/Linux.html
Do you use the official binary distribution?
[EMAIL PROTECTED] wrote:
>
> Hi!
>
> I searched near and far but could not find the slightest hint
> about what is causing my MySQL problems. I
I use the following to extract the version number. But it throws an error on
newer version 5.xx. It works on version 4.0 and below.
SELECT SUBSTRING(VERSION(),1,LOCATE("-",VERSION())-1) AS VERSION
On version 5.0.1-alpha-nt-log I get an error...
Illegal mix of collations
(utf8_general_ci,IMPLICIT
Jerry Swanson wrote:
How many characters can Longblob hold?
What is the size of longblob?
Why I don't need to specify the size (i.e varchar(200) )?
http://dev.mysql.com/doc/mysql/en/String_type_overview.html>
Regards
Friedhelm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
How many characters can Longblob hold?
What is the size of longblob?
Why I don't need to specify the size (i.e varchar(200) )?
On Wed, 27 Oct 2004 20:09:37 +0300, Gleb Paharenko
<[EMAIL PROTECTED]> wrote:
> Hi.
>
> Use LONGBLOB.
>
>
>
>
> Jerry Swanson <[EMAIL PROTECTED]> wrote:
>
> > Wha
At 19:29 +0530 10/29/04, Anil Doppalapudi wrote:
Is it possible to take incremental backups in mysql.if yes please provide me
links or info on it
Your binary logs are your incremental backups.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General
Is it possible to take incremental backups in mysql.if yes please provide me
links or info on it
Thanks
Anil
DBA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks, that was it exactly.
bob
At 02:25 PM 10/28/2004, Michael Stassen wrote:
Something like
SELECT uid,
AVG(number_grade) AS average_grade,
SUM(IF(letter_grade = 'A', 1, 0)) AS A_count,
SUM(IF(letter_grade = 'B+', 1, 0)) AS B+_count,
SUM(IF(letter_grade =
- Original Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 29, 2004 7:37 AM
Subject: Re: Fw: column choices for certain data
> In article <[EMAIL PROTECTED]>,
> "Rhino" <[EMAIL PROTECTED]> writes:
>
> >> The chief advantage of 'SET', as f
I think it may be because of your mixed left and right joins. There are
several bugs listed that show that the optimizer mishandles certain
combinations of left and right joins.
May I suggest that you re-arrange your query to include only LEFT and
INNER joins (at least until the bugs are worked
Are you sure?
/usr/local/mysql is a symbolic link to another direcory (
/usr/local/mysql(version).
I think the installer overwrite the symbolic link so if you open a
terminal and type:
ls -l /usr/local
Santino
At 16:20 -0700 28-10-2004, Steven Roussey wrote:
Installing MySQL 4.1.7 (upgrading f
Hi Cecep,
On Fri, 29 Oct 2004, Cecep Rosuludin wrote:
> Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> > See INSTALL-BINARY in the distribution directory and follow
> > instructions in it exactly.
> > Don't forget about mysql_install_db!
You appear to have missed this part out below. Don't know if
Cecep Rosuludin wrote:
Dear Gleb,
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R root /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R mysql /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chgrp -R root /var/lib/mysql
[EMAIL P
- Original Message -
From: "Emily Lena Jones" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 7:46 PM
Subject: Re: many-to-many query
>
> Quoting Rhino <[EMAIL PROTECTED]>:
>
>
> > I wasn't sure if you understood the concept of a
THANXS!!! =)
On Thu, 2004-10-28 at 13:37, Gleb Paharenko wrote:
> Hi.
>
> [mysqld]
> ..
> log-error=file
> log=file
>
>
> See:
> http://dev.mysql.com/doc/mysql/en/Server_options.html
> http://dev.mysql.com/doc/mysql/en/Option_files.html
>
>
>
> Victor Medina
In article <[EMAIL PROTECTED]>,
"Rhino" <[EMAIL PROTECTED]> writes:
>> The chief advantage of 'SET', as far as I can tell from the manual, is
> that
>> it lets you control the specific values which can be in a column without
>> having to write application lookups to verify that the value you are
>
Hi.
Everything is OK.
See:
http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
A Z <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> MySql 4.0.14
> How can I force the following query to use a reference
> in table1.
>
> select * from tab
Hi.
I think, the better way for you is to use the official binaries.
M Taylor <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I had no problem with compiling 4.1.2-alpha (or 4.0.x)
> and it has been working fine. But for both
> 4.1.5-gamma and 4.1.7, when I get to make test, all
> the tests fa
Hi Nathan,
Subqueries are only available in MySQL as of version 4.1.
On Fri, 29 Oct 2004, Nathan Coast wrote:
> Hi
>
> apologies if this is a dumb question but can you do subqueries in mysql?
>
> select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
> =2 and UGR.ROLE_ID = (se
Nathan Coast wrote:
Hi
apologies if this is a dumb question but can you do subqueries in mysql?
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = (select ROLE_ID from ACL_ROLE where ROLE_NAME =
'projectmanager' )
this query fails, but the individua
Hi
apologies if this is a dumb question but can you do subqueries in mysql?
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = (select ROLE_ID from ACL_ROLE where ROLE_NAME =
'projectmanager' )
this query fails, but the individual queries work fine
Hi,
MySql 4.0.14
How can I force the following query to use a reference
in table1.
select * from table1 a left join table2 b on (a.field1
= b.field1) order by b.field2 limit 1
both a.field1 and b.field1 have indexes. Explaining
the command indicates that, MySql uses an index
(possible_keys)
Hi.
What subversion of MySQL have you compiled?
>From 4.0.xx and 4.1.xx branches?
MQ <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I was able to compile mysql 4.0 and 4.1 (static) successfully with
> intel compiler 8.0 on an IA32 system running redhat enterprise linux
> 3.0. However when I
Hi.
There are too many things to consider: the size of the table, the load average
of the server, the MySQL configuration, etc. If you could provide us with
much more details - we could check it out and make a guess what's the
bottleneck. Still, anyway you will probably need to optimize your
Hi.
See:
http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
It is ok that MySQL doesn't use indexes when selecting indexed columns that are
compared using the = operator.
You can read how indexes works.
Laszlo Thoth <[EMAIL PROTECT
Hi.
Following documentation, we can see:
"ENUM and SET columns provide an efficient way to define columns
that can contain only a given set of values."
http://dev.mysql.com/doc/mysql/en/constraint_enum.html
But carefully read
http://dev.mysql.com/doc/mysql/en/SET.html
before y
Hi.
Do you use official binaries compiled by MySQL AB?
Also see:
http://dev.mysql.com/doc/mysql/en/Linux.html
Espesially:
http://dev.mysql.com/doc/mysql/en/Linux-OS.html
Check that you have required versions of libraries and you run official binaries.
Aaron <[EMAIL PROTECTED
Hi.
Online docs contains the latest and more complete information.
Mark Day <[EMAIL PROTECTED]> wrote:
> Hello, I was wondering if people consider the on line docs at the mysql
> web site to be equivalent to their books
> regarding the database administration. Does the book go into more
Hi.
[mysqld]
..
log-error=file
log=file
See:
http://dev.mysql.com/doc/mysql/en/Server_options.html
http://dev.mysql.com/doc/mysql/en/Option_files.html
Victor Medina <[EMAIL PROTECTED]> wrote:
> Hi!!!
>
> How can i specify the location of the
On 29 Oct 2004, at 00:37, Mulley, Nikhil wrote:
How do I dump the data from console to the text file from the output
generated by SELECT statement ?
If it's a small answer that you're just trying to save to a file for
note-keeping purposes, you could run
mysql -e 'select * from thing where foo=
On 28 Oct 2004, at 12:48, Anil Doppalapudi wrote:
mysqldump running very slow. what might be the reason
[...]
I don't have specific knowledge of your database, so our answers will
be quite vague, but :
Try running with --opt. This produces a less readable outfile, but
produces one much more qui
41 matches
Mail list logo
