RE: mysql on Windows

2006-03-14 Thread jblanchard
[snip] Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? {/snip] The operating system? Yuck yuck! :) It ran fine for me on 2k3 before I cam back to a *nix shop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: To Print an output to the Screen

2006-03-06 Thread jblanchard
[snip] While writing a Script file for Batch execution, Suppose I just wanna print a comment on screen how should I do that.. ? ( I want and output Comment on Screen ) Can any one suggest rather than using a SELECT statement to print an out put on screen for the same purpose.. [/snip] Depending

RE: dumping results of a select

2006-03-02 Thread jblanchard
[snip] Is there a way with mysqldump to instead of dumping the contents of a table dump the contents of a select so if you import that sql back in you will get a new table that looks like the select? [/snip] I don't think so, but you could use INTO OUTFILE -- MySQL General Mailing List For lis

RE: manage multiple mysql servers on different hosts?

2006-03-01 Thread jblanchard
[snip] We're running several mysql servers for different applications on different machines. Instead of connecting to each mysql server manually to find out basic information, e.g. versions, mostly like what 'show variables' returns, plus what databases exist on each server, are there any tools th

RE: file permission

2006-03-01 Thread jblanchard
[snip] This function is great! Anyone know how to include the column names, table info, any extra miscellaneous info? I use SQLyog for exporting to csv and they do include the columns, my bet is its some SQL option. The manual doesn't specify, at least in the select syntax part. [/snip] Any sel

RE: using replace() to remove tab chars

2006-03-01 Thread jblanchard
[snip] Does anyone have any suggestions? The mysql server [and client] are running under Linux. The products_description field is a 'text' type. If there's further info you need, please let me know. [/snip] Are you using REPLACE(column_name, '\t', ' ') ? -- MySQL General Mailing List For list a