mysql常用命令

1.shell> mysql -h host -u user -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 459 to server version: 3.22.20a-log

Type 'help' for help.

mysql>

2.在你成功地连接后，你可以在mysql>提示下打入QUIT随时断开：
mysql> QUIT
Bye

你也可以键入control-D断开。

3.本机直接导入数据：
在DOS下打入命令:
D:/>mysql -p databasename<*.sql
回车后输入密码就可以了

4.mysqld dbname < *.sql -uusername -ppassword
用sql文件导入数据

 

 

mysql -u root -p
drop database jforum;
create database jforum character set utf8;
exit

mysql -u root jforum < d:/mysql.sql

mysql -u root -p
use jforum;
show tables;

create database db
go
use db;
create table vipuser
(
vip char(20) PRIMARY KEY,
passwd varchar(20),
balance numeric(6,1)
);
insert into vipuser values('admin','ad',34);
insert into vipuser values('swq','ad',34);