9/17 In SQL it seems DATE, DATETIME, TIME and TIMESTAMP are all reserved
words. What do you use to name your date fields?
\_ What date it actually is, e.g.: "created_date", "updated_date",
"renewed_date" (or just "created", "updated", "renewed", etc)
--dbushong
\_ Good idea, thanks. Another question: How do I create a table
with a record which is an array of strings, eg: a table of
some type of record where one element is a list of keywords.
Do I have to put all the keywords in one string and do something
like comma-seperation?
\_ If they're going to be of varying length and short, then the
comma separation bit will work. Otherwise, make a new keyword
table and tie it to the first table with a foreign key. |