IF Angkatan 2017

mhs2017IF.csv

mhs2017IF.sql

-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 12, 2020 at 12:18 AM
-- Server version: 10.3.16-MariaDB
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `if17`
--

-- --------------------------------------------------------

--
-- Table structure for table `mahasiswa`
--

CREATE TABLE `mahasiswa` (
  `nama` varchar(30) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `kelas` varchar(30) NOT NULL,
  `npm` varchar(20) NOT NULL,
  `hobby` varchar(25) NOT NULL,
  `kata_mutiara` varchar(100) NOT NULL,
  `instagram` varchar(30) NOT NULL,
  `kesan` varchar(1000) NOT NULL,
  `pesan` varchar(1000) NOT NULL,
  `foto` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mahasiswa`
--

INSERT INTO `mahasiswa` (`npm`, `nama`, `kelas`) VALUES
('17081010001', 'Yusmi Nur Aini', 'A'),
('17081010002', 'Erlina Diah Karisma', 'A'),
('17081010003', 'Dina Puspitaningrum', 'A'),
('17081010004', 'Aini Rahma', 'A'),
('17081010005', 'Rama  Andika Jorgie', 'A'),
('17081010006', 'Iqbal Imani Khoirul Akbar', 'A'),
('17081010007', 'Sufi Miftakhoneki', 'A'),
('17081010008', 'Rico julianto Dwi Putra', 'A'),
('17081010009', 'Dwi Putri Safira', 'A'),
('17081010010', 'Muhammad Rizki Alamsyah', 'A'),
('17081010011', 'Hilda Dea Amanda', 'A'),
('17081010012', 'Handi Fajar Setyawan', 'A'),
('17081010013', 'Akbar Nur Muhammad Hadi Yansah', 'A'),
('17081010015', 'Firman Romadhoni', 'A'),
('17081010016', 'Prameswari Reksa Agami', 'A'),
('17081010017', 'Ferry Dzaky Ramadhan', 'A'),
('17081010018', 'Brenda Clarinta N', 'A'),
('17081010019', 'Nurlisa Aulia Setyaningrum', 'A'),
('17081010020', 'Cahaya Putri Agustia', 'A'),
('17081010022', 'Shoima Fitra Kumala', 'A'),
('17081010023', 'Ilham Lintas Perdana', 'A'),
('17081010024', 'Ida Wahyunita', 'A'),
('17081010025', 'Siti Yuliana', 'A'),
('17081010026', 'Kiki Yuniar Kristiawan', 'A'),
('17081010027', 'Angga Rahmat P', 'A'),
('17081010029', 'Salsabila Citra Esananda', 'A'),
('17081010031', 'Sumiati Ratna Sari', 'A'),
('17081010032', 'Tria Nurmayasari', 'A'),
('17081010033', 'Umifatul Yuni Arinda', 'A'),
('17081010034', 'Firdausia Ismi Nurhayati', 'A'),
('17081010035', 'Anisah Widyananda', 'A'),
('17081010036', 'Aris Prabowo', 'A'),
('17081010037', 'Tentra olivia', 'A'),
('17081010038', 'Guruh Ihda Alvi Ath Thaariq', 'A'),
('17081010039', 'Yuri Setiawan', 'A'),
('17081010040', 'Maulana Idris', 'A'),
('17081010041', 'Herdi Rofaldi', 'B'),
('17081010042', 'Adji Endra Sasongko', 'B'),
('17081010043', 'Guntur Adhi Prasetya', 'B'),
('17081010044', 'Mohammad Idham Fachrurrozi', 'B'),
('17081010045', 'Sunu Ilham Pradika', 'B'),
('17081010046', 'Fitri Aulia Yuliand', 'B'),
('17081010047', 'Cherry Daniella Eunike T', 'B'),
('17081010048', 'Moh. Fathur Rohman', 'B'),
('17081010049', 'Nabil Ayyasy Muhyiyuddin', 'B'),
('17081010050', 'Chilyatun Nisa', 'B'),
('17081010051', 'Amir Muhammad Hakim', 'B'),
('17081010052', 'Achmad Febrian Bagus P', 'B'),
('17081010053', 'Mochmmad Pria Kurniawan', 'B'),
('17081010054', 'Fajar Andhika Putra', 'B'),
('17081010055', 'Kholilur Rachman N M', 'B'),
('17081010056', 'Dandy Noor Imansyah Basoeki', 'B'),
('17081010057', 'Boy Diego Lumwartono', 'B'),
('17081010058', 'Rahayu Prabawati Amaliyah', 'B'),
('17081010059', 'Muhammad Rifqi Nafis', 'B'),
('17081010060', 'Parisya Shidqi Yusyarnanda', 'B'),
('17081010061', 'Frizal Aditya Junito R', 'B'),
('17081010062', 'Dicky Giancini Arwindo K', 'B'),
('17081010063', 'Nur Hidayah Amaral', 'B'),
('17081010064', 'Alfath Daryl Alhajir', 'B'),
('17081010065', 'Sandy Rizkyando', 'B'),
('17081010066', 'Syafrida Maulina Hartanti', 'B'),
('17081010067', 'Feronika Nur Maghfiro', 'B'),
('17081010068', 'Radical Rakhman Wahid', 'B'),
('17081010069', 'Annisa Fadhilasari', 'B'),
('17081010070', 'Askara Raditya', 'B'),
('17081010071', 'Muhammad Amir Fanani', 'B'),
('17081010072', 'Haryo Ghaza Raditya', 'B'),
('17081010073', 'Hanna Masfuva Della', 'B'),
('17081010074', 'Firdaus Andry Saputra', 'B'),
('17081010075', 'Dina Ratnaningtyas', 'C'),
('17081010076', 'Ahmad Rizqullah', 'C'),
('17081010077', 'Putu Bagu Krismayoga Putra', 'C'),
('17081010078', 'Muhammad Putra Hizbullah', 'C'),
('17081010079', 'Fahmi Fachrurroziq', 'C'),
('17081010080', 'Mochammad Taufiq R', 'C'),
('17081010081', 'Taruna Ardianto', 'C'),
('17081010082', 'Ryan Eka Wiratna', 'C'),
('17081010083', 'Kinandjar Hadi Pramana', 'C'),
('17081010084', 'Ilham Ananda Rey', 'C'),
('17081010085', 'Baskara Dipa Airlangga', 'C'),
('17081010086', 'Nyoman Rahadi Sasmita', 'C'),
('17081010087', 'Hafidah Nur Epstein', 'C'),
('17081010088', 'Mochamad Haris Reza', 'C'),
('17081010089', 'Muhammad Iqbal Dwi Fanani', 'C'),
('17081010090', 'Mifa Abiyyu Hibatulloh', 'C'),
('17081010091', 'Faradella Anggi Dewi', 'C'),
('17081010092', 'Afrizal Muhammad Yasin', 'C'),
('17081010093', 'Aliev Wisnu Prasetyo', 'C'),
('17081010094', 'Moh. Irwan Firmanyah', 'C'),
('17081010095', 'Barep Johannes A. I', 'C'),
('17081010096', 'Muhammad Rafi Ramadhan', 'C'),
('17081010097', 'Adji Rafi Caesar', 'C'),
('17081010098', 'Achmad David Andreyas', 'C'),
('17081010099', 'Yonandika Bimo Febri', 'C'),
('17081010100', 'Indrawan Tri Junianto', 'C'),
('17081010101', 'Firya Nadhira', 'C'),
('17081010102', 'Surya Adi Laksono', 'C'),
('17081010103', 'Febriyan Alif Putra', 'C'),
('17081010104', 'Muhammad Daffa Amirul', 'C'),
('17081010105', 'Ahmad Naufal Mumtaz', 'C'),
('17081010106', 'Amirah Tsany Alantas', 'C'),
('17081010107', 'Dandy Oktabryansah', 'C'),
('17081010108', 'Kevin Maulana Adikara ', 'C'),
('17081010109', 'Dandhie Vega Pradana', 'C');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mahasiswa`
--
ALTER TABLE `mahasiswa`
  ADD PRIMARY KEY (`npm`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;