Advertisement
ridyko

crud02

Nov 6th, 2024
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.31 KB | Source Code | 0 0
  1. -- Membuat database dbcrud02
  2. CREATE DATABASE dbcrud02;
  3.  
  4. -- Menggunakan database dbcrud02
  5. USE dbcrud02;
  6.  
  7. -- Membuat tabel tmhs
  8. CREATE TABLE tmhs (
  9.     id_mhs INT AUTO_INCREMENT PRIMARY KEY,
  10.     nim VARCHAR(20) NOT NULL,
  11.     nama VARCHAR(100) NOT NULL,
  12.     alamat TEXT,
  13.     prodi VARCHAR(50) NOT NULL
  14. );
  15.  
Tags: crud02
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement