![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 5476 阅读 · 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 · 2540 阅读 · 0 评论