mysql 常见命令

22 阅读1分钟
  1. mysql -u root -p
  2. create database xx;
  3. use xx;
  4. show databases;
  5. drop database xx;
  6. crreate table x (xx xx xx);
  7. desc xx;
  8. alter table xx rename xx;
  9. drop table xx;
  10. alter table xx modify xx xx;
  11. select * from xx;
  12. quit
  13. exit;

image.png