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

The user should be permitted to only "SELECT" entries from the given database.

What resources did you use to do research for this project?

What development tools did you do use to complete the project?
How did you test & debug the project?

Why have you chosen to use the programming language used in the project?

sumanth.boss

 Profile Answers by sumanth.boss Questions by sumanth.boss

• May 26th, 2012

Dude, i tried to execute it . it execute successfully . but the grantACC is not getting executed . after adding user and trying to login him , it is saying error 1045(28000)

vishnu raju

• Mar 13th, 2012

try this :)"cpp #include #include #include #include int main() { char name[10]; char password[10]; char database[10]; char addUser[60]=""; char grantACC[60]=""; // initiali...

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

emansm

• Dec 19th, 2014

Hi,
Can you tell me the difference between Exception and Error in Mysql

thanx

aniketvsawant

 Profile Answers by aniketvsawant Questions by aniketvsawant

• May 29th, 2008

Most programming languages have some type of error handling that allow the programmer to deal with errors or exceptions that are raised within the program. It’s likely you will have at some time...

Answer Question  Select Best Answer

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

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