Column count doesn’t match value count at row

INSERT INTO clnt_reports_01 (r_id, cl_no, cl_no, servi, size, vol, 
deliver_point, port_, a_port, road, term, compet, speed, 
rcomments, stage, meetrating, username, user_status, kids, 
hobbies, comments)

VALUES (1, 123123, "test", "test", "test", "test", 
"test", "test", "test", "test", 1, "test", "test",
 3, 5, "test", "test", 5, "test", "test");

Getting the error –

Error Code: 1136. Column count doesn’t match value count at row

Answer

EDIT:

You have specified 21 columns and provided only 20 values so there is a mismatch.

cl_no seems to be repeated twice. Remove that.

---

You need to use single quotes instead of double for text

INSERT INTO clnt_reports_01 ( 
r_id,
cl_no,
servi,
size,
vol,
deliver_point,
port_,
a_port,
road,
term,
compet,
speed,
rcomments,
stage,
meetrating,
username,
user_status,
kids,
hobbies,
comments)

VALUES (1, 
123123, 
'test', 
'test', 
'test', 
'test', 
'test', 
'test', 
'test', 
'test', 
1, 
'test', 
'test', 
3, 
5,
'test', 
'test', 
5, 
'test', 
'test');