Re: New MySQL InStall

2010-05-07 Thread 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 an

Re: Changing date result automatically

2010-05-06 Thread 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 va

Changing date result automatically

2010-05-06 Thread 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

Join issues

2010-04-21 Thread 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_compute