I want to ENTER Sr.No. and Name in the table using procedures.
My table has attributes
1. Sr.No. (which is my primary key(int datatype))
2. Name (which is not null(string datatype))
I want to write a procedure in mysql to automate the process of entering data in the table using procedures..It would be like ..
--At first table is empty
--CALL the procedure
--After Calling procedure table will have 400,000 (4lacs) entries..
Thanking you in advance