SQL insert into语句报错（插入时间信息出错）

插入下面字段时一直报错：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 ‘16:31)’ at line 1, Time: 0.000000s

insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(100,'test4','test@yahoo.cn',2007/11/25 16:31);
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(13,'test1','test@yahoo.cn',2007/3/22 16:27);
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(19,'test1','test@yahoo.cn',2007/10/25 14:13);
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(42,'test1','test@yahoo.cn',2007/10/25 14:20);
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(45,'test2','test@yahoo.cn',2007/4/25 14:17);
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(49,'test2','test@ahoo.cn',2007/5/25 14:22);

数据类型检查：修改第一列后，第一列成功；所以是最后一列登陆时间出错

insert into oneonesale(id,姓名,邮箱地址) values(100, 'test4', 'test@yahoo.cn');
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(13,'test1','test@yahoo.cn',2007/3/22 16:27));
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(19,'test1','test@yahoo.cn',2007/10/25 14:13));
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(42,'test1','test@yahoo.cn',2007/10/25 14:20));
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(45,'test2','test@yahoo.cn',2007/4/25 14:17));
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(49,'test2','test@ahoo.cn',2007/5/25 14:22));

将最后一组时间加上引号

insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(100, 'test4', 'test@yahoo.cn','2007/11/25 16:31');
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(13,'test1','test@yahoo.cn','2007/3/22 16:27');
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(19,'test1','test@yahoo.cn','2007/10/25 14:13');
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(42,'test1','test@yahoo.cn','2007/10/25 14:20');
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(45,'test2','test@yahoo.cn','2007/4/25 14:17');
insert into oneonesale(id,姓名,邮箱地址,最后登陆时间) values(49,'test2','test@ahoo.cn','2007/5/25 14:22');

成功！所以是没有加引号的问题。加上引号就可以用了。