示範Vue.js新增修改刪除查詢(建立資料表)
20.sql
--CREATE Database--
CREATE DATABASE `vue_2016`;
--CREATE table--
CREATE TABLE `eagle` (
`id` INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` CHAR(20) NOT NULL,
`age` INT(3) UNSIGNED NOT NULL DEFAULT '0',
`email` VARCHAR(200) NOT NULL,
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;