mysql - data validation at the table-creation-time
Hello friends,
I have a table of users (user_id,password,level,..).
Now I want to create another table (station,in-charge,category,....). I want that the field in-charge of the second table should be looked up from the user_id field of the users table. This restriction I want to impose at the time of creation of table, so that always the in-charge is someone having a valid user_id.
Can anyone help me in this.
Thanks in advance,
Prabhat Soni
|