String data not inserting into MySQL

Question

Hello in the following MySQL query I am attempting to insert a string where it says "notes" but I keep getting an error and the data does not submit. However, if I pass a number it successfully works.

`insert into lecture_notes(teacher_id, class_id, notes, sent_on)
values(?,?,?, now());`, 
      [
          data1, data2, "testing testing"
      ],

//Following is the error I keep getting { "success": 0, "data": "Error. Unable to post notes.", "error_type": { "code": "ER_BAD_FIELD_ERROR", "errno": 1054, "sqlMessage": "Unknown column 'notes' in 'field list'", "sqlState": "42S22", "index": 0, "sql": "insert into lecture_notes(teacher_id, class_id, notes, sent_on)\n values(28,27,note, now());" } }

I keep getting an error: please edit your question to show the full error message. — GMB
– GMB, Commented Oct 13, 2020 at 17:49
Also add the response of desc lecture_notes; so that the data types can be seen properly. — Omkar Kulkarni
– Omkar Kulkarni, Commented Oct 13, 2020 at 17:50

Omkar Kulkarni · Accepted Answer · 2020-10-13 17:58:13Z

2

Unknown column 'notes' in 'field list' This clearly means that your table does not have any column named notes. Correct the column name.

answered Oct 13, 2020 at 17:58

Omkar Kulkarni

1,22512 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Hoopoe_Programming Over a year ago

Thank you for your reply but I do have that column. So thats not the issue because when I pass a number instead of a string to test it, it works. But not when I pass a string.

Hoopoe_Programming Over a year ago

I got it to work now. There was a syntax error in my code before hitting this query. Thank you..

Omkar Kulkarni Over a year ago

Was it about the column name or about the data type? If it worked, do upvote please

Hoopoe_Programming Over a year ago

It was somewhat related to that. But not specifically the column name because the name was matching. It was how I was passing the data into that column. Gave you upvote. Thanks

Collectives™ on Stack Overflow

String data not inserting into MySQL

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related