-
What are the features of MySQL?
GaneshVilas
- Jan 5th, 2010
MySql has many advantages in compare to Oracle.1 - MySql is Open source, which can be available any time2 - MySql has no cost of development purpose.3 - MySql has most of features , which oracle provi...
-
What are the levels of triggers supported by MySQL?
-
How we can count duplicate entry in particular table against Primary Key ? What are constraints?
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
- 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
-
Fetch Data
How will you fetch the records of last week and last month?
Ravi Ranjan Kumar
- Feb 23rd, 2009
Select * from state where stateTime > date_sub(curdate(),interval 7 day);
hamsa_mohan
- Feb 18th, 2009
Select * from table1 where date_a > date_sub(current_date,inteval 7 day);
-
Avoid Execution Time Out Error
How can you avoid execution time out error while fetching record from MySQL?
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 -
Export to XML File
How will you export tables as an XML file?
veerbahadur
- Dec 24th, 2008
You can export any result set from MySQL Query Browser by right-clicking within the result set and choosing an option from the Export Resultset sub-menu. You can choose to export the...
-
How to view all Stored Procedures in MySQL?
Veer_Bahadur
- Feb 1st, 2008
In my previous answer:I used / by mistakeplease use show procedure statusg
-
What is a sequence of execution of select * from tablename?
-
What are the vital advantages of MYSQL?
sampra
- Mar 10th, 2008
It is opensourse sw easy to download and install and very easy forsall application
-
How is Sequences handled in MySQL?
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
-
Which version of MySQL supports Subquery?
-
What are the key Relational Database features that MySQL provides?
sampra
- Mar 10th, 2008
Mysql has provided all feateute of relational database like view sequence join index trigger etc
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...
-
What is the difference between MySQL 4.0 and MySQL 5.0?
cvr_lara
- Aug 13th, 2007
1. MySQL 5 supports stored procedure completely,which 4 does not.2. MySQL 5 supports VIEWS.
-
How to Set different timezone for different persistent connection on MySql or in PHP?
rockxy1214
- Feb 20th, 2008
If u r talking about setting different timezone from diff connection on same DB then i wont think its possibleAs per My knowledge Time zone settings are golbal and are applied server side
-
How MySQL helps in reducing the Total Cost of Ownership (TCO) of database?
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
-
How do you reformat system date in MySQL?Explain various formats ..? how to add a date/hour/minute/second to a date?
rockxy1214
- Feb 20th, 2008
You can change the date time format with DATE_FORMAT() functioneaxmple:select date_format(datetime column,'%Y-%M-%d %H:%i:%s') from table_name;or u can add some time to date with thisselect concat('+strDate_End+',' 13:30:00.0') from table_name
-
-
What is a Trigger in MySQL? Define different types of Trigger?
Veer_Bahadur
- Feb 1st, 2008
A trigger is a named database object that is associated with a table and that is activated when a particular event occurs for the table. For example, the following statements create a table and an INS...
-
How many storage types are present in MySQL? Define each in detail?
amit
- Nov 24th, 2007
There are five types of db engines MyISAM(default type),INNODb,BDB,Heap,Mearge,Temproray
shilpak10
- May 28th, 2007
Refer this link for the details http://www.mysql.org/doc/refman/5.0/en/storage-engines.html
-
MYSQL Interview Questions
Ans