Essentially I have the following SQL query that inserts the three values into the three columns specified.
"INSERT INTO Equipment (field1, field2, field3)
VALUES ('TestInsertF1', 'TestInsertF2', 'TestInsertF3')";
The table also has an auto-incrementing ID column that creates a new ID every time the query above is executed.
How can I insert a value into field4
where the value is hardcoded to be "NUM: (The auto-incremented ID )"