Do it this way:
Create Table copy ( sessionid int not null auto_increment,
username varchar(20 not null,
start int not null,
stop int not null,
ipaddress varchar(15),
Primary Key (sessionid),
Index altkey (username, start, stop)
);
Insert Into copy
Select NULL, username, start, s
> Hi,
>
> I have a mysql table:
> +---+--+--+-+
> | Field | Type | Null | Key |
> +---+--+--+-+
> | sessionid | int(10) unsigned | | PRI |
> | username | char(20) | | MUL |
> | start | int(10) u
That seems like rather a bad idea to me.
Would that not leave anything else that references the sessions
looking at the wrong session?
Jaime Teng wrote:
> Hi,
>
> I have a mysql table:
> +---+--+--+-+
> | Field | Type | Null | Key |
> +---
Hi,
I have a mysql table:
+---+--+--+-+
| Field | Type | Null | Key |
+---+--+--+-+
| sessionid | int(10) unsigned | | PRI |
| username | char(20) | | MUL |
| start | int(10) unsigned | | M
