hi everybody,
I have problem with inserting data into table.
MY table is:-
Name type
ID int(9)autoincrement
Total int(9)
while i insert the data,i want the total(ID+2).Its mean the record should be
like this:-
ID Total
1 3
2 4
3 5
is it possible....i have try is like this
mysql>insert into TableName(total) values(ID+2);
The result is like this:-
ID Total
1 2
2 2
3 2
its cannot works....is there any ideas..........please help me....
sql,query
thanks in advance.
_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
