On Wed, May 21, 2008 at 9:45 PM, David Perron <[EMAIL PROTECTED]> wrote:
> Hello MySQL Users-
>
> I am pretty sure this is a simple question and I am over thinking how to
> solve the problem, so I am hoping the community can help.
>
> I am selecting a pretty straightforward aggregation from a singl
Hello MySQL Users-
I am pretty sure this is a simple question and I am over thinking how to
solve the problem, so I am hoping the community can help.
I am selecting a pretty straightforward aggregation from a single stats
table with the following format:
SELECT
Description
LongDescriptio
Would this work for you?
SELECT msgdata
FROM sent_sms
WHERE momt = 'MT'
AND binfo IN (SELECT
binfo
FROM sent_sms
WHERE momt = 'DLR')
David
On 5/21/08 10:30 PM, "sangprabv" <[EMAIL PROTECTED]> wrote:
> Hi,
> I tried to look for records from a table with this query:
Hi,
I tried to look for records from a table with this query:
SELECT msgdata FROM sent_sms WHERE momt = 'MT'AND binfo = ( SELECT
binfo FROM sent_sms WHERE momt = 'DLR' )
But MySQL returns this error:
#1242 - Subquery returns more than 1 row
I tried also with ANY, IN, EXISTS.
And modified the quer
In china?
On Thu, May 22, 2008 at 1:43 AM, bruce <[EMAIL PROTECTED]> wrote:
> Hi...
>
> Got a small personal project that I'm considering, and I realize that I
> need
> a mysql database guru/dba to talk to to figure out the best approach to
> implementing a database for my needs of the project.
>
On May 16, 2008, at 2:42 AM, Adam de Zoete wrote:
Thanks for your responses, i thought it was a float problem so i was
trying to CAST as a DECIMAL to fix it. It turns out (and the manual
does not document this) that casting as decimals doesn't actually
work in mysql 4.1.20. ROUND() is need
You might be able to do it with the federated engine:
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Fire a trigger on your main tables which update some row in a foreign
MySql database used for accounting. I've not tried this but the theory
is sound.
Ben
Andrey Dmit
hi all...
just wondering what is the performance difference between:
PRIMARY KEY [/|index_type|/] (/|index_col_name|/1,/|index_col_name|/2)
at the time of the table creation
or
create index index_name1 on table_name (/|index_col_name|/1);
create index index_name2 on table_name (/|index_co
>-Original Message-
>From: Yong Lee [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, May 21, 2008 3:10 PM
>To: 'Chris W'; 'Jerry Schwartz'; 'MYSQL General List'
>Subject: RE: Match/No Match query
>
>chris,
>
>you're going to need a source for all the distinct codes that you may
>see in
>your pro
>-Original Message-
>From: Chris W [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, May 21, 2008 1:14 PM
>To: Jerry Schwartz; MYSQL General List
>Subject: Re: Match/No Match query
>
>Jerry Schwartz wrote:
>>> From: Chris W [mailto:[EMAIL PROTECTED]
>>> Sent: Wednesday, May 21, 2008 12:25 PM
>>>
yes, one master to multiple slaves.
I believe u can set up multiple mysql instances on a single machine with
each mysql instance collecting from a different master.
Yong.
-Original Message-
From: Andrey Dmitriev [mailto:[EMAIL PROTECTED]
Sent: May 21, 2008 11:29 AM
To: mysql@lists.mys
chris,
you're going to need a source for all the distinct codes that you may see in
your product tableie: if you don't have a full list somewhere (like your
temp table) you cannot do your query because you have nothing to compare
against.
assuming you had some table X which had a list of all
Is it true that a single mysql server can be a slave to only one master?
So if you need to replicate a dozen databases into a single reporting
server, you need to have a chain of a dozen servers in between? Someone
shared that to me, but it didn't make much sense.
In oracle we have the followin
Hi...
Got a small personal project that I'm considering, and I realize that I need
a mysql database guru/dba to talk to to figure out the best approach to
implementing a database for my needs of the project.
The basic goal of the project is to be able to track the sites that I'm
visiting via a Fi
Jerry Schwartz wrote:
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:25 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Match/No Match query
Jerry Schwartz wrote:
I have a list of codes. Some, but not all, of these codes will match
the
e
>From: Chris W [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, May 21, 2008 12:25 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Match/No Match query
>
>Jerry Schwartz wrote:
>> I have a list of codes. Some, but not all, of these codes will match
>the
>> entries in a product table. Her
On Tue, May 20, 2008 at 11:20 AM, Bof <[EMAIL PROTECTED]> wrote:
> Hi all -
> Is there a good workaround for mysql's lack of 'DESC'
> functionality when creating an index?
>
> I'm looking at migrating an Oracle RAC database to
> mysql (InnoDB or Cluster - testing both at the
> moment), and the Orac
Jerry Schwartz wrote:
I have a list of codes. Some, but not all, of these codes will match the
entries in a product table. Here's what the data would look like:
List of Codes:
The rows in the product table look like
prod_num code
222
333
What I
I have a list of codes. Some, but not all, of these codes will match the
entries in a product table. Here's what the data would look like:
List of Codes:
The rows in the product table look like
prod_num code
222
333
What I want to is get a list o
Price, Randall wrote:
Could you use something like this (untried):
SELECT
CONCAT(COALESCE(r.first_name, ''), ' ',
COALESCE(r.last_name,''), '\n',
COALESCE(r.organization, ''), '\n',
COALESCE(r.title,''), '\n',
COALESCE(a.a
http://tldp.org/HOWTO/LVM-HOWTO/whatislvm.html
On Tue, May 20, 2008 at 10:13 PM, Moon's Father
<[EMAIL PROTECTED]> wrote:
> What is LVM?
>
> 2008/5/12 MarisRuskulis <[EMAIL PROTECTED]>:
>
>> Hello!
>> I'm wondering about MySQL LVM2 preformance, but cant found any
>> comparisions. I know that there
Dear reader,
Upscene Productions releases Database Workbench Pro v3.1.1 which
fixes an issue with the trial version and Windows Vista as well as two
other bugs.
For more info, see:
http://www.upscene.com/news/20080521.htm
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL
yes, you'd have to alter the queries to use the new index. As I say it's
very application dependent and does not always apply, but you can normally
shoehorn any application to use it.
Phil
On Wed, May 21, 2008 at 9:22 AM, Bof <[EMAIL PROTECTED]> wrote:
> Hi Phil -
>
> Thanks for the suggestion.
Hi Phil -
Thanks for the suggestion. Might that involve possibly
changing queries in the web application hitting the
database so that it uses the new column, or would the
indexing on the new column take care of speeding up
the existing queries?
cheers
Iain
--
--- Phil <[EMAIL PROTECTED]> wrote:
Hello mysql list
I posted this problem to the list earlier this month:
Error reading packet from server: Out of memory (Needed 6560 bytes) (
server_errno=5)
I was then told to upgrade to the newest version, which I did and which
seemed to solve the problem. Today, I got this in my log:
080
What I've done in the past is to create extra columns which contain the
reverse of a number/date used previously in an index.
So, for instance if it's a simple INT column (A) and you know the max would
be 999 for example, create an extra column and populate that with
(1000 - A) and use it
Hi,
When I add a reference to a non-existing row in the referenced table, I have
no error:
My table "member_orders_items" references "members_orders",
member_orders_item has a FK to a non existing PK in member_orders (since
this one is empty), no error is generated.
I can see in MySQL Administra
Hi all -
Is there a good workaround for mysql's lack of 'DESC'
functionality when creating an index?
I'm looking at migrating an Oracle RAC database to
mysql (InnoDB or Cluster - testing both at the
moment), and the Oracle database uses a lot of
multi-column indexes with some colums indexed in
d
Hi
I am just wondering if anyone is running MySQL Database on a fairly busy
Website running on FreeBSD AMD64 7-stabble with PHP+Apache?
I am going to build a server for couple of websites having traffic 5 million
per month...
Any comments?
--
Thanks!
BR / vj
Thanks very much to all who suggest me to use a JOIN
instead of the IN clause, which performances are very poor vs
join ones, as I read in
http://www.artfulsoftware.com/infotree/queries.php#568:
Both the |IN()| and |EXISTS()| queries have to execute a table scan
for each row in the table.
Thanks very much.
2008/5/21 Paul McCullagh <[EMAIL PROTECTED]>:
>
> On May 21, 2008, at 8:46 AM, Paul McCullagh wrote:
>
> On May 21, 2008, at 8:09 AM, Moon's Father wrote:
>>
>> Now I want to know which way you use to create index of a table.
>>> 1、ix_u (item_id,item_count)
>>>ix_item_coun
Thanks for your reply very much.
What I always use is the first way.
But I also want to know if the following way is proper when I search
"item_id AND item_count" and the column 'item_count'.?
ix_item_id (item_id)
ix_item_count (item_count)
2008/5/21 Paul McCullagh <[EMAIL PROTECTED]>:
>
>
32 matches
Mail list logo
