This MySQL database and tables are created for demonstrate purpose. Many Java’s tutorials and examples in this website will reference to this MySQL’s data for demonstration.

Here’s MySQL dump file to create a database named “mkyong” and some tables

--
-- Create schema mkyong
--
 
CREATE DATABASE IF NOT EXISTS mkyong;
USE mkyong;
 
--
-- Definition of table `stock`
--
 
DROP TABLE IF EXISTS `stock`;
CREATE TABLE `stock` (
  `STOCK_ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `STOCK_CODE` varchar(10) NOT NULL,
  `STOCK_NAME` varchar(20) NOT NULL,
  PRIMARY KEY (`STOCK_ID`) USING BTREE,
  UNIQUE KEY `UNI_STOCK_NAME` (`STOCK_NAME`),
  UNIQUE KEY `UNI_STOCK_ID` (`STOCK_CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
This article was posted in MySQL category.

Related Posts