Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 12th, 2018

Key/SuperKey: It is the column or set of columns that can be use to uniquely identify the records/tuples in a table. There can be possibility of multiple SkeyuperKey in a relation/table. Candidate ...

veerbahadur

 Profile Answers by veerbahadur Questions by veerbahadur

• Dec 24th, 2008

Any attribute that is uniquely identify a row in a table is candidate key for the table. We select one of the candidate key as Primary key. All candidate keys which are not chosen as "primary key" are...

Answer Question  Select Best Answer

Anupam Kumar

• Jan 7th, 2018

SELECT COUNT(*) FROM table_name;

Bhagya Killi

 Profile Answers by Bhagya Killi Questions by Bhagya Killi

• Jun 14th, 2016

Select count(*) from table name

Answer Question  Select Best Answer

prakash s

• Nov 20th, 2017

Describe tablename;

Bhagya Killi

• Jun 13th, 2016

DESC TABLENAME will give you the structure of table

Answer Question  Select Best Answer

Amith L

• Jul 11th, 2017

You can find out nth highest salary, In the below code just change the where condition i.e., if you want to get 2nd highest salary, use where (2)"mysql SELECT * FROM CUSTOMER CUS1...

Dan Rusk

• May 1st, 2017

Code
 

Answer Question  Select Best Answer

raja

• Jul 7th, 2017

Int, Char, Varchar, double, float, etc..

Bhagya Killi

 Profile Answers by Bhagya Killi Questions by Bhagya Killi

• Jun 14th, 2016

1.Numeric Datatype
2.Date and Time Datatype
3.String Datatype

Answer Question  Select Best Answer

Onkar Nath Maurya

• May 29th, 2017

All type join supports in mysql
Inner join
Full join
Left join
Right join
Union join

Bhagya Killi

 Profile Answers by Bhagya Killi Questions by Bhagya Killi

• Jun 14th, 2016

Inner Join
Left Join
Right Join
Full Join

Answer Question  Select Best Answer

Define Routine and Stored Procedure in MySQL database?

Bhagya Killi

 Profile Answers by Bhagya Killi Questions by Bhagya Killi

• Jun 14th, 2016

A stored routine is a set of SQL statements that can be stored in the server. Stored Routine is either a procedure or a function.

Answer Question  Select Best Answer

Bhagya Killi

 Profile Answers by Bhagya Killi Questions by Bhagya Killi

• Jun 14th, 2016

Full outer join returns all matched rows from left table and right table. In simple words, it is a combination of both right and left joins

LUCKY

• Aug 28th, 2011

SELECT TABLE1.COLOMN ,TABLE1.COLUMN......, TABLE2.COLOMN, TABLE2.COLUMN FROM TABLE1 OUTTER JOIN ON TABLE1.COMMON COLUMN= TABLE2.COMMON COLUMN

Answer Question  Select Best Answer

Which of the following is not a MySQL Operator?a. Between..and..,b. Like,c. IN,d. Is NULL

Bhagya Killi

 Profile Answers by Bhagya Killi Questions by Bhagya Killi

• Jun 14th, 2016

D. Is NULL

vijay

• May 22nd, 2015

Is NULL

Answer Question  Select Best Answer

What are the different types of users available in MySQL?

Suman Das

• Oct 23rd, 2015

Types Of Users In DataBase :
1)DBA
2)Naive
3)End.
4)Applicaton Developer.
etc.

Answer Question  Select Best Answer

jiten shahi

• Jun 16th, 2015

12

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

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

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

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

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 30th, 2011

Details of existing stored procedures in MySQL can be obtained from ROUTINES table in INFORMATION_SCHEMA database.

Stored Procedures can be managed using the following:

CREATE [FUNCTION|PROCEDURE]
ALTER [FUNCTION|PROCEDURE]
DROP [FUNCTION|PROCEDURE]
SHOW CREATE [FUNCTION|PROCEDURE]

Answer Question  Select Best Answer

What is better to use, Views or Cursors? Why?

Sumy

• Oct 3rd, 2011

Views are best to use.

The Reason behind this is mainly the performance. Views just have select statements and retrieves the information faster. Cursors take time to retrieve the info row by row.

Thanks In advance!

Answer Question  Select Best Answer

Satish

• Sep 9th, 2011

They are the same, its like execute alias name is exec.there is a difference between EXEC() and EXEC , EXEC()function takes dynamic string as input and executes them and it needs more bytes compared.

Answer Question  Select Best Answer

Anant

• Aug 9th, 2011

Type

Show Triggers;

sampra

 Profile Answers by sampra Questions by sampra

• Feb 13th, 2008

show triggers;     

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