复杂的创建表sql 如何让这个表有自动增长步长为1的主键 id
create table Ua2 as
select userLogId,accessTime,max(minid) as maxID from
(select userLogId,accessTime, requestURI, min(ID) as minid
from UserRequestLog
where accessTime >'2009-07-20 00:00:00'
and accessTime <'2009-07-21 00:00:00'
group by userLogId,accessTime,requestURI
having count(*)>1000
order by userLogId,accessTime,minid
) a
group by userLogId,accessTime这里select userLogId,accessTime,max(minid) as maxID from 应该让这个表有自动增长步长为1的主键 id
如何做?
create table Ua2 as
select userLogId,accessTime,max(minid) as maxID from
(select userLogId,accessTime, requestURI, min(ID) as minid
from UserRequestLog
where accessTime >'2009-07-20 00:00:00'
and accessTime <'2009-07-21 00:00:00'
group by userLogId,accessTime,requestURI
having count(*)>1000
order by userLogId,accessTime,minid
) a
group by userLogId,accessTime这里select userLogId,accessTime,max(minid) as maxID from 应该让这个表有自动增长步长为1的主键 id
如何做?
解决方案 »
- MEMORY hash 表的插入性能问题
- 求一个完整的 my.ini 优化配置
- mysql里是否有将varchar或char 转换为 int的函数!
- 电脑坏了 MySQL 文件问题
- windows下如何用C连接mysql
- mysql+jsp插入中文乱码问题,已经尝试了所有的网上的方法,还是解决不了,请高手帮忙!!!!!!!!!!!
- 高级的PSQL,有关UPDATE,强人来帮忙呀~`
- mysql有没有约束啊?
- 远程或者本地连接MySQL时报错1130 host is not allowed to connect to this mysql server
- navicat怎么快速定位到一个表及字段?
- mysql 如何改变主键字段?
- MySQL多表查询的一个基本优化,执行效率问题
set @i=0;create table Ua2 as
select @i:=@i+1 as ID,userLogId,accessTime,max(minid) as maxID from
(select userLogId,accessTime, requestURI, min(ID) as minid
from UserRequestLog
where accessTime >'2009-07-20 00:00:00'
and accessTime <'2009-07-21 00:00:00'
group by userLogId,accessTime,requestURI
having count(*)>1000
order by userLogId,accessTime,minid
) a
group by userLogId,accessTime;select * from Ua2;
我用了2中方法
1 同josy的方法
2 用gui工具