Answer / ismail

SELECT CURDATE(),SELECT CURRENT_DATE(),SELECT CURTIME(),
SELECT CURRENT_TIME(),SELECT now().

Answer / rajan vardawaj

SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME();
SELECT CURRENT_TIME();

Answer / vikas d.k. gupta

To get the Current Date:-
1. SELECT CURDATE();
2. SELECT CURRENT_DATE();
To get the Current Time:-
1. SELECT CURTIME();
2. SELECT CURRENT_TIME();
To get both at the same time:-
1. SELECT NOW();
2. SELECT SYSDATE();

How to get a version of mysql?

0 Answers  

---

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

0 Answers  

---

What are the applications required to support mysql?

0 Answers  

---

Explain multi-version concurrency control in MySQL?

2 Answers  

---

What is the difference between primary and unique key

5 Answers   CSC,

---

How to check if a record exists in a mysql database php?

0 Answers  

---

What is general log in mysql?

0 Answers  

---

Can you tell the difference between ereg_replace() and eregi_replace()?

0 Answers  

---

What is ddl, dml, and dcl?

0 Answers  

---

How to get the number of rows selected or affected by a sql statement?

0 Answers  

---

What is auto increment in mysql?

0 Answers  

---

What is the difference between the primary and unique key in mysql?

0 Answers  

---