InterviewUp – Job Interview Questions and Answers – Search Results for mysql

March 21, 2010

Home

My Interview Questions

InterviewUp is actively seeking partnerships. Inquire at business@interviewup.com

Questions 1 - 10 of 59

Please Wait...

Please Wait...

Filters not found for the search result

See QuestionsSee Questions & Answers

How can we know the number of days between two given dates using MySQL?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

$date=10-12-2007;

$date1=14-07-2008;

$diff=Strtodate($date)-Strtodate($date1);

echo $diff;

Using mysql: "datediff($date, $date1)"

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

How can we know the number of days between two given dates using MySQL?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Select datediff('2008-09-07','2006-10-02');

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

How can we know the number of days between two given dates using MySQL?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Be the first one to answer the question Click here to answer

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

How can we know the number of days between two given dates using MySQL?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Be the first one to answer the question Click here to answer

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

How can we know the number of days between two given dates using MySQL?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: tikimama |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Be the first one to answer the question Click here to answer

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

What are the MySQL database files stored in system ?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: tikimama |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Data is stored in name.myd
Table structure is stored in name.frm
Index is stored in name.myi

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

How can we encrypt and decrypt a data presented in a table using MySQL?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: tikimama |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

You can use functions: AES_ENCRYPT() and AES_DECRYPT() like:
AES_ENCRYPT(str, key_str)
AES_DECRYPT(crypt_str, key_str)

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

In how many ways we can retrieve data in the result set of MYSQL using PHP?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: tikimama |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

mysql_fetch_array - Fetch a result row as an associative array, a numeric array, or both
mysql_fetch_assoc - Fetch a result row as an associative array

mysql_fetch_object - Fetch a result row as an object
mysql_fetch_row -- Get a result row as an enumerated array

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

What are the current versions of Apache, PHP, and MySQL?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: thunderd |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

PHP: PHP 5.2.5
MySQL: MySQL 5.1
Apache: Apache 2.1

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

What are the reasons for selecting LAMP (Linux, Apache, MySQL, Php) instead of combination of other software programs, servers and operating systems?

Add or view comments about this interview question

Share this interview question with your friend

|

Flag this interview question as inappropriate

Inappropriate

|

View all interview questions asked by this user

Asked By: thunderd |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

All of those are open source resource. Security of Linux is very more than windows. Apache is a better server that IIS both in functionality and security. Mysql is world most popular open source database. Php is more faster that asp or any other scripting language.

Create Date

:

Sunday, May 11, 2008

Tags

:

Asked At

:

None

Job Positions

:

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

Goto add your comment on the Question

Forgot Password?

Go to previous page

Prev 1 2 3 4 5 6 Next

Go to next page

InterviewUp is actively seeking partnerships. Inquire at business@interviewup.com

Print Questions

Print Questions & Answers

Most Popular Questions

User Statistics

Suggestions & Comments

InterviewUp Widget

Invite Friends

Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy
© InterviewUp 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License