TrainityTrainity
All ideas

how to insert, execute or use data in column

Despite of watching videos on SQL i am unable to understand how to insert,execute or use data in query under coloumn, cant see the output. please guide preparing for project 3 Query- INSERT INTO jobdata (ds, jobid, actorid, event, language, timespent, org) (values11/30/2020, 21, 1001, skip, English, 15 A), (11/30/2020, 22 1006, transfer, Arabic 25 B), (11/29/2020, 23 1003, decision, Persian 20 C), (11/28/2020, 23 1005, transfer, Persian 22 D), (11/28/2020, 25 1002, decision, Hindi 11 B), (11/27/2020, 11 1007, decision, French 104 D), (11/26/2020, 23 1004, skip, Persian 56 A), (11/25/2020, 20 1003, transfer, Italian 45 C); result - 0 24 19:35:25 INSERT INTO jobdata (ds, jobid, actorid, event, language, timespent, org) (values11/30/2020, 21, 1001, skip, English, 15 A), (11/30/2020, 22 1006, transfer, Arabic 25 B), (11/29/2020, 23 1003, decision, Persian 20 C), (11/28/2020, 23 1005, transfer, Persian 22 D), (11/28/2020, 25 1002, decision, Hindi 11 B), (11/27/2020, 11 1007, decision, French 104 D), (11/26/2020, 23 1004, skip, Persian 56 A), (11/25/2020, 20 1003, transfer, Italian 45 C) Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '11/30/2020, 21, 1001, skip, English, 15 A), (11/30/2020, 22 1006, `tra' at line 2 0.016 sec