· 8 years ago · Dec 09, 2017, 03:36 PM
1CREATE DATABASE `myDb`;
2USE myDb;
3
4CREATE TABLE IF NOT EXISTS `docenten` (
5 `id` int(11) NOT NULL,
6 `name` varchar(100) NOT NULL,
7 `surname` varchar(100) NOT NULL,
8 PRIMARY KEY (`id`)
9);
10
11INSERT INTO `docenten` (`id`, `name`,`surname`) VALUES
12(1, 'Dieter', 'Vanhemel'),