It looks like you're trying to update a MySQL table named job_data by converting the Date column to a proper date format using the str_to_date function. The query you provided seems mostly correct, but there might be a few things causing issues. Let's break down the potential problems and provide a corrected query:

Syntax: The syntax you provided seems correct for the purpose you're trying to achieve.
Column Names: Make sure that the column names (Date and temp_Date) are spelled exactly as they are in your table, and that they are in the correct case. MySQL is case-sensitive when it comes to column and table names.
Date Format: The date format you provided in str_to_date needs to match the actual format of the dates in your Date column. If your dates are in the format "dd-mm-yy" (day-month-year), then your format specifier should be %d-%m-%y. If the format is different, adjust the format specifier accordingly.

Here's the corrected query assuming the format is "dd-mm-yy":

UPDATE job_data
SET temp_Date = STR_TO_DATE(Date, '%d-%m-%y');

If you're still encountering issues, please provide more details about the error message you're receiving so that I can assist you further. Also, double-check the column names, table name, and the actual date format in your data to make sure they match what you're using in your query.

Update statement