linux下初始化mysql实例

[root@dns html]# mysql -u root -p hty_communicate< hty.sql

Enter password:

--DROP DATABASE IF EXISTS hty_communicate;


--CREATE DATABASE hty_communicate;


DROP TABLE IF EXISTS hty_communicate.hty_user;


CREATE TABLE hty_communicate.hty_user
(
   id int not null auto_increment,
   username varchar(32) not null,
   password varchar(32) not null,
   email varchar(64) not null,
   regtime datetime not null,
   primary key (id)
);