Hi,
if you want to delete all the records from the table, user the tuncate statement to delete all the records. It will delete all ur records and automatically rest ur auto increment value. Otherwise you have to rest the value manually by the alter table statement.
Ex:
TRUNACATE TABLE <table_name>;
else
use the above method.
...
ashokkumarpdi
Last Activity: Apr 9 '08, 01:57 PM
Joined: Apr 1 '08
Location:
-
Hi,
Try with the following insert statement, in ur insert statement one comma(,) is missing.... [code=mysql]
INSERT INTO Tablename SELECT '1111',
name,address,ph one,'1111','exe c usp_storedProce dureName', '1111', '1111', 'KA','EA' FROM edi856Item
WHERE autoid = '1111'[/code]Regards,
S.Ashokkumar...Leave a comment:
No activity results to display
Leave a comment: