Most voted "dbeaver" questions
Use this tag when the question refers to some resource, information or problem related to Dbeaver, open-source database administration software.
Learn more…16 questions
Sort by count of
-
2
votes1
answer149
viewsWhat is the virtual data structure for in Dbeaver or Mysql?
Viewing a Mysql tables by Dbeaver, I noticed a tab called Virtual. In it it is possible to create Virtual Columns, Virtual Foreign Keys, Virtual Unique Keys and Referências Virtuais. What is the…
-
1
votes0
answers55
viewsProblems connecting with Ive via Dbeaver
I have a problem connecting to Hive by Dbeaver! Could not open client transport with JDBC Uri: jdbc:hive2://b4fa09-edhhdinsightshadoopgbdev-Hdi-dev-Gb.azurehdinsight.net:443/finance_hz:…
-
1
votes0
answers1256
viewsSQL Error [1064] [42000]: You have an error in your SQL syntax
When I add a new row to the table I can delete using the command: DELETE FROM ebdb.tb_categoria as tc WHERE id = 790; However, the lines that already exist cannot delete and returns the error: check…
-
1
votes1
answer118
viewsI’m having a stupid question, but it’s been a while and I don’t know how to solve it. (Mysql)
I was trying to create a table in mysql, simple, but it was giving an error. I decided to download an ide (Dbeaver), it kept giving error, so I downloaded Mysql Workbench and it does not generate…
-
0
votes1
answer279
views -
0
votes2
answers1353
viewsHow to change a table to enter a foreign key field?
Hello, I’m trying to set a field user_status in an existing name table cl_users using Mariadb in Dbeaver, the table in question will reference another already existing table with 4 status fields…
-
0
votes1
answer28
viewsCreate a select within another select to select the top ten values of each month
I’m trying to get the 10 best values of each month, I’ve looked for article here, but none helped me so far, I tried to do several subquery, but it was almost the same thing to take table 1 and…
-
0
votes0
answers256
viewsSQL Error [42601]: ERROR: syntax error on or near ":" Position: 683
I am trying to make a query with CONCAT, Seto the values I wish only that returns syntax error SQL Error [42601]: ERRO: erro de sintaxe em ou próximo a ":" Position: 683 select processador.cd_code,…
-
0
votes1
answer112
viewsSQL - Count Distinct
I am trying to make the relationship of two tables: one of Customers and one of Refills. I have already created reload tracks, total amount of transactions, type of transaction (Reload or…
-
0
votes1
answer682
viewsConnect Sqlserver Localhost to Dbeaver? Connection Error?
I want to connect the Sqlserver Localhost in Dbeaver Manager. But trying it gives the error: The TCP/IP connection to the host mssql., port 1433 has failed. Error: "Este host não é conhecido…
-
0
votes1
answer23
viewsINSERT using SEQUENCE . NEXTVAL with another SELECT
I can insert with this query in ORACLE INSERT INTO CONF_CODE (ID, OPTION_NAME, ISCHECKED) VALUES (SEQ_CONF_CODE.NEXTVAL, 'Producao', 0); But I need to fill this table CONF_CODE with a SELECT from…
-
-1
votes1
answer146
viewsError when changing the data type of a column by the interface
I try to change the type of data VARCHAR for another type of data by the system interface (I don’t want to change via SQL) but I can’t. I have the following table created: CREATE TABLE `Usuarios` (…
-
-1
votes1
answer881
viewsSet auto-increment in Dbeaver
After creating the column idpagamentoCielo as a primary key, I could not add property auto-increment to the column. How can I assign the property auto-increment to the column idpagamentoCielo? Note:…
-
-1
votes1
answer999
views'mysqldump.exe' not found in Dbeaver when exporting Mysql database
I use Dbeaver to manage my databases and need to export one of these databases, it happens that when trying to export this database, in tools/Dump Database, the following error is returned: Error…
-
-1
votes0
answers14
viewsHow to convert a decimal number into an integer in an SQL query
I am making a query in SQL in my database and is returning values in decimal. Is there a function to round the values or turn them into integers?
-
-1
votes2
answers20
viewsGrouping datatime in selects and summing the elements of the search per day to perform a comparison of the days of a given month
I’m using the type datatime and trying to perform a select that counts emissions day-to-day to mount a comparison chart of the days of a given month. However, when grouping the dates it is returning…