Skip to content
Advertisement

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

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?

Advertisement

Answer

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

4 People found this is helpful
Advertisement