我试图从我的user表中的两列(user_id,team_id)中插入值到company_team的结表。但是,我通过两次不同的尝试将created_at和updated_at列的值插入到company_team中,并且不知道如何处理它们。SQL插入时间戳问题
在第一次尝试,我只是想与从user表中的等价字段中的值更新两个领域:(注列在两个表是DATETIME)
INSERT INTO `company_team` (`created_at`,`updated_at`,`user_id`, `company_id`)
SELECT `user_id`, `company_id`, `created_at`, `updated_at`
FROM `user` AS `u`
WHERE `u`.`company_id` IS NOT NULL;
错误:
Incorrect datetime value: '1' for column 'created_at' at row 1
然后我试图只用在创建记录当前的日期/时间:
INSERT INTO `company_team` (NOW(),NOW(),`user_id`, `company_id`)
SELECT `user_id`, `company_id`, `created_at`, `updated_at`
FROM `user` AS `u`
WHERE `u`.`company_id` IS NOT NULL;
错误:
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 'NOW(),NOW(),`user_id`, `organization_id`)
SELECT `user_id`, `company_id`, `' at line 1
2017-04-07
cphill