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. http://www.my

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 giv

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. > > D

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-18 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 column