Page 1 of 1

strange MySQL Error or Im missing something.

Posted: Fri Jul 11, 2014 6:13 pm
by DavJans
INSERT INTO nonc (pcert, job, errordate, qcpink, pinknumber, pinkflag) VALUES (MFTEST1234, 6TES, NOW(), 244, 1, 1 )

this is giving me,
Unknown column 'MFTEST1234' in 'field list'

anyone got any ideas?

Re: strange MySQL Error or Im missing something.

Posted: Fri Jul 11, 2014 7:14 pm
by DavJans
I fixed it, if anyone was curious

INSERT INTO nonc (pcert, job, errordate, qcpink, pinknumber, pinkflag) VALUES ('MFTEST1234', '6TES', NOW(), 244, 1, 1 )