Bizarre! That worked, but it appears the alias is not used.
Thanks
Mimi
= -Original Message-
= From: Hal�sz S�ndor [mailto:h...@tbbs.net]
= Sent: 21 May 2011 01:48
= To: Johan De Meersman
= Cc: Mimi Cafe; mysql@lists.mysql.com; Johan De Meersman; Guido
= Schlenke
= Subject: Re
Schlenke'; mysql@lists.mysql.com; Mimi Cafe
Subject: RE: Complex Query
Hi Guido,
You need to add group by in your query get desire result
SELECT IFNULL(image,'no_image.jpg') as image,title, subtitle,
group_concat(concat(fname,' ',initial,' ',lname)) as author, pkisbn,
publisher FROM book INNER
Hi
An ideas why MySQL silently ignores any foreign key constraints I define for
the following tables?
mysql desc book;
+--+---+--+-+-+-
--+
| Field| Type | Null | Key | Default |
Extra |
|
+-+--
Thanks
From: Suresh Kuna [mailto:sureshkumar...@gmail.com]
Sent: 20 May 2011 12:15
To: Mimi Cafe
Cc: mysql@lists.mysql.com
Subject: Re: MySQL ignores foreign key constraints
WHat are the table engine types ?
On Fri, May 20, 2011 at 4
module_nr = ? group by IFNULL(image,'no_image.jpg'),title,
subtitle, pkisbn, publisher;
Mimi
From: Mimi Cafe [mailto:mimic...@googlemail.com]
Sent: 20 May 2011 11:33
To: 'Anupam Karmarkar'
Cc: 'Guido Schlenke'; mysql@lists.mysql.com
Subject: RE: Complex Query
Hi guys
That's cool
INNER JOIN author on fkauthor_id
= =
= pkauthor_id
=
= WHERE module_nr = ? group by IFNULL(image,'no_image.jpg'),title,
= subtitle, pkisbn, publisher);
=
= Guido
=
= Mimi Cafe schrieb im Newsbeitrag
= news:004701cc16f1$a2d550c0$e87ff240$@com...
=
= Hi
=
=
=
= I now need
I meant it may produce unexpected result.
Mimi
= -Original Message-
= From: Mimi Cafe [mailto:mimic...@googlemail.com]
= Sent: 20 May 2011 22:52
= To: 'Johan De Meersman'; 'Guido Schlenke'
= Cc: mysql@lists.mysql.com
= Subject: RE: Complex Query
=
= Select count(*) from (select
.
Thanks
Mimi
= -Original Message-
= From: George Pitcher [mailto:george.pitc...@publishingtechnology.com]
= Sent: 19 May 2011 06:42
= To: Mimi Cafe
= Subject: RE: Complex Query
=
= Mimi,
=
= I have a lot of biblio records across several applications. I decided
= at
= the outset
Hi Guido
I like your powerful query below, but it doesn't answer my question. I guess
some clarification is needed here.
OK, I have books in the database with more than one author. When I query for
the title of books and name of author, I get more rows for books that have more
than one
Hi
I am trying to retrieve record from 2 tables (book and author), but my
problem is how to retrieve all the names of authors where more than one
author wrote a book.
Here is what i have: it works OK, except that it returns more than one row
for books that have more than one author.
select
I am designing a database to store exchange rates and other information. The
tables fro the exchange rates will store exchange rates fro all currencies.
Can I have any suggestions about the number of tables to use for the
exchange rate? I think I will need at least 2 tables, but I am looking for
We have other columns storing tolerances but that should be enough. First
3
columns are your key.
Separate tables for the currency codes themselves.
On Mon, May 10, 2010 at 7:28 AM, Mimi Cafe mimic...@googlemail.com
wrote:
I am designing a database to store exchange rates and other
I have three tables from which I need to query for a keyword. The 3 tables
are products, productsubcategories and productcategories. Fron these three
tables, I need to query for a product name or keywork starting with the
products table. if the keyword is not found in the product name or
13 matches
Mail list logo
