Questions tagged as 'mysql-workbench'

Tagged questions
3
answers

Perform subquery based on a query

As the title indicates, I would like to query a Table "Table1" with the results obtained from another Table "Table2" CONSULTATION 1 To get the data from the Table1 SELECT id FROM box_12.esale_rc WHERE kind=30; which gives...
asked by 05.09.2018 / 19:06
1
answer

inner join repeated data (mysql)

Hello people, good afternoon, I have to take data from several tables (related to each other), it brings me the data I need, but it repeats, I have given it several times and I do not see where the fault lies, my query is so: SELECT c.idCita,...
asked by 16.08.2018 / 17:29
0
answers

Help to fix error 1054 Unknown column '...' in 'field list' in mysql workbench

I would like to ask your help to solve the error:    1054 Unknown column '...' in 'field list' The column that marks me as unknown Has the name Age and the mark as unknown even though it is in the table and written as is. This is the w...
asked by 12.06.2018 / 06:28
1
answer

Error # 1005 when exporting DB

Hello, I'm exporting a workbench database to phpmyadmin and I get this error # 1005: #1005 - No puedo crear tabla 'medico'.'citas' (Error: 150 "Foreign key constraint is incorrectly formed") CREATE TABLE IF NOT EXISTS 'Medico'.'citas'...
asked by 27.05.2018 / 17:52
0
answers

Error with MySQL Workbench

I ask for your help, today I went to open MySQL Workbench and when I connected to the Local instance I get the following error I'm using Xampp and the version of MySQL Workbench is 6.3, my operating system is Windows 7     
asked by 18.03.2018 / 01:44
0
answers

Problem with MySql WorkBench authentication

I was working on an app that connects to mysql server as a database but at some point I changed the password of the user root now when I try to see the data in my tables I get this 10:52 : 23: Error Code: 1820 You must reset your password usin...
asked by 05.10.2017 / 17:55
0
answers

Error Select NODEJS [closed]

Good morning, I am designing a REST API with NODEJS and when I insert this query: function getInvTop(req, res) { if (connection) { connection.query('SELECT recvTimeTs, CONVERT_TZ(recvTim...
asked by 29.09.2017 / 09:01
0
answers

Connect Mysql Workbench to mysql on ubuntu server 16.04 virtual machine

Good afternoon, I have a system on ubuntu server 16.04.02 LTS with a Mysql database, all VMware fusion virtual machine and NAT connection in which I can see the application and access through phpmyadmin. But I want to see the database wi...
asked by 09.06.2017 / 23:03
0
answers

SQL - Create a match matrix

Good afternoon, This question would be the next step to the question asked in " Doubt in complex grouping sql " and that a solution was already obtained. I summarize it and indicate the new question. I have a table with tickets like this,...
asked by 10.04.2017 / 16:16
1
answer

Union MySQL - Multitasking Procedure

Problem statement: Perform a procedure with the following two functionalities: • Alphabetically arranged list of waiters indicating their name, surname, ID and the person in charge. • Alphabetically arranged list of participating chefs...
asked by 12.02.2018 / 17:58