100yen Posted December 26, 2013 Share Posted December 26, 2013 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) ? Link to comment Share on other sites More sharing options...
100yen Posted December 27, 2013 Author Share Posted December 27, 2013 I tried to copy your create table users script and past into Terminal and get the exactly error. Please help Link to comment Share on other sites More sharing options...
Larry Posted December 27, 2013 Share Posted December 27, 2013 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. Link to comment Share on other sites More sharing options...
Recommended Posts