I am having issues with the following script. I don't see anything wrong here. Very basic but it is giving me a headache. Any suggestions are welcome. I am running version 5.1.37 and the error is:
Error Code : 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 ''visit_recipes'
('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'name' text NO' at line 1
(0 ms taken)
CREATE TABLE 'visit_recipes'
('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'name' text NOT NULL, 'ingredients' text NOT NULL,
'instructions' text NOT NULL, 'created_by' INTEGER NOT NULL,
'userip' VARCHAR(16), 'date_added' text NOT NULL, PRIMARY KEY('id'));