Remasri

 Profile Answers by Remasri Questions by Remasri

• May 2nd, 2007

MySQL only supports one index type, but implements different data access paths using the various table types. The eight types of Oracle indexes are B-tree, B-tree Cluster, Hash Cluster, Reverse Key, Bitmap, Bitmap Join, Function-Based, and Domain.

StephenRaj

 Profile Answers by StephenRaj Questions by StephenRaj

• May 2nd, 2007

MySQL supports six different types of tables, four of which do not support transactions (MyISAM, MERGE, ISAM, and HEAP) and two of which support transactions (InnoDB and BDB). The multiple table types...

Answer Question  Select Best Answer

kalyan c y

• May 14th, 2007

Query Cache stores? both? SELECT statenment? and? its result;?if any? similar query recives later it will retrive result from query plan; Query Cache is not use full for server side Prepared Statement

Answer Question  Select Best Answer

bhavin parikh

• Aug 23rd, 2007

CREATE TRIGGER `tgr_name` AFTER UPDATE ON `addresses` FOR EACH ROW begin    update products set countryName = new.countryName where products.shippingAddressId = old.id;end;

Answer Question  Select Best Answer

Prakash

• Sep 22nd, 2007

For the configuration of MySql these dependencies are required as:mysql-5.0mysql-server-5.0mysqlclient9-5.0mysql-devel-5.0php-mysql-5.0install by rpm -i vh mysql-server-5.0.rpm and others also sameIf ...

Answer Question  Select Best Answer

amit

• Nov 24th, 2007

There are five types of db engines MyISAM(default type),INNODb,BDB,Heap,Mearge,Temproray

shilpak10

 Profile Answers by shilpak10 Questions by shilpak10

• May 28th, 2007

Refer this link for the details http://www.mysql.org/doc/refman/5.0/en/storage-engines.html

Answer Question  Select Best Answer

Veer_Bahadur

 Profile Answers by Veer_Bahadur Questions by Veer_Bahadur

• Feb 1st, 2008

A trigger is a named database object that is associated with a table and that is activated when a particular event occurs for the table. For example, the following statements create a table and an INS...

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Feb 14th, 2008

Make clear qus first

Answer Question  Select Best Answer

rockxy1214

 Profile Answers by rockxy1214 Questions by rockxy1214

• Feb 20th, 2008

You can change the date time format with DATE_FORMAT() functioneaxmple:select date_format(datetime column,'%Y-%M-%d %H:%i:%s')  from table_name;or u can add some time to date with thisselect concat('+strDate_End+',' 13:30:00.0') from table_name

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 4th, 2008

Beacuse its free to dwnload and use

rockxy1214

 Profile Answers by rockxy1214 Questions by rockxy1214

• Feb 20th, 2008

Mysql is a open source so u can get the source code and complie ur selfor get pre compiled setups based on the OS for freeAnd if we consider other leading Database sources mysql is much cheper and easy to manage

Answer Question  Select Best Answer

rockxy1214

 Profile Answers by rockxy1214 Questions by rockxy1214

• Feb 20th, 2008

If u r talking about setting different timezone from diff connection on same DB then i wont think its possibleAs per My knowledge Time zone settings are golbal and are applied server side

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Mysql5 support view and procedure where as 4 is not support

cvr_lara

• Aug 13th, 2007

1. MySQL 5 supports stored procedure completely,which 4  does not.2. MySQL 5 supports VIEWS. 

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Mysql has provided all feateute of relational database like view sequence join index trigger etc

shilpak10

 Profile Answers by shilpak10 Questions by shilpak10

• May 28th, 2007

MySQL supports all the key Relational Database features, including: * High-performance * Main-memory tables with disk-based tables* Single-User and Multi-User * Multi-Threaded * Multi...

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Mysql 4.0 onwards support subquery

shilpak10

 Profile Answers by shilpak10 Questions by shilpak10

• May 28th, 2007

From mysql 4 onwards.......

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Sequence handle is a concept by which we can provide a auto a auto genrated key to database like we have to provide primary key that is unique  then we can use the squence

M.V.S.Arun Kumar

• May 10th, 2007

Sequences are handled by primary key or by unique in which primary keys don't allow any duplicate rows and null values are not accepted. Sequences and unique allows multiple NULL values and duplicates values are not allowed

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

It is opensourse sw easy to download and install and very easy forsall application

Answer Question  Select Best Answer

deep_pinu

 Profile Answers by deep_pinu Questions by deep_pinu

• Mar 10th, 2008

Hey,here it is :--select/update/delet/insert- from-where-group by-having-order byI think this is the oder of the execution.

sampra

 Profile Answers by sampra Questions by sampra

• Feb 20th, 2008

Identifiy table and then take data (row) in forwad order and then print on console accordoing to condition.

Answer Question  Select Best Answer

rockxy1214

 Profile Answers by rockxy1214 Questions by rockxy1214

• May 30th, 2008

Select * from information_schema.ROUTINES;

Veer_Bahadur

 Profile Answers by Veer_Bahadur Questions by Veer_Bahadur

• Feb 1st, 2008

In my  previous answer:I used / by mistakeplease use show procedure statusg

Answer Question  Select Best Answer

How will you export tables as an XML file?

veerbahadur

 Profile Answers by veerbahadur Questions by veerbahadur

• Dec 24th, 2008

You can export any result set from MySQL Query Browser by right-clicking within the result set and choosing an option from the Export Resultset sub-menu. You can choose to export the...

Answer Question  Select Best Answer

How can you avoid execution time out error while fetching record from MySQL?

veerbahadur

 Profile Answers by veerbahadur Questions by veerbahadur

• Dec 24th, 2008

It is done by using the PHP function
void set_time_limit ( int $seconds )
If seconds set to zero, no time limit is imposed.
Use the below resource:
http: //in2.php . net/manual/en/function.set-time-limit . php

Gaurav.shrivastava

 Profile Answers by Gaurav.shrivastava Questions by Gaurav.shrivastava

• Nov 10th, 2008

Set max_execution_time() on php.ini file

Answer Question  Select Best Answer

How will you fetch the records of last week and last month?

Ravi Ranjan Kumar

 Profile Answers by Ravi Ranjan Kumar Questions by Ravi Ranjan Kumar

• Feb 23rd, 2009

Select * from state where stateTime  > date_sub(curdate(),interval 7 day);

hamsa_mohan

 Profile Answers by hamsa_mohan Questions by hamsa_mohan

• Feb 18th, 2009

Select * from table1 where date_a  > date_sub(current_date,inteval 7 day);

Answer Question  Select Best Answer