Navicat Premium 15和VS2017的联动
1.新建一个1.sql文件,复制以下代码
set names utf8;
use test;
CREATE TABLE IF NOT EXISTS wtc_student(
id INT UNSIGNED AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
profession VARCHAR(45) DEFAULT NULL,
sex VARCHAR(3) NOT NULL,
birthdate DATE,
PRIMARY KEY ( id )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO wtc_student(id, name, profession, sex, birthdate) VALUES (1, '陈', '老师', '男', '1980-01-05'