ASK | CRUD XAMPP

isi dari sql nya

_________________________

-- phpMyAdmin SQL Dump

-- version 5.0.4

-- https://www.phpmyadmin.net/

--

-- Host: localhost

-- Waktu pembuatan: 09 Mar 2021 pada 14.13

-- Versi server: 10.4.17-MariaDB

-- Versi PHP: 8.0.0

 

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

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: `latihan_oop`

--

 

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

 

--

-- Struktur dari tabel `tab_guru`

--

 

CREATE TABLE `tab_guru` (

`id` int(10) NOT NULL,

`nik` int(20) NOT NULL,

`nama_guru` varchar(50) NOT NULL,

`pendidikan_terakhir` varchar(3) NOT NULL,

`jurusan` varchar(30) NOT NULL,

`asal_sekolah` varchar(50) NOT NULL,

`alamat` text NOT NULL,

`email` varchar(50) NOT NULL,

`no_telp` int(15) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 

--

-- Dumping data untuk tabel `tab_guru`

--

 

INSERT INTO `tab_guru` (`id`, `nik`, `nama_guru`, `pendidikan_terakhir`, `jurusan`, `asal_sekolah`, `alamat`, `email`, `no_telp`) VALUES

(1, 12345, 'Jesen RHD', 'SMK', 'RPL', 'SMKN 2 JAKARTA', 'jalan raya asu', 'jesenkun@gmail.com', 808088),

(2, 12345, 'Jesen RHD', 'SMK', 'RPL', 'SMKN 2 JAKARTA', 'jalan raya asu', 'jesenkun@gmail.com', 8080800);

 

--

-- Indexes for dumped tables

--

 

--

-- Indeks untuk tabel `tab_guru`

--

ALTER TABLE `tab_guru`

ADD PRIMARY KEY (`id`);

 

--

-- AUTO_INCREMENT untuk tabel yang dibuang

--

 

--

-- AUTO_INCREMENT untuk tabel `tab_guru`

--

ALTER TABLE `tab_guru`

MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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 */;