Guest User

Untitled

a guest
Dec 9th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.70 KB | None | 0 0
  1. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  2.  
  3. --
  4. -- Database: `Test`
  5. --
  6.  
  7. -- --------------------------------------------------------
  8. create database if not exists Test;
  9. use Test;
  10.  
  11. --
  12. -- Table structure for table `klanten`
  13. --
  14.  
  15. CREATE TABLE IF NOT EXISTS `klanten` (
  16.   `idKlant` int(10) unsigned NOT NULL AUTO_INCREMENT,
  17.   `Naam` varchar(70) NOT NULL,
  18.   `Naam` varchar(70) NOT NULL,
  19.   `Naam` varchar(70) NOT NULL,
  20.   PRIMARY KEY (`idKlant`)
  21. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  22.  
  23. --
  24. -- Dumping data for table `klanten`
  25. --
  26.  
  27. INSERT INTO `klanten` (`idKlant`, `Naam`, `Voornaam`, `Adres`) VALUES
  28. (1, 'van der Linde', 'Rogier', 'Kasteellaan'),
  29. (2, 'Gruyaert', 'Hans', 'Walstraat');
Add Comment
Please, Sign In to add comment