This is driving me crazy I need another pair of eyes to assist me with this. I created a table in Mysql and used phpmyadmin to insert some data but keep getting a syntax error. Everything looks correct. Please help
Here is the table.
DROP TABLE IF EXISTS content;
CREATE TABLE IF NOT EXISTS content (
title varchar(75) NOT NULL,
city varchar(20) NOT NULL,
type varchar(20) NOT NULL,
email varchar(55) NOT NULL,
FULLTEXT KEY title (title),
FULLTEXT KEY city (city),
FULLTEXT KEY type (type)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Here is the sql syntax I am using below.
INSERT INTO 'content' VALUES (1, 'LOW RATES**Excavation**Skid Steer**Backhoe**Excavation**LOW RATES', 'New York', 'NULL', 'XXXX@yahoo.com');