Re: Formatting in same columns when selecting from two tables.

Good Morning Lucas- could you define the formatting specifics of DATA and DATASTAMP result-type? Thank You Martin - Original Message - Wrom: REXCAXZOWCONEUQZAAFXISHJEX To: mysql@lists.mysql.com Sent: Thursday, March 06, 2008 8:43 AM Subject: Formatting in same columns when selecting from

Re: Efficiently storing a directed graph

Good Evening Peter- //so if I look at this algorithm from wikopedia I see something like //Java/C#/C++ no problem //How would you implement this in PL/SQL ? public Dictionary CalculateMinCost(Location _startLocation) { //Initialise a new empty route list Dictionary _shortestPaths = new

Re: Move data from one db to another?

Hi Brian tough to say without looking at the script http://www.php.net/function.mysql-connect suggests allowing the current thread to sleep a bit to wait for the resource to become available M-- - Original Message - Wrom: CLBDXRQBGJSNBOHMKHJYFMYXOEAIJJPHSCRTNHGS To: mysql@lists.mysql.com

Re: Blank users/passwords

1)the user you have connected with does not have permissions to the table 2)you have not yet connected to the DB containing users table easily solved by connect mysql and rerun query Viel Gluck/Buena Suerte Martin-- - Original Message - Wrom: LYRWTQTIPWIGYOKSTTZRCLBDXRQBGJSNBOHMKHJYFMY

Re: Current month's start day and end day

this will get you the start day mysql select DATE_FORMAT(CONCAT(SUBSTR(NOW(),1,8),'01'),'%a'); this will get you the end day mysql select DATE_FORMAT(LAST_DAY(NOW()),'%a'); Is there a reason why you dont want to use a programming language for this task? M-- - Original Message - Wrom:

Re: Crystal Reports XI on W2k3 Server SP2 x64 (fwd)

Hi Phillip Did you get a chance to look at Navicat? http://www.navicat.com/download.html Martin-- - Original Message - Wrom: CGPKYLEJGDGVCJVTLBXFGGMEPYOQKEDOTWFAOBUZXUW To: mysql@lists.mysql.com Sent: Sunday, September 30, 2007 1:42 AM Subject: Crystal Reports XI on W2k3 Server SP2 x64