linux mysql操作

Start tomcat server: sudo /var/local/apache-tomcat-8.0.23/bin/startup.sh
  Stop tomcat server: sudo /var/local/apache-tomcat-8.0.23/bin/shutdown.sh
  Access mysql:
  1.login mysql: mysql -u root -p
  2.show database: show databases
  3.operate database:
    use clinic
    show tables
    drop database clinic
    create database clinic
  4.import sql file:
    source /root/clinic.sql
  Import file to Server: rz
posted @ 2016-03-16 02:07  Aaronqcd  阅读(151)  评论(0编辑  收藏  举报