-
-
How to view all Triggers in MySQL?
Anant
- Aug 9th, 2011
Type
Show Triggers; -
What is RELOAD privileges in MySQL used for?
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
- 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";
-
What are the Platforms supported by MySQL?
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
- Feb 1st, 2008
It supports all platforms but depending upon the platforms it have different different setup files and libraries.
-
Is it possible to delete duplicate records from a table with out using rowid in MYSQL?
Can use rownum.If possible explain.regards,Joe
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
- Oct 21st, 2010
Delete T1 from tablename as T1, tablename as T2 where T1.name=T2.name and T1.id>T2.id
-
How a database is copied from one machine to another?Explain with an example.
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
- May 23rd, 2011
Export the database in .sql format from 1 system and import that .sql file to another system using phpmyadmin tool.
-
How to display nth highest record in a table for example ?
Select salary from tablename order by desc limt 4;
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
- 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
-
What is the Oracle rowid counterpart in MySQL?
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
-
Using Table Index
Is it required to use Index when the MySQL table has only 100 rows? Justify your answer
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
- 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...
-
How many drivers in MYSQL?
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
-
What are the advantages of mysql comparing with oracle?
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...
-
Cursor Type
Which cursor type do you use to retrieve multiple recordsets?
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
- 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...
-
1. How to create the stored procedures in mysql and it will be write on where?2. Difference between SQL stored procedures, MYSQL stored procedures, SQL Server stored procedures?
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...
-
What are the Performance and Scalability characteristics of MySQL?
umapathi.b
- Jul 24th, 2010
MySQL has got a lot to do with..It can perform very well..It has got different storage engines like myisam, innodb, memory, federated for different purposes.Like if the application requires mostly ins...
-
Get all Tables from Selected Database
What is the query to get all tables from the selected database in MYSQL?
umapathi.b
- Jul 24th, 2010
SELECT table_name FROM information_schema.tables WHERE table_schema = 'dbname';
-
How can i store images in database?
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!
-
Stored Procedure
Which version of MySQL does not support stored procedure?
-
Create MySQL Database in PHP
How to create a MySQL Database in PHP?
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
- Jan 14th, 2010
Mysql database can be created using php by executing CREATE DATABASE query using mysql_query() function in php
-
Timeout Issue
How to solve MySQL timeout issue?
arunmscit86
- Feb 19th, 2010
You can create it in /etc/my.cnf[mysqld] : : wait_timeout = 1800 connect_timeout = 10 : : You can set some of the time outs it in this manner in the file my.cnf
-
How is sub queries handled in MySQL?
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
- 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);
MYSQL Interview Questions
Read Best Answer
Ans