Answer the question
In order to leave comments, you need to log in
Can't add data to fields via SQL?
INSERT INTO records(id, view_id, page_id, note_id, num, public, del, url, title, descript, short, text, seo_title, seo_descript, keywords, tags, date, time, fin_data, price, price_old, quant, art, weight, param, video, link, spare, img, altimg, gallery, likes, notlikes, views, takes, comments, comment_set, user_id, admin_id)
VALUES(1, 1, 1, 1, 1, 1, 1, 'test', 'test' 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2020-02-10', '00:02:00', '2020-02-20', 100, 200, 2, 'test', 2, 'test', 'test', 'test', 'test', 'test', 'test', 'test', 0, 1, 1, 5, 1, 1, 1, 1);
Answer the question
In order to leave comments, you need to log in
Count the number of attributes here:
records(<тут>)
and here:
VALUES(<тут>)
Compare the number.
PS:
Missing comma:
1, 'test', 'test' <тут> 'test',
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question