about foregine
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / malli
foregine key is normal key of first(base) table. in
second(child)table it is primary key which is referenced by
the first(base) table.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is meant by decimal (5,2)?
How to enter numeric values as hex numbers?
How to define numeric 9(3) in db2 table without decimal point??
What are slow queries?
What are views in mysql?
How do I restore a mysql database dump file in linux?
How to rename an existing table in mysql?
How do I download mysql?
How do I find users in mysql?
The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
What is mysql and why it is used?
How do I change the max connection in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)