Is there a mySQL equiv to SQL Server’s select identity(int,1,1) as …

I’m porting aaaaa project from SQL Server to mySQL.

In SQL Server:
“Select identity(int,1,1) as id, a, b, c INTO newTable from oldTable” creates an autoNumbered id column.

In MySQL: ?

If there’s no equivalent way, I suppose I could create an empty table with an autoNumber field and then insert into it.

Actually, it’s a bit of both. Take a look here:

http://dev.mysql.com/doc/refman/5.1/en/create-table.html#id3240603

SET @i = 0;
INSERT INTO ….
SELECT @i= @i+1 as i, col2 ….

iPod Photo won’t startup, displays battery symbol/lightning bolt

Hi,

My iPod photo has ceased functioning. When i plug into my mac or into the mains adapter it does nothing until i reset it, at which point it will display a battery symbol with a lightning bolt at one end which disapears after a couple of minutes. I gather this means it’s very low on charge and is in a kind of ‘warm-up’ mode but i’ve left it plugged into both my mac and adapter for several hours and still nothing.
Is the battery screwed & if so, will I have to rip the disk out and put it in a caddy to back up my data as I have no backup and want my music/photos off it.

Thanks.

that sucks man… i saw a blog on replacing those batteries the other day http://lifehacker.com/software/ipod/how-to-replace-your-ipods-battery-236138.php maybe it will help you if you decide to go that rout ccccccccc.c