Re: Undo query in mysql

2002-06-16 Thread Jason Englehardt
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.

Re: How can I install MySQL client only!

2002-06-15 Thread Jason Englehardt
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

Re: Problem with load data infile and user's privileges

2002-06-15 Thread Jason Englehardt
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

Re: Source For MySql

2002-05-21 Thread Jason Englehardt
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

Re: select except

2002-05-19 Thread Jason Englehardt
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