Mention the various clauses used in MariaDB?

devquora
devquora

Posted On: Feb 22, 2018

 

It supports almost all types of clauses in RGDBM. For example:

    • MariaDB WHERE clause: For WHERE clause there is 4 statement depending on the selection or change of location. These four statements are INSERT, DELETE, SELECT, and UPDATE.

Syntax: SELECT field1, field2 FROM table_name1, table_name2 WHERE field LIKE conditions.

    • MariaDB Order by clause: In MariaDB, Order By clause is used to set the result in ascending or descending order.

Syntax: Select expressions from table_name Order By expression.

    • MariaDB Distinct clause: This clause is used to delete duplicate records from the table if any.

Syntax: Select Distinct from expressions.

    • MariaDB From clause: The FROM clause is used to fetch the data from the tables.

Syntax: Select columns FROM table;

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    MariaDB Interview Questions

    What do you understand by the MariaDB?

    MariaDB is developed by MySQL developers. It is a popular public source under GNU GPL which is related to database management technology...

    MariaDB Interview Questions

    Mention some characteristics of MariaDB?

    It has a lot of unique features that make it more useful and wonderful to work over it than MySQL. Some features are:..

    MariaDB Interview Questions

    Which command is used to delete the table in MariaDB’s database?

    The command DROP TABLE is used to delete the table in MariaDB’s database...