date funciton

Answers were Sorted based on User's Feedback



date funciton ..

Answer / sudhanshu_kmr

use anyone ....

select curdate();

select current_date();

select date(now());

Is This Answer Correct ?    5 Yes 1 No

date funciton ..

Answer / john

select curdate();

select current_date();

select date(now());

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More MySQL Interview Questions

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

0 Answers  


Is sql and mysql same?

0 Answers  


List some mysql advantages and disadvantages?

0 Answers  


Explain advantages of MyISAM over InnoDB?

1 Answers  


How do I run mysql from command line?

0 Answers  






How do I delete a table in mysql workbench?

0 Answers  


What is mysql root?

0 Answers  


What is an index? How can an index be declared in mysql?

0 Answers  


Can we rollback truncate in mysql?

0 Answers  


What are the types of database engines available in mysql?

0 Answers  


How to enter Characters as HEX Numbers?

0 Answers  


The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  


Categories