cmd下执行mysql

1.  mysql -uroot -p1234;

---

2.  show databases;

---

3.  use testnode;

---

4. 创建数据库表

   

CREATE DATABASE `node` DEFAULT CHARACTER SET utf8 ;

 

USE `node`;

-- ----------------------------

-- Table structure for `user`

-- ----------------------------

CREATE TABLE `user` (

  `id` varchar(36) NOT NULL,

  `name` varchar(30) NOT NULL,

  `password` varchar(60) NOT NULL,

  `u_level` int(4) DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

select * from user;

insert into user values('7606ffe4-ec02-4703-98c1-238d5cd99b40','admin','admin',3);

-- ----------------------------

-- Table structure for `resource`

-- ----------------------------

CREATE TABLE `resource` (

  `id` varchar(45) NOT NULL,

  `title` varchar(45) NOT NULL,

  `author` varchar(45) NOT NULL,

  `createTime` date NOT NULL,

  `url` varchar(245) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for `article`

-- ----------------------------

CREATE TABLE `article` (

  `id` varchar(45) NOT NULL,

  `title` varchar(45) NOT NULL,

  `author` varchar(45) NOT NULL,

  `createTime` date NOT NULL,

  `content` varchar(9000),

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

 

---