You're using a foreign key. http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html. In order for the constraints to work, the DB must be type InnoDB. Otherwise the data checks for integrety must be done by you in the INSERT program.
Respectfully, Ligaya Turmelle "pramilav" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Dear All, > > I have created a table Product1 with columns pid, data, keyword. I had > been requested to create another table Product2 with the columns pid, > cname, itis given that (pid -int - reference to Product1). > > My problem is how will i create a second table. > > Help needed. > > Thanks, > Pramilav > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
