
mysql
coffeebreak
这个作者很懒,什么都没留下…
展开
-
delete from table in 卡死问题解决
delete from lamostv29Pilot where target in (select target from lamostDRsumstd);大概有7万条数据卡死出不来 delete a from lamostv29Pilot as a inner join lamostDRsumstd as b on a.target=b.target;Query OK, 75原创 2017-11-03 15:05:39 · 5553 阅读 · 1 评论 -
mysql id自动增加和时间戳
create table file_download(id int(5) not null auto_increment,login_name varchar(20) not null, name_id int(5) not null, file_name varchar(50) not null, download_time timestamp not null default current_原创 2017-11-20 00:00:35 · 2628 阅读 · 0 评论