-- Host: localhost
-- Generation Time: Jul 03, 2016 at 02:22 AM
-- Server version: 5.5.47-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.14
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/_!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SETCLIENT */;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SETRESULTS /;
/_!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATIONCONNECTION /;
/_!40101 SET NAMES utf8 */;
-- Database: mahasiswa
-- Table structure for table tbl_mahasiswa
CREATE TABLE IF NOT EXISTS tbl_mahasiswa (
id int(11) NOT NULL AUTO_INCREMENT,
nim varchar(20) NOT NULL,
firstname varchar(20) NOT NULL,
lastname varchar(20) NOT NULL,
gender varchar(10) NOT NULL,
birthdate date NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY nim (nim)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
/_!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SETCLIENT */;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SETRESULTS /;
/_!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-- phpMyAdmin SQL Dump -- version 4.0.10deb1
-- http://www.phpmyadmin.net
-- Host: localhost -- Generation Time: Jul 03, 2016 at 02:22 AM -- Server version: 5.5.47-0ubuntu0.14.04.1 -- PHP Version: 5.5.9-1ubuntu4.14
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/_!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SETCLIENT */; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SETRESULTS /; /_!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATIONCONNECTION /; /_!40101 SET NAMES utf8 */;
-- Database:
mahasiswa
-- Table structure for table
tbl_mahasiswa
CREATE TABLE IF NOT EXISTS
tbl_mahasiswa
(id
int(11) NOT NULL AUTO_INCREMENT,nim
varchar(20) NOT NULL,firstname
varchar(20) NOT NULL,lastname
varchar(20) NOT NULL,gender
varchar(10) NOT NULL,birthdate
date NOT NULL, PRIMARY KEY (id
), UNIQUE KEYnim
(nim
) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;-- Dumping data for table
tbl_mahasiswa
INSERT INTO
tbl_mahasiswa
(id
,nim
,firstname
,lastname
,gender
,birthdate
) VALUES (1, '201383140', 'imron', 'last', 'pria', '2016-07-10'), (2, '20001099', 'Joko', 'anwar', 'MALE', '1995-07-17'), (3, '201383150', 'heri', 'prasetyo', 'MALE', '1898-03-20');/_!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SETCLIENT */; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SETRESULTS /; /_!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;