sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Really good question

Anand

• Feb 15th, 2007

There are eleven drivers in MYSQL .Six of them from MySQL AB and five by MYSQL Communities.They are1.PHP Driver2.ODBC Driver3.JDBC Driver4.ado.net5.mxj6.CAPI1PHP DRIVER2.PERL DRIVER3.PYTHON DRIVER4.RUBY DRIVER5.C++ WRAPPER

Answer Question  Select Best Answer

AMIT

• Jan 20th, 2014

SELECT *
FROM (SELECT * FROM CATEGORY LIMIT n) AS TEMP
LIMIT n-1,1;

gakorde

 Profile Answers by gakorde Questions by gakorde

• Oct 5th, 2010

SELECT * FROM (SELECT * FROM CATEGORY LIMIT n) AS TEMPLIMIT n-1,1;

Answer Question  Select Best Answer

hafiz rafaqat

• Jun 1st, 2014

What is the difference bw time stamp and subtype discriminator?

gakorde

 Profile Answers by gakorde Questions by gakorde

• Oct 5th, 2010

Weak Entity is entity dependeant on other entity.Subtypes are data types inherited from basic data types in Oracle. we can specify additional constraint on subtype while defining them.

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

Which cursor type do you use to retrieve multiple recordsets?

gakorde

 Profile Answers by gakorde Questions by gakorde

• Oct 5th, 2010

These is no cursor types in MySQL as it is in Oracle.Cursors in MySQL have these properties:Asensitive: The server may or may not make a copy of its result tableRead only: Not updatabl...

priyanka066

 Profile Answers by priyanka066 Questions by priyanka066

• Dec 17th, 2009

This ans opt for Oracle DB - SYS_REFCURSOR. this is what we called Explicit cursor. In database if you run any sql statement by default system will create a cursor. its called "Implicit cursor&qu...

Answer Question  Select Best Answer

What is the query to get all tables from the selected database in MYSQL?

umapathi.b

 Profile Answers by umapathi.b Questions by umapathi.b

• Jul 24th, 2010

SELECT table_name FROM information_schema.tables WHERE table_schema = 'dbname';

Subhashini J

 Profile Answers by Subhashini J Questions by Subhashini J

• Mar 8th, 2010

use databasename;show tables;

Answer Question  Select Best Answer

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Hi,When you update or add privileges in MySQL grant tables(db,users,tables,columns,hosts etc) are updated. These changes takes effect when mysql server restarts. MySQL server reads all grant tables at...

adilraufkhan

 Profile Answers by adilraufkhan Questions by adilraufkhan

• Feb 17th, 2009

Reload privileges are used to apply any changes on settings related to privileges without re starting Mysql's current sessionsyntax to use:mysql -u username -p password -e "flush privileges";

Answer Question  Select Best Answer

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Hi,MySQL is written in C,C++.MySQL supports following platforms.Please check URL.http://dev.mysql.com/doc/refman/5.0/en/supported-os.htmlThere are 2 methods for installing mysql:1. Installing compiled...

Veer_Bahadur

 Profile Answers by Veer_Bahadur Questions by Veer_Bahadur

• Feb 1st, 2008

It supports all platforms but depending upon the platforms it have different different setup files and libraries.

Answer Question  Select Best Answer

GaneshVilas

 Profile Answers by GaneshVilas Questions by GaneshVilas

• Jan 5th, 2010

MySql has many advantages in compare to Oracle.1 - MySql is Open source, which can be available any time2 - MySql has no cost of development purpose.3 - MySql has most of features , which oracle provi...

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Ans of this question is given above

Answer Question  Select Best Answer

rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• Jan 31st, 2010

Subqueries in MySQL are handled in the following way.For e.g Schema for sailor table :Sid:int(2) PKSName:varchar(15)Rating:int(3)Age int(3)If you want to select name and age of oldest sailor, its query will  be as followsSELECT Sname,Age FROM sailors WHERE Age IN (SELECT max(Age) FROM sailors)

amitverma

 Profile Answers by amitverma Questions by amitverma

• Sep 25th, 2008

Sub queries in MySQL handled?nested way, You can see the example and understand yourself -SELECT name, headofstate, population FROM Country WHERE population=(SELECT MAX(population) FROM Country);

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

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

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

Read Best Answer

Editorial / Best Answer

Answered by: Lakum

• Aug 26th, 2007

---

This is an open source .. No licensing cost to pay. This itself is big thing even there are not many features like Oracle RAC, But you can manage all that with multiple servers and load balancing features. Provides Gui with Command Prompt. Supports the administration using MySQL Admin,MySQL Query Browser. Latest version supports stored procedures and functions. The best things is runs in windows and Unix/Linux.

Lakum

• Aug 26th, 2007

This is an open source .. No licensing cost to pay. This itself is big thing even there are not many features like Oracle RAC, But you can manage all that with multiple servers and load balancing feat...

kishor ranga

• Jul 22nd, 2006

MySql has many advantages in comparison to Oracle.1 - MySql is Open source, which can be available any time 2 - MySql has no cost of development purpose.3 - MySql has most of features , which oracle p...

Improve Answer

umapathi.b

 Profile Answers by umapathi.b Questions by umapathi.b

• Jul 24th, 2010

It is just same as creating procedure in Oracle.  The only difference is with the syntax. DROP PROCEDURE IF EXISTS xyz;eg:CREATE PROCEDURE xyz ( a int,b char,c varchar)BEGINSELECT now();SELECT cu...

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Will find it soon and then let you know

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 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

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

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

How to create a MySQL Database in PHP?

Tejanshu

 Profile Answers by Tejanshu Questions by Tejanshu

• Mar 8th, 2010

 mysql_query("CREATE DATABASE databasename", connector) is the answer. Where mysql_query() is the PHP function that uses the CREATE DATABASE mysql command.Here is a small code snippet. ...

rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• Jan 14th, 2010

Mysql database can be created using php by executing CREATE DATABASE query using mysql_query() function in php

Answer Question  Select Best Answer