I am using mySql query to insert a row into table.
I have two tables as Table1 and ZTable1.
Table1 has 3 fields TId,TName,TAge .
ZTable1 has 4 fields ZTId,TId,TName,TAge.
Table1 has 1 row.
Now i want to insert values to ZTAble1 as 1,(1,Myl,24) these values from Table1.
I insert that row in ZTable1 along with 1 as ZTId.
How can I do this?
Plz very urgent.