Advertisement
gundambison

perbaikan 76-sql

Aug 24th, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.12 KB | None | 0 0
  1.  
  2. --
  3. -- Table structure for table `tbl_pengunjung`
  4. --
  5.  
  6. CREATE TABLE `tbl_pengunjung` (
  7.   `id` int(11) NOT NULL,
  8.   `nama` varchar(30) NOT NULL,
  9.   `jk` int(11) NOT NULL,
  10.   `kelas` varchar(15) NOT NULL,
  11.   `waktu_kunjung` date NOT NULL,
  12.   `keperluan` text NOT NULL,
  13.   `saran` text NOT NULL
  14. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  15.  
  16. --
  17. -- Dumping data for table `tbl_pengunjung`
  18. --
  19.  
  20. INSERT INTO `tbl_pengunjung` (`id`, `nama`, `jk`, `kelas`, `waktu_kunjung`, `keperluan`, `saran`) VALUES
  21. (1, '', 1, 'VIII', '2018-08-20', '', ''),
  22. (2, '', 1, 'VIII', '2018-08-21', '', ''),
  23. (3, '', 1, 'IX', '2018-08-20', '', ''),
  24. (4, '', 1, 'IX', '2018-08-22', '', ''),
  25. (5, '', 1, 'IXA', '2018-08-20', '', ''),
  26. (6, '', 1, 'IX', '2018-08-22', '', ''),
  27. (7, '', 1, 'VIII', '2018-07-21', '', '');
  28.  
  29. --
  30. -- Indexes for dumped tables
  31. --
  32.  
  33. --
  34. -- Indexes for table `tbl_pengunjung`
  35. --
  36. ALTER TABLE `tbl_pengunjung`
  37.   ADD PRIMARY KEY (`id`);
  38.  
  39. --
  40. -- AUTO_INCREMENT for dumped tables
  41. --
  42.  
  43. --
  44. -- AUTO_INCREMENT for table `tbl_pengunjung`
  45. --
  46. ALTER TABLE `tbl_pengunjung`
  47.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  48. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement