ServBit Experts Community

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

Ipod Nano not responding after soft and hard reset

Hi,
I have a first generation Ipod Nano 2GB and the buttons have stopped responding. I’ve reset it holding menu select (which is strange seeing as the buttons seem to not be responding any other time) and when that didn’t fix the problem, I restored it via computer. Still nothing… The ipod is out of warranty, so i’m looking for a FIY solution.

As mentioned, the buttons are responding when doing a soft reset, however don’t respond any other time.

The screen i am stuck on now is the language selection screen, which appeared after my hard reset.

I’ve pretty much tried everything possible that I was able to find on the internet. ie.
-Soft Reset
-Hard Reset (Restore)
-Toggle the hold switch
-Pry casing open, and then close again
-Clean around the buttons/wheel with a razor blade…

Nothing has worked so far… I even tried to drop it on the floor from about 2 feet to try to knock some sense into it…

I posted this with a value of 200 points and after about 2 weeks still have no solution, so i’ve brought the value up to 500 points.

Thanks for the help in advance.

Try the take apart, that would be the only other option. If that does not work, then it would need to be sent into Apple or the Apple Store for repair because it is damaged in some wway.

It is up to you how you want to close the question. Points are always appreciated but the goal is to help you resolve your issue. If helping you get to the conclusion that you need a new iPod, that is a resolution of sorts, as well

Move Itunes playlist/songs from Ipod to new Windows XP box

I would like to move my Itunes playlists from one computer to another. Unfortunately, my old computer hard disk crashed, so I can’t export my old songs and playlists. Is there a way to move my playlists from my Ipod to my new computer’s ITunes.

I’ve been able to move my Purchased songs to my new Itunes based on authorizing my new computer as my 2nd computer for my purchases, but I would like to move all my playlists and songs from my Ipod to my new computer/Itunes.

I’m using Windows XP Home Edition and the latest Itunes. I also have a recently purchased 30Gb IPod that was synced up to my old computer before it crashed and burned.

It’s not an esay job or cheap.
Not cheap, go to this page it presents seeral options
http://www.ilounge.com/index.php/articles/comments/copying-music-from-ipod-to-computer/
The cheap one
First set your Ipod to be used as a hard disk.
On the Ipod
Toggle the Hold switch on and off. Press and hold the Menu and Select buttons until the Apple logo appears, about 6 to 10 seconds.
press Select and Play when you see the Apple logo, the Ipod should show a check mark, now you are in Hard Disk Mode. Select the Ipod as a hard disk from explorer, with the op`tion “show hidden files” turned on, and proced to copy your music to your computer
You won’t have the names on the files so do this
Search the web and download MP3TagEditor
Run it select one of the folders recovered from the Ipod, select all songs, right click on the mouse and select rename file from tag
Do this in all the folders, the you can copy all the music files to where you want, only thing is it ONLY WORKS WITH MP3, not with ACC that is the format that ITunes uses.
For ACC just install Itunes on the new computer and impor the folders.

iPhone development: How to remove App IDs from program portal

Hi everyone,

Is there a way to remove App IDs from the iPhone Developer Program Portal? Thanks!

Check out this forum posts, hopefully it helps:

http://discussions.apple.com/message.jspa?messageID=8213153