just explain MYSql ISAM and InnoDB functions. and what is
the diffrent between both. and which is the better in both.
Answers were Sorted based on User's Feedback
Answer / suresh
Mysql ISAM is an default storage engine...
And InnoDB supports transactions and foriegn keys
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pooja
MyISAM is a deafult storage engine in MySQL and is mostly in
WEB, data warehousing and other application environments.
InnoDB is also a storage engine in MySQL. Even this is
included by default in MySQL. But this is used for
transaction processing applications and supports a number
of features including ACID transaction support and foreign keys.
In source distributions, you can enable or disable either
engine by configuring MySQL as you like.
Both are best but it depends on the use. And for general
purpose its better to use MyISAM.
| Is This Answer Correct ? | 2 Yes | 0 No |
How can we check the value of a given variable is a number?
What is include in php?
What is var_dump function in php?
Is php easier than node?
What good is polymorphism?
What is the difference between die () and exit () in php?
<?php /** * @version 1.0 $ * @package HelloWorld * @copyright (C) 2005 Andrew Eddie * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL */ /** ensure this file is being included by a parent file */ defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' ); ?> <?php $database =& JFactory::getDBO(); //$sql = 'SELECT name, username FROM #__users'; $sql="select a.id, a.title, a.introtext, a.created_by, a.created from jos_content a, jos_content_frontpage b where a.id=b.content_id and b.ordering='2'"; $database->setQuery( $sql ); $user = NULL; $user = $database->loadObject(); //echo 'Name: ' . $user->name . '<br />'; echo '<h1>' . $user->title . '</h1><br />'; //echo 'Username: ' . $user->username; echo ' ' . $user->introtext; i write this and fetch the result from the database the result is The Intranet is up and working ! Our intranet is up and working and should be accessible from both Mumbai and NOIDA. As you will notice, this template, look & feel is not in line with our corporate indentity but we chose the route of "form-follows-funtion" In the first phase, we are rolling out functionality that is critical to all of us - Policies and How-to documents. In subsequent phases, we will be launching other features. Keep watching this space for more details i want to see only 4 line of top then how this may done
How to convert strings to upper or lower cases?
How is it possible to know the number of rows returned in the result set?
What is the difference between php 5 and php 7?
Can we set session value in javascript?
How cookies are trported from browsers to servers?