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 many columns can you create for an index?

0 Answers  

---

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

0 Answers  

---

can you tell what are the different set operations available in mysql? : Mysql dba

0 Answers  

---

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

0 Answers  

---

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

0 Answers  

---

What is meant by sharding?

0 Answers  

---

What are the ways in which you can retrieve data in the result set of mysql using php?

0 Answers  

---

How do I find mysql version in mysql workbench?

0 Answers  

---

How many rows can mysql handle?

0 Answers  

---

How do you change a password for an existing user via mysqladmin?

2 Answers  

---

What are triggers in mysql?

0 Answers  

---

What is the return type of mysqli_query?

0 Answers  

---