· 8 years ago · Dec 09, 2017, 08:24 PM
1There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
2
3ERROR: Unknown Punctuation String @ 597
4STR: /&
5SQL: CREATE TABLE IF NOT EXISTS `announcement` (
6 `id` int(255) NOT NULL auto_increment,
7 `message` varchar(1000) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;# MySQL returned an empty result set (i.e. zero rows).
10
11
12INSERT INTO `announcement` (`id`, `message`) VALUES
13'1' 'This Is An Announcement! <br />\r\nThis is also an announcement! <br />\r\nBeleive it or not this is also an announcement<br />\r\n<big>oh this is big and Green!</
14
15INSERT INTO `announcement` (`id`, `message`) VALUES
16'1' 'This Is An Announcement! <br />\r\nThis is also an announcement! <br />\r\nBeleive it or not this is also an announcement<br />\r\n<big>oh this is big and Green!</
17
18SQL query:
19
20INSERT INTO `announcement` (`id`, `message`) VALUES '1' 'This Is An Announcement! <br />\r\nThis is also an announcement! <br />\r\nBeleive it or not this is also an announcement<br />\r\n<big>oh this is big and Green!</
21
22MySQL said:
23
24#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1' 'This Is An Announcement! <br />\r\nThis is also an announcement! <' at line 2