Join sintax question

e the question was clear... :) thanks in advance for your answer, Giulio

Re: Join sintax question

Il giorno 04/gen/04, alle 17:34, Douglas Sims ha scritto: Hi Giulio Hi Doug, I think you could do this by repeatedly left-joining the categories table as in this: SELECT AudioTrack.* FROM AudioTrack A LEFT JOIN AudioTracks_Categories C1 ON A.AudioTrack_id=C1.AudioTrack_id LEFT JOIN

Re: Select Question

If your MySQL version is 4.1 or later, you could try GROUP_CONCAT the query should be ( not tested ): select id,GROUP_CONCAT(f2) from tablename group by id regards, Giulio Il giorno 05/ott/04, alle 17:20, Feghhi, Jalil ha scritto: Is there a way to convert the following result set: id

can you help me optimizing this query?

his seems to work, but it is VERY VERY slow, and I'm working with only 4000-5000 track records, most of them having only one track_character record. It can last up to 120 seconds if I leave the title blank, resulting on all tracks listed. Any Idea on how could I optimize this? Thanx in advance,

Re: can you help me optimizing this query?

runs at the speed of thought! can I be happy with this result, or there's something I have not considered? Giulio Il giorno 12/lug/04, alle 14:50, Giulio ha scritto: Hi all, I have an audio tracks info table, let's call it Tracks; every Track can have one or more ' Character' (

mysql@lists.mysql.com

Corporation - Spruce Pine |-+----> | | Giulio | | | <[EMAIL PROTECTED]| | | n.it>| | || | | 07/12/200

Re: i cant connect to mysql from other machine

I believe you shoul comment out the bind_address option on config file... Hope this helps, Giulio Il giorno 19/lug/04, alle 11:27, [EMAIL PROTECTED] ha scritto: hello people.. i have a curious problem with mysql. i configure root user acount to enable access from other machines but i

query for room reservations question

ields ) to list all the rooms reserved on a given date interval, but I can't figure out the query to list all the rooms of a given type (room_type) that results FREE ( not reserved ) on the given date interval. thanx for your help, Giulio -- MySQL General Mailing List For list arch

Re: query for room reservations question

Brilliant ! thank you so much! only one more question: INNER JOIN is not a good choose because it lists only the record with a matching ON clause, and this is the only difference between LEFT and INNER, correct? thanks again, Giulio Il giorno 29/lug/04, alle 16:03, [EMAIL PROTECTED] ha

Another order by question

HI, I have a table, let's call it item, which has a field containing a comma separated list of IDs of related items ( same table ). I know, this is far away from a correctly normalized structure and this stuff should be handled using another table for the link, but I'm working on a pre-existent

intermediate table question

and 7, but some of them could belong to more categories not specified in the query, and I would like to have also them in the result... Hope this was clear... thank you Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

A database design question

mix of the fields from tables B and C with added a fileld rec_type to handle different fields depending on the record type ( this seems to me to be the simplest solution, although not the best in term of normalization rules ) Hope it was all clear, thanx in advance, Giulio -- MySQL Gener

Re: A database design question

;re right, I now think the possible solutions are to merge the two table type on one table type, or keep them separated, perform two different separate joins and then merge them by code... thank you, Giulio How do you expect to get results from a SELECT which returns hits in both the B and

Re: Spanish Accents

alled htmlspecialchars, that converts a string containing special characters on the appropriate string for html visualization. I'm quite sure ASP has an equivalent function. Hasta siempre, Giulio Il giorno 09/mar/04, alle 12:57, Brand, Troy Anthony ha scritto: Hello, I am building a web

accessing MySQL from VB6 application ( without ODBC )

ant to use ODBC. the operations i need to perform are quite basic ( simple queries to a server ), any advice on some dll out here ? thank you, Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

accessing MySQL from VB6 application ( without ODBC )

ant to use ODBC. the operations i need to perform are quite basic ( simple queries to a server ), any advice on some dll out here ? thank you, Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ADO driver?

ng it succesfully on some applications on VB 6, without problems. Thanks for the message... but, I'm not using VB... Can this project be used in place of an ADO driver? I guess not, right? Well, I think yes, It should follow quite well standard ADO methods and functions, You must test it. anyway

Re: This thing called MOD

Hi, I use mod a lot simply for fast checking if a number is a multiple of another number if mod(number1,number2) = 0 then number1 is a multiple of number2 Il giorno 09/mag/04, alle 18:44, Robert Reed ha scritto: Thomas MOD is a way to get the remainder from a division problem. It does not ta

php - mysql tandem and multi core performance

answer, Giulio Giulio Mastrosanti giu...@cantoberon.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Error compiling on Solaris 6

ath. Can anybody help me please? It's quite important and a bit urgent. PLEASE reply to me as well as to the list because I am not subscribed. Many thanks Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error compiling on Solaris 6

E1 6DB Registered in England and Wales No 3027851 VAT Reg No 778499447 -Original Message- > From: mysql [mailto:[EMAIL PROTECTED] > Sent: 26 July 2007 13:24 > To: Giulio Troccoli > Cc: mysql@lists.mysql.com > Subject: Re: Error compiling on Solaris 6 > > Giulio > d

Building MySql 5.0.45 on Solaris 6

but left the -I/usr/include. Again, it failed. So now I'm stuck. I don't know what to do. I just need a new version of MySql client (I'm currently on 3.22.32) because the new server (5.0.27) uses privileges that my client does not support. Please help. Giulio Linedata Services

RE: Building MySql 5.0.45 on Solaris 6

it and it seems to work. We're having some issues on upgrading to Solaris 8, that's why we still have Solaris 6. I hope the pre-build package for Solaris 8 will work without any intervention. But if it won't and I'll need to build it I'll remember the issue you told me

myODBC error 2019

this error happens also using Access to connect via ODBC, and the connection to the old database keeps working fine. Any Idea? Thanks for your help, Giulio -- Sharemusic - Distribuzione Musicale Shareware Cantoberon - 00192 Roma - Via A. Doria, 57 tel. +39/0639737052 - fax +39/063988

mysql - search engines like query

anks in advance ----- Giulio Borrini Web Programmer Netbuilder snc Parma, Italy - - Before posting, please

Can't create a new thread (errno 12).

After some hour my Database return this error message: Warning: MySQL Connection Failed: Can't create a new thread (errno 12). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in conn.php3 on line 7 At conn.php3