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

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