DBeaver adds single character when auto-completing a table name (for MariaDB databases at least)

Question

DBeaver adds a character (the first letter of the table name) when auto completing table names, resulting in a query that looks like this:

select * from countries c;

As far as i can tell, it works, and has no impact on the query/results… can anyone enlighten me as to what it (the c) is?

Answer

“C” is an alias name of the “countries” table. Here is the reference: https://www.techonthenet.com/mariadb/alias.php

Accepted Answer

&#8220;C&#8221; is an alias name of the &#8220;countries&#8221; table. Here is the reference: https://www.techonthenet.com/mariadb/alias.php