Jump to content
Larry Ullman's Book Forums

aspaeth

Members
  • Posts

    1
  • Joined

  • Last visited

aspaeth's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I was unable to get the code to work to generate the MySQL table for Chapter 1. I gathered that I was getting some kind of error due to two timestamps being created in the same table. I was able to get the following table creation command to work, but wondered if anybody had further clarification of a better way to create the table. Thanks! CREATE TABLE tasks ( task_id INT UNSIGNED NOT NULL AUTO_INCREMENT, parent_id INT UNSIGNED NOT NULL DEFAULT 0, task VARCHAR(100) NOT NULL, date_added DATETIME NOT NULL, date_completed TIMESTAMP, PRIMARY KEY (task_id), INDEX parent (parent_id), INDEX added (date_added), INDEX completed (date_completed));
×
×
  • Create New...