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

I need a procedure which takes input of the parent table name and in turn drops the table and its child tables from the DB.

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

Write SQL query to find the department (prompt from user (optional)) whose employees decreased in 1996 compared to 1995

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 are the link types for joins, =? What datasets result? I cannot find anything about these link types online or in Help.

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