Most voted "mysql-workbench" questions
Use this tag when the question refers to some resource, information, or problem relating exclusively to the Mysql database management IDE, Mysql Workbench. For questions related to the Mysql database itself, there are already more appropriate tags. Mysql Workbench is a visual tool for database architecture development, which provides data modeling, SQL development, and administration tools.
Learn more…164 questions
Sort by count of
-
1
votes0
answers208
viewsQuery mysql still running after Lost Connection?
I am using Mysql Workbench to run a duplicate data removal query. When I run the query for a very large table, due to the 600sec limit of Workbench connection, it results in Lost Connection. Even…
-
1
votes1
answer364
viewsMYSQL - FK ERROR
Hi, could you help me? I am trying to add the FK in the employees table, only it is giving this error OBS I am creating the other tables before the employees 20:29:15 CREATE TABLE Funcionarios( id…
-
1
votes1
answer73
viewsMysql GROUP BY - PHP error
I have a query in Mysql that, in the command line and in Mysql Workbench, is bringing the correct values, but when running it in PHP, the function GROUP BY is grouping more than it should! Here is…
-
1
votes0
answers45
viewsNumber of Mysql lines
I wonder if it is possible to show the total number of rows in a table by giving a SELECT in Mysql Workbench (I’m using version 5.2.33), because it only shows the first 1000 rows of my table, so…
-
1
votes2
answers166
viewsCount IF Mysql Workbench
i have a table that has an ID field. ID 1234 1234 1235 1235 1235 1236 And I would like to get via query the following result: ID ID_Counter 1234 2 1234 2 1235 3 1235 3 1235 3 1236 1 Where in the…
-
1
votes1
answer1657
viewsProblem with id AUTO_INCREMENT in SQL
I created a table in Mysql Workbench with the following settings: CREATE TABLE teste ( id INT AUTO_INCREMENT, nome VARCHAR(50) NOT NULL, email VARCHAR(40) NOT NULL ); And when I try to insert data…
-
1
votes1
answer558
viewsHow to hide Undefined or validated variables after reloading the page?
I have 2 variables that receive the values of a input type Month, but when the code is first executed or when the page is loaded, the variables are Undefined and the code takes the date from the pc.…
-
1
votes1
answer964
viewsI lost my script to recover?
After a blue screen, I lost my work in Workbench, but keep the schema. It has to recover or I will have to do the work again?
-
1
votes1
answer65
viewsMysql Error - Stored Procedures
I am creating this process to run once a day, as I have no experience, I got an error in the code below: CREATE (definer omitido) PROCEDURE `MULTAOFF`() BEGIN set @multado = (select `CPFAluno` from…
-
1
votes1
answer2522
viewsCalculate average call time
Guys, I need to take the average attendance time and I have the following data: 00:12:35 00:05:10 00:01:42 00:08:12 00:01:01 {...} The question is, how can I do it? I searched for a way to do it…
-
1
votes2
answers728
viewsHow do I get Mysql to accept a 1.457.40 number?
I am developing an application that needs to automatically export excel sheets to the database. I’m using Mysql, but the spreadsheet data is not all well formatted the way the database accepts. I’ve…
-
1
votes2
answers101
viewsRelationship between tables
I have a certain table already created and populated: CREATE TABLE `formulario` ( `id` int(4) NOT NULL AUTO_INCREMENT, `nome` varbinary(50) DEFAULT NULL, `carteira` varchar(30) NOT NULL,…
-
1
votes2
answers3280
viewsConfigure Mysql Workbench on Docker
I want to set up my Workbench so that you can connect to the mysql that is running on my Docker server, but when I try to test the connection, I always get the following error: I created my Mysql…
-
1
votes1
answer416
viewsHow do I set up a Mysql database that is on my machine to be accessed on the web-hosted Moodle?
I have hired Uol Host hosting services, but I cannot change the database provided by them. I would like to know how to connect a database of my machine to the Moodle that is installed on the host.…
-
1
votes1
answer10554
viewsGenerate Mysql Workbench Script
Good afternoon. I use Mysql Workbench 6.3. I need to generate the script to create the local database to publish on the server. It is completely impossible to create everything again in the hand…
-
1
votes1
answer250
viewsQuery to return middle text from a field
I have an appointment that returns some class names/disciplines, but I wanted you to bring me only the names of disciplines. Below follows the query result with the default…
-
1
votes1
answer558
viewsSpecialization multiple foreign key
Hello, I am modeling a database and I came across the following problem: I have a table called team, which is a generalization to 4 specialized tables, where each will contain a different id, to…
-
1
votes1
answer425
viewsError executing PASSWORD IN MYSQL SERVER function ( ERROR 1064 SQL SYNTAX)
Error while executing function PASSWORD IN MYSQL SERVE I have the following query: SELECT * FROM users WHERE login = 'FABIO' AND pwd = PASSWORD('2018') LIMIT 0, 50000 You’re making that mistake:…
-
1
votes1
answer156
viewsBD creation with Mysql - Mariadb - Workbench
I’m trying to create a BD as Diagram done in Workbench but returns the error below: ERROR 1064 (42000) at line 45: You have an error in your SQL syntax; check the manual that corresponds to your…
-
1
votes2
answers245
viewsI cannot declare a cursor in Mysql
I have to do a survey of how cursors work to present in college, in all videos I see on youtube people declare this way : declare cur _nome cursor for select a.* from computador as a; but for some…
-
1
votes1
answer699
viewsmysql error: 1054. Unknown column'mover_almox.cod_promob 'in 'Where clause' even if I am not using this column in the parameters
I am trying to make an Insert in my database with the following command: UPDATE movimentacao_almox SET quantidade = 100, qtd_pendente = 2 WHERE id = 1113; but I get this mistake: Error Code: 1054.…
-
1
votes1
answer85
viewsWhy do space aliases only work with backticks?
I have a view where all its columns have been dubbed to make it more readable: +----------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra |…
-
1
votes0
answers59
viewsModeling relationship tables
Good evening, everyone! I’d like to ask you a question. Is it possible for multiple tables to reference a single foreign key from a table? Follow the example of the modeling where the table…
-
1
votes1
answer298
viewsHow to return the value of a query to the database in another javascript file?
I’m making an application where I need to query a database and return the value to another javascript file, only for some reason it’s not exporting anything to the other file when doing…
-
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…
-
1
votes1
answer128
viewsTriggers in Mysql with "Unknown column" errors in the key of a table where these triggers are stored
I don’t understand why you made such a mistake Unknown column in three triggers of the same table, as it always points to the keys and they in my view are correct. The error comes from the cd_sale…
-
1
votes0
answers18
viewsMysql Workbench is not importing the database, what to do?
I’m having trouble importing the bank I just saved into the workbench. Appears the message of finished, but does not transfer the bank, I have looked tutorials but no results, I have updated the…
-
1
votes0
answers20
viewsQuestions with JOIN [solved]
CREATE TABLE CIDADE( ID_CIDADE INT NOT NULL, NOME VARCHAR(50), CONSTRAINT PK_FORNECEDOR PRIMARY KEY (ID_CIDADE) ); CREATE TABLE FORNECEDOR( CNPJ CHAR(14) NOT NULL, RAZÃO_SOCIAL VARCHAR(40), ENDEREÇO…
-
0
votes1
answer12979
viewsError Code: 1406. Data Too long for column 'txtContability' at Row 1
In Mysql.. I am wanting to do UPDATE in a text field, the same has about 300 characters and does not allow to do it, informed that it is too long. I’ve tried changing the field type up to…
-
0
votes2
answers5590
viewsI cannot run Mysql Workbench 5.2 server
I am trying to connect to the Mysql Workbench 5.2 CE server to open a Ruby project. However, I cannot connect to the server (local). The following error appears: Can’t connect to MYSQL on…
-
0
votes1
answer788
viewsMysql Workbench - Create or Change an event
In this program we have the options to create within a schema: Tables Views Store Procedures Functions All in an interactive way, but I couldn’t find the option to create EVENTS, Does there exist…
mysql-workbenchasked 9 years, 3 months ago SneepS NinjA 7,691 -
0
votes1
answer118
viewsQuery with two summations for the same column
It is possible to make a query in which in the same query two sums are executed on the same column? Here’s what I got: Total sum of sales select month(emitido_date) as mes, ifnull(sum((det.preco *…
-
0
votes3
answers12463
viewsHow to select last Mysql table record with last or another command?
How to select last record from Mysql table with last or another command For example: select last registro from tabela where coluna = 23; I tried with this code but it didn’t work.…
mysql-workbenchasked 8 years, 2 months ago MFD 81 -
0
votes1
answer1026
viewsSelect with max(date), penultimate(date)
I have a chart with product code and date of sale. I would like to make a select by taking the product code, the date of the last sale and the date of the penultimate sale with group by code. It is…
-
0
votes1
answer1223
viewsTake bank dates , and "Highlight them" in a Jquery Calendar
I have a code with two dates that will mark something, such as a week event for example, one is the start date of the event and the other the end date of this event, to facilitate the user view I…
-
0
votes1
answer113
viewsError when creating a Trigger
I’m creating this Rigger DELIMITER // CREATE TRIGGER reposta3A AFTER INSERT ON utilizacao_veiculo FOR EACH ROW BEGIN SELECT emite_mensagem(); END// DELIMITER ; but when I execute the show triggers…
-
0
votes1
answer111
viewsWhat was the error in the last UPDATE use line in Mysql?
I developed a final project without error, done in Java, but still have only one error UPDATE in the last row of table creation clientes database in Mysql language. I am asking to update the…
-
0
votes1
answer770
viewsAccess database via Mysql Workbench
I cannot access a database from Mysql Workbench. The following message appears: However, through PHPMYADMIN, I can. How do I access via Mysql Workbench?…
-
0
votes0
answers443
viewsExport Mysql data to CSV file in UTF-8 format
I’m used to the tool Workbench to access data from my Mysql database, but when I try to export the returned data to a file *.CSV I am unable to export the same in the format UTF-8, but is exported…
-
0
votes1
answer376
viewsCheck initial and final date and insert text between them!
Good morning, I have a code "ready" in which the user must register an event that will later be shown in a calendar, well the first part is already ready but the second is giving me problems, I…
-
0
votes1
answer297
viewspsqlodbca.so: Cannot open shared object file: File or directory not found
I cannot migrate Postegresql database to mysql due to this error: psqlodbca.so: Cannot open shared object file: File or directory not found I am using Ubuntu 64 Postgresql 9x and Workbench 6.x, how…
-
0
votes1
answer2414
viewsIs it possible to change the theme or colors of the Workbench?
I’d like to leave the background black to dull the vision less. Thank you in advance!
-
0
votes1
answer101
viewsForeign key with more than 1 value
I’m working on the construction of my TCC and a problem has arisen. I have a schedule table, and this table needs to store some data, among them, the activities that will be spent during the year.…
-
0
votes0
answers58
viewsHow do I make two references of a table in other 2 tables?
Well, I have 3 tables tbl_users tbl_article tbl_profile I need tbl_usuarios to be related to tbl_articles and tbl_perfil. How could it be done? Table tbl_usuarios:…
-
0
votes1
answer292
viewsItem composition from the same SQL table
Well, I started studying Mysql recently and found a question that I couldn’t solve: An ITEM table has the columns (PK)cd_item, nm_item, ds_item, cd_tipo_item, the problem in this case is that an…
-
0
votes1
answer30
viewsDoubt Mysql bank
In this database and I’m not getting it done: I have it: value_id | entity_type_id | attribute_id | entity_id | value 600 | 2 | 22 | 40 | Gaga 601 | 2 | 20 | 40 | Tonha and I’d like to turn it into…
-
0
votes1
answer52
viewsHelp with database schema
I am developing an order control system, and I am finalizing, but now I came across a problem in the payment part scheme: I’m linking the id_pedido with the payments, however, when the request costs…
-
0
votes0
answers73
viewsComparison with 3 tables
create table Pessoa ( id int not null primary key auto_increment, nome varchar(150) not null, cidade varchar(100) not null, cpf char(14) not null unique, rg int not null unique, INDEX idx_nome(nome)…
-
0
votes0
answers24
viewsMysql workbrench
Does not continue, for 99%. How do I continue the installation ?…
-
0
votes0
answers71
viewsProblem saving month - Mysql Workbench
Good afternoon, I am doing a project for project management and I have in the registration form, two dates fields, when entering, when I consult the bank, the dates appear with the wrong month, all…