Computer Science, asked by Surajchaurasiya1509, 1 year ago

Changing year in MySQL date?

Answers

Answered by muskanc918

To change the year in MySQL date, you need to use DATE_FORMAT() function with UPDATE command. The syntax is as follows. Display all records from the table using select statement.

Previous Question

Next Question

Similar questions

Science, 8 months ago

difine-conductor and insulators ...

English, 8 months ago

L .Write C if the use of the underlined adjective is correct and I if it isincorrect. Write the correct adjective. 2.Every student is expected to be in the laboratory on time .... ................. in photo underlined word is there...

English, 8 months ago

Question # 72 Revisit Read the following passage and answer the given question. с O Criticizing the image chosen by the United States Postal Service for the new Flannery O'Connor stamp is beyond silly. A stamp is not a portrait to be hung on a museum wall; it is a product to be sold. Bright colors and welcoming faces are positive — especially for authors whom many people might not know. Would...

Computer Science, 1 year ago

Equivalent of SQL Server IDENTITY Column in MySQL?

Science, 1 year ago

explain the law of constant proportion with the help of example...

Social Sciences, 1 year ago

some persons contributed in improving the conditions of socially deprived children of India...

Physics, 1 year ago

b) two forces of magnitude 12N and 8N are acting at apoint.if the angle between the two forces is 60 determine the magnitude of the resultant force...

Social Sciences, 1 year ago

list five resources are used in classroom...