How to Drop or Delete the database by shell command in windows XAMPP?

 Generally, we can pass any query to mysql from shell with -e option as below:

1. First need to go in mysql/bin using cd mysql/bin command

2. mysql -u username -p -D "database name" -e "DROP DATABASE database name"

Comments

Post a Comment

Popular posts from this blog

How to set Alias for Laravel in ubuntu?

There are following steps for setting the aliases: 1. To begin with, open the bash terminal and head to the home directory. 2. Then, check if there is a .bash_aliases file: ls -a 3. In case the file does not exist, we have to create it: touch .bash_aliases 4. Open the file with a text editor and add the alias. For example: alias pa='php artisan' 5. Then, save the file and exit. 6. Restart your terminal and try in your project root directory with pa Some Aliases: alias pa="php artisan" alias pas="php artisan serve" alias pac="php artisan cache:clear" alias paoc="pa optimize:clear"
Read more

Best Website Links

Forex Related Sites Link: *For Calculation: http://www.luckscout.com/leverage-margin-balance-equity-free-margin-and-margin-level-in-forex-trading/ TOP Wesite List:   http://biglistofwebsites.com/list-top-websites-on-slider   TAlly :  http://www.rtslink.com/TallyXMLTags.htm http://www.ncsmindia.com/chapter-10-displaying-information-from-tally/ Check your site contains malicious or not: http://sitecheck.sucuri.net Info about your site: http://builtwith.com/ SRS: http://www.microtoolsinc.com/Howsrs.php http://www.acommerce.asia/ http://www.srstravels.net/clients.php http://www.mgts.co.in/case_study_viatical_service_outsourcing.html http://techwhirl.com/writing-software-requirements-specifications/ http://www.jaysonjc.com/programming/how-to-write-a-software-requirements-specification-srs-document.html http://www.tricity.wsu.edu/~mckinnon/cpts322/cpts322-srs-v1.doc Theme · Admin: o http://www.daveism...
Read more