Jump to content
Larry Ullman's Book Forums
100yen

Sql Timestamp Error When Creating Users Table

Recommended Posts

Hello Larry, Thanks for another great book.

 

When I try to create users table for pdf store, I get an error:

 

'ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause'.

 

I tried couple times get the exactly same error. Is that mysql doesn't allow creation of two TIMESTAMP in two columns (date_created & date_modified) ?

 

 

Share this post


Link to post
Share on other sites

Sorry about the hassle and thanks for the interest in the book. I made need to correct a line in the SQL. See this thread:

 

http://www.larryullman.com/forums/index.php?/topic/2798-possible-error-in-sqlsql-for-2nd-edition-of-this-book/&do=findComment&comment=17516

 

This is one of those things whose behavior changes frequently in MySQL.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...