date funciton
Answers were Sorted based on User's Feedback
Answer / sudhanshu_kmr
use anyone ....
select curdate();
select current_date();
select date(now());
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / john
select curdate();
select current_date();
select date(now());
Is This Answer Correct ? | 3 Yes | 0 No |
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
Is sql and mysql same?
List some mysql advantages and disadvantages?
Explain advantages of MyISAM over InnoDB?
How do I run mysql from command line?
How do I delete a table in mysql workbench?
What is mysql root?
What is an index? How can an index be declared in mysql?
Can we rollback truncate in mysql?
What are the types of database engines available in mysql?
How to enter Characters as HEX Numbers?
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