INSERT INTO users(firstname, lastname, email, gender, age, comments, regDate, balance) VALUES ('Frank', 'Smith', SHA2('frank@xx.com', 256), 'M', '30-60', 'test insert using PHP code', now(), 100.00)

Success