sql syntax
Hello, my name's Marlon. I have a question about sql and I need some help! How can I do something like it using mysql? update registre set (name='NewName' where lastname='OldLastName'), (name='OldName' where lastname='NewLastName'); Tank you Marlon _ Voce quer um iGMail protegido contra vírus e spams? Clique aqui: http://www.igmailseguro.ig.com.br Ofertas imperdíveis! Link: http://www.americanas.com.br/ig/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Different DB directories against one MySQL
I'm trying to have MySQL connect to different filesystems (mostly in read-only mode). I've tried setting the read-only attribute of my files under my database directory under c:\mysql\data and MySQL seems to be able to SELECT it with no problem (I then tried doing an INSERT and it came up with an error message, which is perfect). Hopefully, this would also work if my database directory is in CDROM even if the MySQL binaries are in writable hard disk. My question is: Is it possible to have a single instance of MySQL where each connection might have a different data directory? For example, I have a user that needs to query data from a CDROM, and there's another one that needs to query some tape backup. If not, I am assuming it should be OK to run multiple instances of MySQL (on different ports) and just have them point to different data paths (unless you guys know of a more elegant solution). Thanks! Marlon
RE: Different DB directories against one MySQL
Thanks Kevin! I see what you're saying. That would mean I would have a common 'mysql' database though (for the db, user, func tables, etc). I thinks that's acceptable in my case. (I assume I don't need to update these tables if I want to add a 'link' to a new database somewhere, and that 'USE' would auto-detect any new directory.) I'll probably do a little experimenting in Windows soon (since I'm trying to be portable, or maybe I should stop supporting Windows, hmm). Thanks again! Marlon -Original Message- From: Kevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 6:39 PM To: Baculio, Marlon; [EMAIL PROTECTED] Subject: RE: Different DB directories against one MySQL Hi Marlon, Under linux mysql will 'see' any databases you've got links in the folder you've configured it to look. So in my /var/lib/mysql I have a symlink to /db/Allpoetry, and it knows to look there for the data files. So each database can have its own directory. You could probably even symlink the tables to files on other odd places if you wanted too. I assume the same thing is possible under windows. I know cygwin does symlinks, but don't know if the windows mysql will follow them, or if it follows shortcuts otherwise anyways. Not sure what the efficiency problems of running a database from a cdrom would be either, but it'd be an interesting experiment :) Ciao, Kevin Watt Community Manager, Allpoetry.com What happened to the cow who went for a drive? He got a Moo_ving violation What do you call someone who is crazy about hot chocolate? A cocoa nut What do bees use to cut wood? Buzz saws Who eats at underwater resturants ? Suba diners How do really small people call each other ? On Microphones How do you fix a broken chimp? With a monkey wrench -Original Message- From: Baculio, Marlon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:32 PM To: [EMAIL PROTECTED] Subject: Different DB directories against one MySQL I'm trying to have MySQL connect to different filesystems (mostly in read-only mode). I've tried setting the read-only attribute of my files under my database directory under c:\mysql\data and MySQL seems to be able to SELECT it with no problem (I then tried doing an INSERT and it came up with an error message, which is perfect). Hopefully, this would also work if my database directory is in CDROM even if the MySQL binaries are in writable hard disk. My question is: Is it possible to have a single instance of MySQL where each connection might have a different data directory? For example, I have a user that needs to query data from a CDROM, and there's another one that needs to query some tape backup. If not, I am assuming it should be OK to run multiple instances of MySQL (on different ports) and just have them point to different data paths (unless you guys know of a more elegant solution). Thanks! Marlon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installation problem
Hi, i`m trying to install mysql on my E250 Solaris 7. when i issue mysql it outputs: # ./mysql ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed where can i find libncurses.so.5 ? Thank you, Marlon Macedo -Mensaje original- De: Daniel Bechtel [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 20 de Diciembre de 2001 05:48 p.m. Para: [EMAIL PROTECTED] Asunto: Can't connect to SERVER MYSQL localhost Hello, I'm running Windows ME and installed 2 weeks ago MYSQL and got it working fine. Had no problems. Now suddenly since a couple days I can't get the MYSQL Server started anymore. I get the above described message. Well, I checked the manual and followed those hint's but it does not tell me much more. I can ping my localhost address 127.0.0.1 and localhost itself, but when I try to telnet to it I get the message Could not open connection to localhost. To make things worse I deinstalled MYSQL and reinstalled it. I kept my previous my.ini but checked it against the manual and can't find anything wrong. Here it is: [mysqld] basedir=c:\mysql datadir=c:\mysql\data innodb_data_file_path=ibdata1:2000M;ibdata2:2000M innodb_data_home_dir=c:\mysql\data\ibdata innodb_log_group_home_dir=c:\mysql\data\iblogs innodb_log_arch_dir=c:\mysql\data\iblogs innodb_log_archive=1 [WinMySQLadmin] Server=C:/MYSQL/bin/mysqld.exe QueryInterval=10 Now when I start MYSQL with the command MYSQLD I get the following errors: Innodb:operating system error number 3 in a file operation. Innodb: Error in creating or opening c:\mysql\data\ibdata\ibdata1 Innodb: Could not open data files 011220 Can't init databases. I believe this is not a MYSQL issue but rather something on Windows operating System level. I don't know any further, especially after it worked before and I probably screwed something up, but I can't find what it is. HELP ! Daniel - 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 - 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
