Re: Undo query in mysql
On Sun, 16 Jun 2002, mohamadally wrote: Hi all, I accidently deleted some values in table using mysql . Is there any way to undo the query ? No, there is not, unless the table was transactional and you were not in autocommit mode. This is where backups come in handy. http://www.mysql.com/doc/A/N/ANSI_diff_Transactions.html Regards, Jason [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
Re: How can I install MySQL client only!
On Sat, 15 Jun 2002, JamesWang Home wrote: Hi, I have a question. I can install MySQL server on machine A. I am trying to install client on machine B only by select customer install and click next button. But I cannot deselect MySQL server. It is always checked and disabled. Does that mean I have to install MySQL server on machine B even I only need client? Oracle can install client only! Install the normal package, just don't start the server. Set up the my.cnf on machine b to connect to the mysql server on machine a. It's a lot easier this way. Regards, Jason [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
Re: Problem with load data infile and user's privileges
On Sat, 15 Jun 2002, Sergey Bondar wrote: OS Linux Red Hat 7.2 MySql 3.23.41 Hi All! That is my steps. With root privileges I doing: GRANT ALL ON mydb.* TO client@localhost identified by pwd; I got: OK The user needs the file privilege. Granting all on mydb.* does not give this privilege because the file privilege is a global privilege. To do this: GRANT FILE ON *.* TO... This will give the user access to files on the server, so you may want to think twice about giving them this privilege. http://www.mysql.com/doc/G/R/GRANT.html Regards, Jason [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
Re: Source For MySql
On Tue, 21 May 2002, Mugdha Kulkarni wrote: Hi, I know, this might be the dumbest question MySql is Open Source database, but I am not able from where to download the source code for MySql. Please help me Thanks Here ya go. http://www.mysql.com/downloads/mysql.html Look on those pages, you'll find what you are looking for. Regards, Jason [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
Re: select except
On Sun, 19 May 2002, Jule wrote: Hey guys and gals, is there a query that selects all comuns from a table, except the one's i have defined? Jule No, there isn't. It is safter if you name the columns you want. If you use a select * in your code instead of naming the particular columns you want, you could be in for some unpleasent surprises if the table is altered in the future. Naming the columns also makes your code easier to understand. Regards, Jason [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