mysql-cmd

如何通过命令行连接mysql

• mysql -hlocalhost -uroot -proot;
• show database;
• use test;
• show tables;
• desc book;
• create database test;
• create table user(id int(4) not null primary key auto_increment,username char(20)not null,password char(20) not null);
• insert into user (1,'duoduo','921012');
• select * from user;