How to implement views in mysql 4.12 version

mirgration from oracle to mysql is started and i need to meet the solution as soon as possible. Thanks in advance bye dayakar

ERROR 1216: Cannot add or update a child row: a foreign key constraint fails

fails can any one respond back to this. bye dayakar

how to create views in mysql4.1

Hello friends, Can any one help me in creating view using mysql4.1. If we cannot then any other alternative. It would be great if anyone give me an example for that. regards dayakar SMILE ALL THE WHILE.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Help needed in creating primary key ,foreign key on a varchar datatype colum

in mysql. I have tried doing the same by seeing the examples given in mysql manual but not successfull. If any one can help me by giving a example then it would be great help for me. regards dayakar