How do I fix this error mysql.connector.errors.dataerror: 1292 (22007): truncated incorrect DOUBLE value: '2018-1157'

See more:

Python

I am expriencing a problem in my code espcially with this part of the code
ERROR DESCRIPTION: mysql.connector.errors.DataError: 1292 (22007): Truncated incorrect DOUBLE value: '2018-1157'
http://127.0.0.1:8080/student/delete/2018-1158
href="http://127.0.0.1:8080/student/delete/2018-1158" target="_blank" title="New Window">^]

@student_bp.route("/student/delete/<string:school_id>", methods=['GET','POST'])
def delete(school_id):
    cursor = mysql.connection.cursor()
    sql = f"DELETE from student where school_id= {school_id}"
    cursor.execute(sql)
    mysql.connection.commit()
    flash("Slot Deleted Successful","danger")
    return redirect('student')

What I have tried:

@student_bp.route("/student/delete/<string:school_id>", methods=['GET','POST'])
def delete(school_id):
    cursor = mysql.connection.cursor()
    sql = f"DELETE from student where school_id= {school_id}"
    cursor.execute(sql)
    mysql.connection.commit()
    flash("Slot Deleted Successful","danger")
    return redirect('student')