RE: Complex Query

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; Gu

RE: Complex Query

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 Que

RE: Complex Query

ages FROM book => > INNER => > JOIN publisher on pkpublisher_id = fkpublisher_id INNER JOIN => > module_book on => > => > pkisbn = fkbook_isbn INNER JOIN module on fkmodule_nr = => module_nr => > INNER => > JOIN book_author on pkisbn = fkisbn INN

RE: Complex Query

or_id = pkauthor_id WHERE 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.co

RE: MySQL ignores foreign key constraints

HARSET=latin1 | +-+-- 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, 2

MySQL ignores foreign key constraints

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 | +

RE: Complex Query

May 2011 07:48 To: 'Guido 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,&

RE: Complex Query

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 author.

RE: Complex Query

mysql workbench. 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 se

Complex Query

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 conca

RE: Database tables for Exchange rates

R char(3) >> NONBASE_CURR char(3) >> EFF_DATE DATE >> EXCH_RATE DECIMAL(15,6)-- or however much precision you need >> >> We have other columns storing tolerances but that should be enough. First >> 3 >> columns are your key. >> >> Separa

Database tables for Exchange rates

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

Complex Query

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 product_de