Most voted "alias" questions
Generally, alias is a nickname used to reference something.
Learn more…13 questions
Sort by count of
-
5
votes2
answers5974
viewsHow to use ALIASES in Oracle correctly?
I’m trying to select several columns from a single table, and to facilitate the process of viewing the data and making it easier to separate the columns, I decided to use aliases. But the problem is…
-
3
votes2
answers685
viewsFix invalid command dynamically, no alias required
I’m using GNU bash version 4.3.46. One problem I have when typing commands, is that I often end up forgetting a space between the command and its parameters. Examples: cd.. gitlog When the right…
-
2
votes1
answer121
viewsCreate an ALIAS for a . /configure File?
I cloned the Github repository, and to execute the command I always need to type, . /directory name/vv I imagine that this "file" is of the Linux CONFIGURE type, correct? I wonder how I create an…
-
2
votes1
answer251
viewsFunctions that are nicknames (aliases) should be used or not?
I remember that a while ago, when I was starting programming with PHP, I saw in some tutorials a recommendation, warning that it was to avoid using some functions that are nicknamed for others. I…
-
2
votes1
answer123
viewsAlias created in shell-script does not work
I’m trying to create a alias using a shell-script, but at the end of the execution the alias disappears. #!/bin/sh echo "Configurando ambiente..."; mkdir -p ~/.dna alias teste="node…
-
2
votes2
answers562
viewsMysql alias in all Columns
Good afternoon Galera. I have a little problem to join some tables by INNER JOIN, and because the columns name are equal, I imagine that the ALIAS can save me by changing the columns name pro front.…
-
1
votes2
answers71
viewsProblems in an SQL query
Hello, in the following query, an error is shown in the: select fto.id_taxon, fto.cd_sexo as fto_cd_sexo, fto.cd_idade as fto_idade, x.ftv_cd_sexo, x.ftv_cd_idade, x.id_fv from tb_foto_ocorrencia…
-
1
votes1
answer44
viewsThere is performance loss by using alias on oracle
In oracle there is some performance loss, even small, when using alias for tables? Examples: select user.name from user; and select u.name from user u;…
-
1
votes1
answer48
viewsQuery sql with ALIAS equal to column name with unexpected return
That consultation SELECT DATE_FORMAT(data,'%d/%m/%Y') AS ALIASdata FROM departamentos ORDER BY data DESC me returns the dates in the order I want 18/05/2020 17/04/2019 17/05/2018 17/03/2018…
-
0
votes0
answers96
viewsMake two or more Select with Aliases in the query to generate a separate array
I have a single column table with all the words in English. I want to do a double or triple Select and recover in each query all words with 'A' in alias Palavrascoma, and all with 'B' in Alias…
-
0
votes1
answer524
viewsHow to save a custom Enum name in the database?
I have an Enum Type which has a JURIDICAL person and a PHYSICAL person. I created a custom name (Legal) and (Physical). I’m getting to appear on the screen the custom name, but in the database is…
-
0
votes0
answers13
viewsIs it possible to reference an alias in Mysql and use its field value?
I have the following situation: An electronic point in mysql and working on a query that makes several calculations with dates and times. select nome_colaborador, date_format(data_registro, "%d %M…
-
-3
votes1
answer99
viewsDirectory / Alias with domain
Hello, I have a domain http://www.~domain.com.br/new I want to make sure that when I walk into http://www.~domain.com.br redirect to/new and do not appear in the url that is new, there is something…