When I try to execute the independence sql file into my mysql, I get some errors. Does any one happen to know how to fix these errors? Or can anyone provide me a link possibly on how to correct these errors? I would greatly appreciate it. I am still learning how to do mysql databases so please no hate. I am using this source to learn how it works NOT for my own work. All credits will be given to owner. I will include a screen shot of the errors below, thanks.
Error
Static analysis:
2 errors were found during analysis.
-- -- Dataark for tabell `bans` -- INSERT INTO `bans` (`id`, `userid`, `type`, `reason`, `unban_when`, `who_banned_them_userid`) VALUES -- -------------------------------------------------------- -- -- Tabellstruktur for tabell `emojis` -- CREATE TABLE IF NOT EXISTS `emojis` ( `id` int(5) NOT NULL, `Name` varchar(50) NOT NULL, `Wut` varchar(50) NOT NULL, `url` varchar(50) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `id_2` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said:
Error
Static analysis:
2 errors were found during analysis.
- An opening bracket followed by a set of values was expected. (near "CREATE" at position 245)
- Unexpected token. (near "CREATE" at position 245)
-- -- Dataark for tabell `bans` -- INSERT INTO `bans` (`id`, `userid`, `type`, `reason`, `unban_when`, `who_banned_them_userid`) VALUES -- -------------------------------------------------------- -- -- Tabellstruktur for tabell `emojis` -- CREATE TABLE IF NOT EXISTS `emojis` ( `id` int(5) NOT NULL, `Name` varchar(50) NOT NULL, `Wut` varchar(50) NOT NULL, `url` varchar(50) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `id_2` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said:
Code:
#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 'CREATE TABLE IF NOT EXISTS `emojis` (
`id` int(5) NOT NULL,
`Name` varchar(5' at line 14