Querious Docs 4
Account

Table Columns

The table columns view in Querious is a user-friendly way of seeing and changing the column definitions in a database table.

Notes for table columns: #

  • To specify the length of a decimal column, separate the precision and scale values by a comma.
  • In the Flags column for numerical column types, "u" is "unsigned", and "z" is "zerofill".
  • To specify a NULL default value, uncheck "Not Null" and type "NULL" into the Default Value column.
  • The Extra column contains miscellaneous bits of SQL, such as "ON UPDATE CURRENT_TIMESTAMP".
  • Columns can be rearranged and renamed.

To specify Set and Enum value lists:

  1. Select the Set or Enum column in the columns list.
  2. Click in the Values field below the columns list.
  3. Use the add and remove buttons in the popup window to add and remove values from the list.
  4. Click on "Done"