Mysql commands from Linux shell
Hi to all: I have a linux script and I need it can execute some mysql commands. Is it possible? If possible, how? Best regards, Fabio Galarraga [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: Read/write table lock
Yes, I think this is the problem. But how can I make a read/write lock with only one lock? Best regards, Fabio. > -- > De: Gerald L. Clark[SMTP:[EMAIL PROTECTED]] > Enviado el: Martes, Marzo 20, 2001 04:33 PM > Para: Fabio Galarraga > CC: 'Mysql mailing list' > Asunto: Re: Read/write table lock > > Fabio Galarraga wrote: > > > > Hi to all: > > Somebody knows how to make a read/writa table lock? > > I'm trying with java source: > > > > stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); > > > > stmt.execute("UNLOCK TABLES"); > > > > but it fails. > > > > Best regards, > > Fabio Galarraga > > [EMAIL PROTECTED] > > > Well you are locking table-x twice in the same lock. > - 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
Read/write table lock
Hi to all: Somebody knows how to make a read/writa table lock? I'm trying with java source: stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); stmt.execute("UNLOCK TABLES"); but it fails. Best regards, Fabio Galarraga [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