I'm using CLSQL with MySQL. What combination of keywords do I have to pass to create-table
in order to give it a column with the timestamp column type?
(create-table [foo] `(([bar] timestamp)))
is unrecognized (it just creates a varchar 255 column, which is the default if you don't specify a column type). According to this reference page, wall-time
should create a timestamp column, but just creates a datetime
(which is not the same thing as a MySQL timestamp
).
Also, is there a better CLSQL column type reference than the one I linked above?
Why don't you want to use datetime? The only difference which I found is the range. Take a look here
If you look at the sources of clsql, for example here, you will see
It means that everything is fine with your code. What quote do you use a back-quote ` or simple quote \' ?