...
In this example, {optional_date} refers to a column of type date and is optional. When its empty in your form, NULL is inserted fulfilling the MySQL requirement otherwise the value in the field will be inserted.
Stored Procedures
You can also execute stored procedures via the database connector. Here is an example of a mySql stored procedure.
...