INSERT INTO tablename (name,trans_date,price) VALUES( STR_TO_DATE(?,'%m/%d/%Y'), ?, ? );