Hello All,
I want a clarification. Whe run a forum wherein people send messages
with/without attachments. Attachments may contain images, documents etc.. We
are actually storing the attachment in a blob column. Sometimes the attachments
are big. And today the table size has grown to 40 GB. This
I found how to bind to addrees to but didn't find anything in my.ini about
skip-networking but now I have this problem where the I can't connect
locally sitting at the computer using hostname localhost if I type in
the IP address of the computer I get a messsage saying "{Hostname} is not
a
Hi,
Ferindo Middleton wrote:
I've installed MySQL5 on a machine running Windows XP. I'm not an advanced
user so I chose all the default configuration settings when I went through
the setup wizard for the server instance. The database works fine and I can
access it when I'm sitting at the compu
I've installed MySQL5 on a machine running Windows XP. I'm not an advanced
user so I chose all the default configuration settings when I went through
the setup wizard for the server instance. The database works fine and I can
access it when I'm sitting at the computer through the command line cl
Hello,
I have several tables storing item information, keyword (mainly for searching),
category and subcategory (also for searching). The query I am using now is:
SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
LEFT JOIN iteminfo it ON i.id = it.id
LEFT JOIN itemkeyword ik ON i.id = ik
Hello,
I have several tables storing item information, keyword (mainly for searching),
category and subcategory (also for searching). The query I am using now is:
SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
LEFT JOIN iteminfo it ON i.id = it.id
LEFT JOIN itemkeyword ik ON i.id =
On 6/21/07, CA Lists <[EMAIL PROTECTED]> wrote:
Note that "uid" 12880 is now AFTER 12878, which is its parent.
Sounds like you want ORDER BY COALESCE(parent, uid) DESC.
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
On 6/21/07, Guillermo <[EMAIL PROTECTED]> wrote:
Hello,
I have a query that i could do in 2 diferent ways...i want to know wich one
is recomended:
* Select T1.field1,T1.field2, (select sum(T2.field4) from Table2 T2 where
T2.field1 = T1.field1) from Table1 T1
or
* Select P1.fie
Does anyone have a clever way that I can sort on two fields? Let me
explain...I need the sort to be by the "uid" field (see below), but also
have the "parent" field taken into consideration:
Here's a sample of what I get now:
+---+---++
| uid | duplicate | parent |
+---+
Hello,
I have a query that i could do in 2 diferent ways...i want to know wich one
is recomended:
* Select T1.field1,T1.field2, (select sum(T2.field4) from Table2 T2 where
T2.field1 = T1.field1) from Table1 T1
or
* Select P1.field1,P1.field2,P2.field2 from (Select T1.field1,
Sounds like Gerald is right, your database server is not configured to
support replication. Have you given your database server a 'server-id'?
On Wed, 20 Jun 2007, Gerald L. Clark wrote:
> Ananda Kumar wrote:
> > Hi All,
> > We have setup replication. Mysql version 5.0.40. On master db, if i ex
Hi Seth -
I believe MySQL's official position is that you should always dump-and-load
the data when upgrading major or minor versions (4.0 to 4.1, 4.1 to 5.0,
etc.)
I've done it both ways (dump-load and just moving table files) and have
never had a problem with either, even when moving files acr
On Jun 21, 2007, at 12:21 PM, Gerald L. Clark wrote:
Seth Seeger wrote:
Hello,
I'm having trouble copying a database from MySQL 4.1.22 to 5.1.19-
beta. Both are FreeBSD i386-based machines. I have run the
following commands:
mysqlcheck --check-upgrade --all-databases --auto-repair
mysql
Seth Seeger wrote:
Hello,
I'm having trouble copying a database from MySQL 4.1.22 to 5.1.19-
beta. Both are FreeBSD i386-based machines. I have run the following
commands:
mysqlcheck --check-upgrade --all-databases --auto-repair
mysql_fix_privilege_tables
Both executed with no problems.
Hello,
I'm having trouble copying a database from MySQL 4.1.22 to 5.1.19-
beta. Both are FreeBSD i386-based machines. I have run the
following commands:
mysqlcheck --check-upgrade --all-databases --auto-repair
mysql_fix_privilege_tables
Both executed with no problems. (mysqlcheck reporte
Hi,
Why am i getting "UNSUBCRIBE" emails, I have not asked for it.
regards
anandkl
On Thu, Jun 21, 2007 at 01:12:19PM +0200, Christian Parpart wrote:
> this statement indeed is a feature.
> but why has it been marked obsolete?
>
> it would be sooo easy instanciate master-slave replication.
It's marked obsolete because it doesn't really work well (such as only
supporting MyISAM)
Run
explain select * from A,B where A.col1=B.col1;
The explain plan for your query will tell you what indexes are chosen.
If your explain plan says what you do not like, definitely add an index on col1
in B.
Make sure you run OPTIMIZE TABLE on both tables.
The, run explain select * from A,B wh
John Mancuso wrote:
If I have 2 large tables A and B and I need to join them:
select * from A,B where A.col1=B.col1
If A.col1 is an index and B.col1 is not, if I create an index on B.col1
will this index be used? In other words how are indexes used on table
joins?
Thanks
John Mancuso
Li
If I have 2 large tables A and B and I need to join them:
select * from A,B where A.col1=B.col1
If A.col1 is an index and B.col1 is not, if I create an index on B.col1
will this index be used? In other words how are indexes used on table
joins?
Thanks
John Mancuso
Linux Administrator/MySQL
Hello,
Great, it looks like we have some interest here for Cluster on Windows!
However, resources are pretty tight right now and we have not
prioritized Cluster for Windows, at least not for 5.1 or 6.0.
Again, this is a great community project for anyone that is up for
attempting to port Clu
Hello,
I think you are asking what is the last version of Cluster that
supported Windows.
No MySQL release of the Cluster product has ever supported Windows. (We
are talking pre-MySQL acquisition days when Cluster was supporting Windows.)
MySQL versions 4.1, 5.0 and 5.1 all support Cluster
I would be interested in cluster for windows.
At least at our shop, we consider Windows servers easier to deploy so if we
can have HA option for windows/mysql it'll be great.
Thanks,
Yi
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 21, 2007 9:42
What was the last release of MySQL 5.0.x that supported Cluster ???
- Original Message -
From: "Jimmy Guerrero" <[EMAIL PROTECTED]>
To: "C K" <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Wednesday, June 20, 2007 5:43:28 PM (GMT-0500) America/New_York
Subject: Re: MySQL cluster for w
I'm trying to clarify some type-casting behavior and it would help if I could examine
the type of certain things: user variables, CURRENT_DATE, expressions like 5+'0'. Is
there such a function or operator? I can't find one.
--
Baron Schwartz
http://www.xaprb.com/
--
MySQL General Mailing Lis
Ben Edwards wrote:
On 21/06/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi Ben,
Ben Edwards wrote:
> Can Mysql 4.20 use an index where like 'xx%' is in the where
> clause against the column.
>
> i.e. index table1(col1)
>
> from table1
> where table1.col1 like 'something%'
Yes, it can use
Hi Ben,
Ben Edwards wrote:
Can Mysql 4.20 use an index where like 'xx%' is in the where
clause against the column.
i.e. index table1(col1)
from table1
where table1.col1 like 'something%'
Yes, it can use an index on LIKE prefixes. Using a function such as LEFT(col1, 9) =
'something' wil
Can Mysql 4.20 use an index where like 'xx%' is in the where
clause against the column.
i.e. index table1(col1)
from table1
where table1.col1 like 'something%'
Regards,
Ben
--
Ben Edwards - Bristol, UK
If you have a problem emailing me use
http://www.gurtlush.org.uk/profiles.php?uid=4
(emai
dear sir or madam,
please i need the following files in order to enable arabic display of data
stored in MySQL database, v4.0.12-nt:
cp1256_bin
cp1256_general_ci
where can i find them ?
Regards
Hiam
_
Windows Live Hotmail. Even
Hi all,
this statement indeed is a feature.
but why has it been marked obsolete?
it would be sooo easy instanciate master-slave replication.
Regards,
Christian Parpart.
signature.asc
Description: This is a digitally signed message part.
On 6/20/07, Andrey Kumykov <[EMAIL PROTECTED]> wrote:
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is
31 matches
Mail list logo