hi all,
i got a question here, i have two tables in mysql in same databse, now i want to put the entries in both the two different tables such that contents of both the tables can be referenced by the same ID,so how do i do this? lemme know it.
Actual case:
i have one table A for software repository, where softID column is the primary key, and auto increment.
now i want to create one more table B which hosts comments on the software listed in the table A, and i want to retain the same softID as in table A.so that i can pull out any information from table B, with softID from table A.
I am happy if you are able to get my query.
Thanks in advance.
