MySQL 4.0.11 update syntax
I was reading somewhere that MySQL 4.1 UPDATE syntax will allow update to table with values from another table in the following manner: update client, zip set client.st = zip.st, client.city = zip.city where client.zip = zip.zip; Is there a creative way to do this in 4.0.11? chas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Archive on remote Machine.
If you have ssh installed on your target machine couldn't you do the following? mysqldump | scp @:. KH Chiu wrote: It will then be a networking problem. As far as I know, you may need a networking file system like NFS or Samba. You should mount your remote machine as a network drive. Then you can use mysqldump to make a backup but redirect the output to the network drive. There may be other methods. In fact, I have a project that has more complex remote backup requirement. I am working on it using C right now but not yet completed. Regards, Thanx for the suggestion. Is there any way i can Archive data to remote machine where MySQL is not installed. Anis "KH Chiu" <[EMAIL PROTECTED]> Wednesday, February 19, 2003 8:46:46 AM >>> You may try the following command mysqldump -u -p samp_db | mysql -h remote host name or address> samp_db -u -p Please also note that samp_db must be exist on your remote machine. Of course, you should sub. samp_db with your to be achieve database name. Regards, -- Charles Lewis Reliable Computer Services [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
client side RAD
I am desperately searching for a GUI RAD environment to develop database applications for MySQL. I'm not talking about database administration such as provided by ControlCenter or SQLyog. I'm talking about the ability to build formatted forms/screens, queries and reports along the lines of Access. In fact, I would use Access except it's not platform independent. I have scoured the internet and I can't seem to find anything that comes near to the features found in Access. Rekall comes close and has many attractive qualities, but it not a very mature product (yet). I'm going to keep playing with Rekall, but I was wondering if there is anything else out there that I could take a look at. I need something that is flexible/powerful enough to meet a variety of complex needs, such as you might find in various departments of university. At the same time, I definitely need to be able to develop/customize applications rapidly. And finally, I need the finished product (and preferably the development environment) to be GUI. Any suggestions? Charles Lewis [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple field separators
Hi. I have the following command: mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=, --fields-enclosed-by=, dbase c:\file.txt This reads the following from a text file: 26 Sep 2001, 05:42:24 : Text message to be read. The date and time separator is a "," and the time and message separator is a ":" But the time field is also split up with ":" where as I don't want to split up the time field. Does anybody have any suggestions on how I can overcome this problem? Charles Lewis HAS Configuration Specialist Oxford Technology Solutions Ltd. The Technology Centre 213, Barns Road Oxford OX4 3UT United Kingdom Company Number: 3610219 T: +44 (0) 1865 785 341 F: +44 (0) 1865 777 080 M: +44 (0) 7870 630514 E: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> W: http://www.ots-uk.com <http://www.ots-uk.com/> The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any attachment(s) to this message has been checked for viruses, but please rely on your own virus checker and procedures. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php