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

Time:12-07

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?

CodePudding user response:

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

  • Related