Tag: schema.sql

This example will show you how to connect to MySQL database and response output to webpage. Please download the schema.sql here, and run it with MySQL client. /* create database */ CREATE DATABASE itblogs DEFAULT CHARACTER SET utf8;   USE itblogs;   CREATE TABLE COMPANY( id BIGINT NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, background 

You can download the schema.sql – Spring4Restful_v01_schema.zip here, and run it with MySQL client. /* create database */ CREATE DATABASE itblogs DEFAULT CHARACTER SET utf8;   USE itblogs;   CREATE TABLE COMPANY( id BIGINT NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, background  VARCHAR(255) NOT NULL, PRIMARY KEY (id) );   CREATE TABLE SHOP ( id