Interested to Buy Any Domain ? << Click Here >> for more details...
does PHP support foreign key and Rollback?yes or not.if not
then why. how will you done these concept in php?
- 1 Answers
- 6436 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 |
Tell me what kind of things have you done on the social side?
What is regular expression in javascript?
What are php variables?
What does $this do in php?
How many php based companies in bangalore and chennai and over all india ? most of the persons saying for 2 years and 3 years they will be getting less than 15k per month how far is it true ? is it good scope for experience people can any one tell the exact experience pay for php developers one yr experience how much sal we expect ? two yr experience how much sal we expect ? three yr expereince how much sal we expect ? please kindly reply to the above questions as an experts you only please kindly judge and tell your practical experience in PHP ?
What is happening in the following code $objA = new A(); // A is a class $objB = $objA;
How check field is empty or not in php?
How to repeat a string to a specific number of times in php?
How can we know the total number of elements of Array?
how many type of url?
What is strcmp () in php?
What is RSS?How to use it in Program?
PHP 
