sample.sql

Simple SWT for java newbie. good example for you

# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 127.0.0.1
# Database:             sample
# Server version:       5.1.30-community
# Server OS:            Win32
# Target-Compatibility: Same as source server (MySQL 5.1.30-community)
# max_allowed_packet:   1048576
# HeidiSQL version:     3.2 Revision: 1129
# --------------------------------------------------------

/*!40100 SET CHARACTER SET latin1*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;


#
# Database structure for database 'sample'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sample` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `sample`;


#
# Table structure for table 'item'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ `item` (
  `kode` int(10) unsigned NOT NULL DEFAULT '0',
  `nama` varchar(255) DEFAULT NULL,
  `jumlah` tinyint(3) unsigned DEFAULT NULL,
  `harga` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`kode`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'item'
#

LOCK TABLES `item` WRITE;
/*!40000 ALTER TABLE `item` DISABLE KEYS*/;
REPLACE INTO `item` (`kode`, `nama`, `jumlah`, `harga`) VALUES
	('1','tes',1,'100');
/*!40000 ALTER TABLE `item` ENABLE KEYS*/;
UNLOCK TABLES;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;