Interested to Buy Any Domain ? << Click Here >> for more details...
about foregine
- 2 Answers
- 4291 Views
- I also Faced
- E-Mail Answers
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 difference between function and procedure in mysql?
Can you shard mysql?
What is mysql protocol?
Can we store images in mysql database?
what is cte? : Mysql dba
What is tee command in mysql?
Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage
Is mysql relational?
What happens if null values are involved in expressions?
What is the use of mysqli_fetch_array?
-
Oracle (3253) - 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)
