yushay

 Profile Answers by yushay Questions by yushay

• Aug 1st, 2009

MySQL 5.1 triggers only support each-row level

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

It is opensourse sw easy to download and install and very easy forsall application

Answer Question  Select Best Answer

kalyan c y

• May 14th, 2007

Query Cache stores? both? SELECT statenment? and? its result;?if any? similar query recives later it will retrive result from query plan; Query Cache is not use full for server side Prepared Statement

Answer Question  Select Best Answer

umapathi.b

 Profile Answers by umapathi.b Questions by 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...

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

sampra

 Profile Answers by sampra Questions by sampra

• Feb 14th, 2008

Make clear qus first

Answer Question  Select Best Answer

bhavin parikh

• Aug 23rd, 2007

CREATE TRIGGER `tgr_name` AFTER UPDATE ON `addresses` FOR EACH ROW begin    update products set countryName = new.countryName where products.shippingAddressId = old.id;end;

Answer Question  Select Best Answer

Veer_Bahadur

 Profile Answers by Veer_Bahadur Questions by 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...

Answer Question  Select Best Answer

Prakash

• Sep 22nd, 2007

For the configuration of MySql these dependencies are required as:mysql-5.0mysql-server-5.0mysqlclient9-5.0mysql-devel-5.0php-mysql-5.0install by rpm -i vh mysql-server-5.0.rpm and others also sameIf ...

Answer Question  Select Best Answer

rockxy1214

 Profile Answers by rockxy1214 Questions by 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

Answer Question  Select Best Answer

rockxy1214

 Profile Answers by rockxy1214 Questions by 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

Answer Question  Select Best Answer

How will you export tables as an XML file?

veerbahadur

 Profile Answers by veerbahadur Questions by 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...

Answer Question  Select Best Answer

How to solve MySQL timeout issue?

arunmscit86

 Profile Answers by arunmscit86 Questions by 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

Answer Question  Select Best Answer

Which version of MySQL does not support stored procedure?

UncaAlby

 Profile Answers by UncaAlby Questions by UncaAlby

• Apr 18th, 2010

Stored procedures were introduced as a new feature in version 5.0.

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

jiten shahi

• Jun 16th, 2015

12

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

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

GaneshVilas

 Profile Answers by GaneshVilas Questions by 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...

sampra

 Profile Answers by sampra Questions by sampra

• Mar 10th, 2008

Ans of this question is given above

Answer Question  Select Best Answer