Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character. HSQLDB doesn’t accept either backtick or single quote as escape character. Instead you have to use escaped double quotes as shown in the example below: st.execute("CREATE TABLE sheet (tg_meta_id int identity [...]
Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character. HSQLDB doesn’t accept either backtick or single quote as escape character. Instead you have to use escaped double quotes as shown in the example below:
st.execute("CREATE TABLE sheet (tg_meta_id int identity [...]
Please fill in the following fields
* - Required
Your Name: *
Your E-Mail: *
Your Remarks:
Friend's Name: *
Friend's E-Mail: *