Re: Transplanting table structure changes

2008-08-10 Thread Markus Grossrieder
Hi Jerry, there's a (commercial) product called SQLyog, with an excellent schema synchronization tool (at least in the enterprise version) which procudes ready-made "alter table" scripts. Probably other db tools have this functionality too ... HTH, regards, Markus - Original Message ---

Re: Problem with date field

2004-11-05 Thread Markus Grossrieder
> What's going on here? God knows ! Maybe providing some information (OS, version, host app(if any), code example, db description, etc.) would permit some humble humans to take a guess ... - Original Message - From: "Steve Grosz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, N

Re: How to show comments/annotations in MySQL client output

2004-07-27 Thread Markus Grossrieder
Michael, which version are you using ? I didn't find SYSTEM in the manual ... Thanks, Markus - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Richard Mixon (qwest)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, July 27, 2004 6:09 PM Subject: Re: How to

Re: select and where clause - help

2004-07-07 Thread Markus Grossrieder
Hi, > | BT-1034.02 > mysql> SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2'; I think you have a type .. instead of SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2' try SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.02' HTH, Markus - Original Message - From: "leego

Re: JOIN or UNION or both?

2004-06-24 Thread Markus Grossrieder
Matthias, > That would have been an elegant solution but unfotunately Im not running > 4.1 yet, which is required for GROUP_CONCAT() (no chance of an upgrade We still don't know which version you're using, but have a look at http://www.codeproject.com/Purgatory/mygroupconcat.asp It worked for me