does PHP support foreign key and Rollback?yes or not.if not
then why. how will you done these concept in php?
- 1 Answers
- 6002 Views
- Avanigoradia, Primus Global, I also Faced
- E-Mail Answers
PHP supports Foreign Keys in InnoDB Storage Engine in
version and above 4.0. It checks the foreign key referential
integrities on Delete and Select statements. If you strictly
needed the foreign keys and speed is not a concern then you
can create table structures using InnoDB Storage Engine.
Where as MyISAM Storage Engines does not allow foreign key
concept. But it will parse the table that contains foreign
keys but wont check the referential integreties. So it is
the job of the designer/programmer to check the desired key
and its dependency in multiple tables.
Let us suppose you have a field F1(primary)in Table1 and
this field is referenced in another tables denoted as (F2,
F3) in tables Table2, Table3......(as a foreign key)
and when you want to perform a DELETE operation/query based
on field F1, then
First you need to write a query to Delete the specified row
in Table1
and you also need to write a query to Delete all
dependent/referenced rows in other tables Table2, Table3...
| Is This Answer Correct ? | 6 Yes | 0 No |
for image work which library?
How to create connection in php?
How do you check if a variable has not been set in php?
How to close a session properly?
List the different types of print functions available in php?
Write a program to find a string is palindrome or not?
Explain the types of functions for Splitting String?
What is user defined function in php?
how to upload more than 50 mb? i tried but session was expired....certain time .....i was set session duration three days .... how to rectified? if any one know that post ur answer as soon as possible?already i was increase php.ini and set Also increase Memory_limit Post_max_size upload_max_filesize..........but not working......
How can we submit a form without a submit button?
23 Answers ABC, HCL, Infosys, Kept Bug, Panys, Rushmore Consultancy, Torque Infotech, Wipro, zCon Solutions,
How can we enable error reporting in php?
What is mvc? Why its been used?
PHP 
