Hello.


No. Because mysql -e 'drop view v' just executes the SQL statement. And

DROP VIEW doesn't support such syntax. See:

  http://dev.mysql.com/doc/mysql/en/DROP_VIEW.html





sam wun <[EMAIL PROTECTED]> wrote:

> sam wun wrote:

> 

>> Gleb Paharenko wrote:

>>

>>> Hello.

>>>

>>>

>>>

>>> Use -e command line option for mysql client program. For example:

>>>

>>>  mysql -u root -p test -e 'drop view v'

>>>

>>>

>>>  

>>>

>> Hi, does it take wildcard? something like:

>>

>> mysql -u root -p test -e 'drop view v*'

>>

> Or even drop all view tables (only affect the view tables):

> mysql -u root -p test -e 'drop view *'

> 

> Sam.

> 

>> Thanks

>> Sam

>>

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to