· 6 years ago · Jan 15, 2020, 10:36 PM
1Error
2SQL query:
3
4
5CREATE TABLE IF NOT EXISTS `pacjent` (
6 `id` int (11) unsigned NOT NULL,
7 `imie` varchar(24) NOT NULL,
8 `nazwisko` varchar(24) NOT NULL,
9 `plec` varchar(24) NOT NULL,
10 `miejscowosc` varchar (24) unsigned DEFAULT NULL
11 ,
12 PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE='utf8_general_ci'
14MySQL said: Documentation
15
16#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'unsigned DEFAULT NULL
17 ,
18 PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSE' at line 6