15.6.3 Create table
(m 'create table-name defs #:if-exists? #f #:primary-keys '() #:engine #f)
- table-name specifies the name of the DB table.
- defs is a list to define the type of columns. For example:
'((name varchar 10) (age integer) (email varchar 20))
#:if-exists? has two kinds of possible options:
- ’overwrite and ’drop, which will overwrite the existing table.
- ’ignore means to ignore the table when it already exists.
#:primary-keys specifies the primary keys in the created table.
#:engine specifies the DB engine. It depends on what dbd you chose.