What are the difference between now and current_date in mysql?
NOW
NOW() give you the current date time in the format 'YYYY-MM_DD HH:MM: SS'
CURRENT
CURRENT_DATE() will only give you the current date in format "YYYY-MM_DD"
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a mysql server?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
what is constraints? Also explain the different types of constraints?
How to create table with same structure of student table in mysql?
Is mysql relational database?
Is mongodb faster than mysql?
How do I install the latest mysql on ubuntu?
Does insert statement lock the table?
How to get the number of rows selected or affected by a sql statement?
What is longblob in mysql?
How can you retrieve a particular number of records from a table?
What is blob and text in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)