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
votes2
answers217
viewsMigrate data from one table column to another table column
I work in a company where we implement a new functionality in our system, but previously a field of our table was bug_passos varchar(500), now with the new implementation, we create a new table with…
-
-1
votes1
answer164
viewsError 'System.Collections.Generic.Keynotfoundexception' occurred in mscorlib.dll
I created an application in visual studio 2017, I formatted the pc and installed the 2019 version and since then no application I try to connect to the database works. always appears this error: An…
c# mysql visual-studio-2015 mysql-workbench visual-studio-2017asked 4 years, 9 months ago Guilherme Costa 1 -
-1
votes1
answer79
viewsReturn of several CASE in a single line
How do I convert that return: In a single line: 548721 125 2 20836 20836 77821 77821 9999******9999 0 0 MASTERCARD 200 Cartao de Credito a Vista My query: SELECT CASE data_id WHEN 17 THEN data_value…
-
-1
votes1
answer39
viewsHow to perform this query correctly ? [Mysql]
In front of this database: Employee(employee, employee name, street, city) Works(employee, code company, salary) Company(code company, company name, city) Manager(employee,…
-
-1
votes1
answer27
viewsDoubt with relation of tables - Modeling
Next guys, to with 3 tables here, I’m in doubt how to relate them. I am studying relationship tables here... This project is a stock system, and has no intention, except to practice and study! My…
-
-1
votes0
answers11
viewsHow to activate line breaking in Workbench word wrap .?
I want to enter the data c INSERT INTO `cursos` VALUES (1,'HTML5','Curso de HTML5',40,37,2014),(2,'Algoritmos','Lógica de Programação',20,15,2014),(3,'Photoshop5','Dicas de Photoshop…
-
-2
votes1
answer1460
viewsGrab image from database
wanted to know how I could recover an image from the database, used the php7, the image is recorded in the database in type BLOB, I searched on the internet and were very old examples and none…
-
-2
votes1
answer214
viewsName of the MYSQL Server
I am following a video lesson in which the instructor puts the name of your server in ODBC as it appears in mysql, but as my version (Mysql Workbench 8.0.15) is different and does not include the…
-
-2
votes1
answer38
viewsView structure of a WORKBENCH view
Hello , I created a view on Workbench, but I need to know how to see her structure. like, knowing the selects she’s doing there’s some way ?…
mysql-workbenchasked 4 years, 10 months ago Danilo Vasconcelos 83 -
-2
votes2
answers37
viewsRoolback in Mysql 5.7 Workbench does not work! Help
Hello guys okay ? I’m new to Mysql, I would like to ask a question. I am using a command that is not DML. but when I give roolback, the error occurs below. Is it some configuration permission in…
-
-3
votes1
answer725
viewsHow to create a python code and connect it to Mysql
Eae Galera, I’m learning the database language, but I still don’t know everything to the letter so I came here to ask you for help to know how I can do this. I know there is sqlite3 in python but I…
-
-3
votes1
answer1329
viewsError Code: 1064. MYSQL WORKBENCH
Hello I’m trying to create the following table: CREATE TABLE produtos( id integer primary key auto_increment unique , nome varchar(255) unique, descricao varchar(255), preco varchar(10,2) , validade…
-
-3
votes0
answers15
viewsBreaking my sql formatting when creating artifact
I just hate when my sql Workbench breaks my query formatting when I create a view/Procedure. Shuffles everything and have to organize whenever you need to stir the query. There is an option in the…
mysql-workbenchasked 3 years, 3 months ago Leandro 814 -
-4
votes1
answer21
viewsSELECT TWO COLUMNS THAT HAVE THE SAME ID IN DIFFERENT TABLES AND MAKE COMPARISONS
Good night Devs, I need to take each actor_id and film_id and check which total of movies(filme_id) has linked to actor_id and this I got : SELECT actor_id, COUNT(film_id) from film_actor group by…