Kuocheng Posted April 24, 2015 Share Posted April 24, 2015 Hi! When I tried to create the `users` table for Site #1 (Chapter 3), I got the error message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause. Can you help? Thank you, Kuocheng Link to comment Share on other sites More sharing options...
Larry Posted April 25, 2015 Share Posted April 25, 2015 Different versions of MySQL support different syntaxes here. You can change the `date_created` to this: `date_created` TIMESTAMP DEFAULT 0, That should work for you. Link to comment Share on other sites More sharing options...
Recommended Posts