· 8 years ago · Dec 02, 2017, 03:38 PM
1CREATE TABLE IF NOT EXISTS `jos_vm_cart` (
2
3 `user_id` INT( 11 ) NOT NULL ,
4 `cart_content` TEXT NOT NULL ,
5 `last_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
6PRIMARY KEY ( `user_id` )
7) ENGINE = MYISAM CHARSET utf8
8MySQL said:
9
10#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP ,
11PRIMARY KEY ( `user_id` )
12) ENGINE = MYI