Advertisement
oimtrust

biodataSql_crud-pdo-oop

Dec 28th, 2016
2,164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.34 KB | None | 0 0
  1. CREATE TABLE `biodata` (
  2.   `id_bio` int(11) NOT NULL,
  3.   `nama` varchar(50) NOT NULL,
  4.   `phone` varchar(14) NOT NULL,
  5.   `alamat` varchar(100) NOT NULL
  6. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  7.  
  8. ALTER TABLE `biodata`
  9.   ADD PRIMARY KEY (`id_bio`);
  10.  
  11. ALTER TABLE `biodata`
  12.   MODIFY `id_bio` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement