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 <sam.wun@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
