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,There is no rowid counterpart in MySQL. But if you want same feature in MySQL then you need to add following column in each table you need rowid.id bigint unsigned not null autoincrement If you need any further assistance or discussion please mail me at altafhsayyed@yahoo.com Thanks and regards

gakorde

 Profile Answers by gakorde Questions by gakorde

• Oct 5th, 2010

There is no concept like rowid in MySQL

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

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

Is it required to use Index when the MySQL table has only 100 rows? Justify your answer

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Hi,Index is used to speed up query.If particular column is used often in queries and table has lot of data.Then it is recommended to create index for that column of the table. It will speed up the que...

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Index is a database structure which stores column value in order and pointer to the row containing this value.During query execution index is used to fast search column data used in where condition. I...

Answer Question  Select Best Answer

Can use rownum.If possible explain.regards,Joe

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Yes it is possible.Please check following syntax:delete from table1 USING table1, table1 as vtable WHERE (NOT table1.ID=vtable.ID) AND (table1.field_name=vtable.field_name)In above place column name i...

duttasujata

 Profile Answers by duttasujata Questions by duttasujata

• Oct 21st, 2010

Delete T1 from tablename as T1, tablename as T2 where T1.name=T2.name and T1.id>T2.id

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

mzeeshan

 Profile Answers by mzeeshan Questions by mzeeshan

• Jun 25th, 2010

We can store images and videos as well by converting the picture or audio/video into  the byte array using C#/ VB and store it in a database as binary file (set the type of the field as binary).because at the end every file is a binary so if you store it as binary it will definitely works!

rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• Jan 31st, 2010

Images can stored into field with BLOB data type in MySQL database.

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

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

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

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

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

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Hello everybody,We can copy database through following meansBackup( Physical or logical)ReplicationIn physical backup database files are copied and pasted to target location.We can use any file backup...

Armstrong Bala

 Profile Answers by Armstrong Bala Questions by Armstrong Bala

• May 23rd, 2011

Export the database in .sql format from 1 system and import that .sql file to another system using phpmyadmin tool.

Answer Question  Select Best Answer

Select salary from tablename order by desc limt 4;

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Suppose we have to find records in the emp_salary table with nth highest value for salary.select * from emp_salary whare salary in(select distinct salary from emp_salary order by salary desc limit n-1,1);

Siva Krishna Yarlagadda

 Profile Answers by Siva Krishna Yarlagadda Questions by Siva Krishna Yarlagadda

• Apr 3rd, 2011

Select salary form employee order by salary desc limit 1,13rd Highest Salary-->Change Limit 2,14th highest salary-->change Limit 3,1

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

drseervi

 Profile Answers by drseervi Questions by drseervi

• May 23rd, 2009

1. Primary key does not allow duplocate.2. We can use below query to find duplicate records select count(*),classifiedID  as tot  from jicka_photos  group by classifiedID  HAVING count(classifiedID) >1 limit 5;Thanks

sampra

 Profile Answers by sampra Questions by sampra

• Feb 14th, 2008

i want to know how u will find primary key in duplicate data .can we find a primary key in duplicate data

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

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