How to use backticks in SQL statements?

Backticks can be used in MySQL. To create a table, we can place table_name within backticks.

Example of Backtick in MySQL.

The CREATE command is used to create a table. Here, we use backticks to add the table name.

mysql>　create　table　`backtickSymbol`
　　　->　(
　　　->　uniId　int
　　　->　);

Records are inserted with the help of the INSERT command.

mysql>　insert　into　`backtickSymbol`　values(1);
mysql>　insert　into　`backtickSymbol`　values(2);
mysql>　insert　into　`backtickSymbol`　values(3);
mysql>　　insert　into　`backtickSymbol`　values(4);

Display all records.

mysql>　select　*from　`backtickSymbol`;

The following is the output that displays all records.

+-------+
|　uniId　|
+-------+
|　　　　　1　|
|　　　　　2　|
|　　　　　3　|
|　　　　　4　|
+-------+