Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- --
- -- Database: `Test`
- --
- -- --------------------------------------------------------
- create database if not exists Test;
- use Test;
- --
- -- Table structure for table `klanten`
- --
- CREATE TABLE IF NOT EXISTS `klanten` (
- `idKlant` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `Naam` varchar(70) NOT NULL,
- `Naam` varchar(70) NOT NULL,
- `Naam` varchar(70) NOT NULL,
- PRIMARY KEY (`idKlant`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
- --
- -- Dumping data for table `klanten`
- --
- INSERT INTO `klanten` (`idKlant`, `Naam`, `Voornaam`, `Adres`) VALUES
- (1, 'van der Linde', 'Rogier', 'Kasteellaan'),
- (2, 'Gruyaert', 'Hans', 'Walstraat');
Add Comment
Please, Sign In to add comment