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 ….

Xbox Content Downloads without xbox connected- Burned DVDs for content downloads

Is it possible to get content downloads and MODs transfered to the XBOX without the XBOX connected with a highspeed connection. Basically can i add these by burning them to a CD or DVD? How do I do this?
Also is it legal to copy Games and stick my own music or add the mods to a new DVD along with the game as long as i own the game and dont give it out?

it cant be done

the reason why is that downloadable content is too big to fit on a conventional memory card and also incompatible.

the only way to do it without a memory card would be to modify the hardware in your xbox (a modchip). once done you can run unsigned code one your box. among other things this would allow for ftping into your box to move the necessary files across. you would of course need to know what the modified files were.

thats the long answer to the no answers above.

There is a DVD magazine made by microsoft that costs 7-8 bucks a pop.

Its called exhibition.

It has all the recenbt downlaoded content on it for your installing pleasure, as well as recent game demos. Its pretty nice if you dont want xbox live. But for the price of 6-7 of these, you can have a year of live, so whats the point?

Exporting from 3D Studio Max into OpenGL

I’m developing a game in OpenGL and C++. I need an efficient (and clean) way of exporting models and scene info from 3D Studio Max into OpenGL. I’ve tried ASCII export. Is there something better?

Download this program:
http://www.xdsoft.com/explorer/
it can conver different 3d formats, so you can choose some of them like *.3ds, *.x *.cpp(OpenGL code format), etc.

How to rename a file name to a prefix + current date in DOS batch file

Hi

My machine is an NT. Everyday, there will be a file (i.e. abc.txt) output to my NT server & I need to write a program (in DOS batch file) to rename the file from abc.txt to abc210300.txt

The 210300 means 21st March 2000, if today is 21/3/2000. So, everyday the program will be scheduled to run and reanme the abc.txt to

“abc” + current date + “.txt”

This is the batch file commands I have now, but I don’t know how to put in the date portion.

@echo off
echo.

rename c:\temp\abc.txt abc123.txt

@echo off

Thank you.
n_chai

there is no way to write a batch file(*.BAT, with out using some sort of program.

I could wirte the program for you, use some programs i have at home.

Heuristic Tic-Tac-Toe(VB)

CAn anyone tell me how to search a 3X3,4X4,5X5 and a 6X6 Tic tac toe state space using best-first or breadth first or depth first search or even minimax, and the computer is playing against itself and should keep track of visited paths.(Visual Basic)

Explanations and code for VB here http://visualbasic.about.com/library/weekly/aa093002a.htm