MariaDB Question:
Download Job Interview Questions and Answers PDF
Tell us how can you change or update the already inserted records of a MariaDB table?
Answer:
UPDATE statement is used to change, update or modify the existing records of a MariaDB table. It can be used with WHERE, OBDER BY and LIMIT clauses.
Syntax:
UPDATE table_name SET field=new_value, field2=new_value2,...
[WHERE ...]
Syntax:
UPDATE table_name SET field=new_value, field2=new_value2,...
[WHERE ...]
Download MariaDB Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain me why Does Mariadb 10.2 Use Innodb Instead Of Xtradb? | Do you know what is the use of TRUNCATE statement? How is it different from DELETE statement? |