E
E
Evgeny Zaletsky2020-03-05 19:48:27
SQL
Evgeny Zaletsky, 2020-03-05 19:48:27

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);

Bug #1136 - The number of columns does not match the number of values ​​in record 1

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
alexalexes, 2020-03-05
@JZ_52

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 question

Ask a Question

731 491 924 answers to any question