· 7 years ago · Dec 10, 2018, 12:48 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3--
4-- Database: `Test`
5--
6
7-- --------------------------------------------------------
8create database if not exists Test;
9use Test;
10
11--
12-- Table structure for table `klanten`
13--
14
15CREATE 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
27INSERT INTO `klanten` (`idKlant`, `Naam`, `Voornaam`, `Adres`) VALUES
28(1, 'van der Linde', 'Rogier', 'Kasteellaan'),
29(2, 'Gruyaert', 'Hans', 'Walstraat');