Category SQL query

English forums
1

Anyone can tell me how to make a query for inserting categories into the shop?
INSERT INTO oxcategories(OXID, OXACTIVE, OXTITLE, OXTIMESTAMP) VALUES (oia9ff5c96f1f29d527b61202ece0877, 1, , TestCategory, NOW());
And it says - ERROR 1054 (42S22): Unknown column ‘oia9ff5c96f1f29d527b61202ece0877’ in ‘field list’

2

Do not forget the ‘high comma’ and there is a comma too much:

INSERT INTO oxcategories(OXID, OXACTIVE, OXTITLE, OXTIMESTAMP) VALUES (‘oia9ff5c96f1f29d527b61202ece0877’, ‘1’,‘TestCategory’, NOW());

3

Thank you…my mistake…you were right.