Answer Posted / vishal
foreign key is the key reference of primary key in first
table suppose u have two table emp and dept in both there is
deptid than we make deptid in dept table as foreign key and
on we add dept in the dept table only when there is entry in
emp table and delete from emp only when there is no
corresponding entry in dept table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we store pdf files in mysql?
How to escape special characters in sql statements?
Can you tell which of the following where clauses is faster?
Which is faster mongodb or mysql?
Is mysql a relational database?
What is delimiter in mysql?
What is ntext?
How can we run batch mode in mysql?
How do I exit mysql?
How do I connect to mysql database?
What is data directory in mysql?
What is the default port for MySQL Server?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
What is difference between statement and preparedstatement?
What can I do with mysql?