$sth->bind_param (1, $id, SQL_NUMERIC); $sth->bind_param (2, $name, SQL_VARCHAR); $sth->bind_param (3, $desc, SQL_VARCHAR); $sth->bind_param_inout(4, \$id, SQL_NUMERIC);