Re: New MySQL InStall

[Weydson Lima]

You can dowload the community server here:

http://dev.mysql.com/downloads/mysql/

---
Weydson Lima
weys...@gmail.com


On Thu, May 6, 2010 at 12:59 PM, Michael Abbott  wrote:

>
> Can anyone give me some info here  I want to install MySQL on a Vista
> Home Edition Laptop  Can anyone tell me what I should download from the
> site?  I want to run a java app.  What version is stable and does it
> matter the operating system?  Thank-YouMike
> _
> Win $10,000 from Hotmail! Enter Here.
> http://go.microsoft.com/?linkid=9729708
>

Re: Changing date result automatically

[Weydson Lima]

I was referring to the function:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

---
Weydson Lima
weys...@gmail.com


On Thu, May 6, 2010 at 1:58 PM, Martin Gainty  wrote:

>  http://lists.mysql.com/commits/60834
>
> date_format system variable is currently an unused system variable
>
> Martin Gainty
> __
> Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
>
> Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
> Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte
> Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht
> dient lediglich dem Austausch von Informationen und entfaltet keine
> rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
> E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
>
> Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le 
> destinataire prévu, nous te demandons avec bonté que pour satisfaire informez 
> l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci 
> est interdite. Ce message sert à l'information seulement et n'aura pas 
> n'importe quel effet légalement obligatoire. Étant donné que les email 
> peuvent facilement être sujets à la manipulation, nous ne pouvons accepter 
> aucune responsabilité pour le contenu fourni.
>
>
>
>
>
>
> > From: weys...@gmail.com
> > Date: Thu, 6 May 2010 11:44:37 -0500
> > Subject: Changing date result automatically
> > To: mysql@lists.mysql.com
>
> >
> > Hi,
> >
> > Is there any way to format all dates generated by a MySQL query as US
> > format? What I want to do is having a generic way to use the DATE_FORMAT
> > function on all my date fields, instead of having to enter them manually.
> > Thank you
> >
> > ---
> > Weydson Lima
> > weys...@gmail.com
> > http://bluetoothmono.weydson.com
>
> --
> The New Busy is not the old busy. Search, chat and e-mail from your inbox. Get
> started.<http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3>
>

Changing date result automatically

[Weydson Lima]

Hi,

 Is there any way to format all dates generated by a MySQL query as US
format? What I want to do is having a generic way to use the DATE_FORMAT
function on all my date fields, instead of having to enter them manually.
Thank you

---
Weydson Lima
weys...@gmail.com
http://bluetoothmono.weydson.com

Join issues

[Weydson Lima]

I am dealing with a JOIN error issue. The following query:

SELECT *
FROM (((ts_software RIGHT JOIN t_computers ON
t_softwareassoc.SoftwareAssocSoftwareID = ts_software.SoftwareID) LEFT JOIN
ts_softwaremfg ON
ts_software.SoftwareMfgID = ts_softwaremfg.SoftwareMfgID) LEFT JOIN
ts_eqtype ON
t_computers.CompEqTypeID = ts_eqtype.EqTypeID) RIGHT JOIN t_softwareassoc ON
t_computers.CompID = t_softwareassoc.SoftwareAssocCompID

is giving the error:

C_ReportUnknown column 't_softwareassoc.SoftwareAssocSoftwareID' in 'on
clause'

I assume that the reason for that error is because the first join is being
called before the RIGHT JOIN t_softwareassoc. What would be the best way to
solve that? I tried to move the RIGHT JOIN t_softwareassoc to the top but it
didn't help.

Thank you,
 Wey