Questions tagged as 'mysql-workbench'

Tagged questions
4
answers

NULL the duplicate values of a LEFT JOIN Msql query

I have 2 tables. The first returns the order number and the two-state times Pedido TiempoPreparar TiempoAsignar ------------------------------------------- P001 10 9 P002 20 5 P003...
asked by 03.05.2018 / 19:21
4
answers

Query in MYSQL DATETIME ()

I have a database in which the packages of some clients are stored and the date of creation of said package. I need to check out how many packages a client makes each day in a month. I've tried with SELECT distinct fecha_creacion FROM paque...
asked by 25.10.2017 / 11:31
1
answer

Differences between "identifying" and "non identifying relationship"

I started using the Workbench and was doing a database model, but those two relationships appear in the tables, what is the difference? "identifying": "non identifying relationship":     
asked by 05.06.2017 / 21:34
1
answer

MYSQL - Error 1148. The used command is not allowed with this MSQL Version

Trying to load data into a table gives me this error.    Error Code 1148: The used command is not allowed with this MySQL version The function I use is:    load local data infile 'C: \ Users \ xSyn \ File.csv' I've been searching t...
asked by 30.09.2018 / 20:59
1
answer

MySQL Error Code 1215: Can not add foreign key constraint

I'm trying to create a database with this script in MySQL But I get error 1215 that can not add the FK constraint I've reviewed but I can not find the problem. Could you help me see the problem? CREATE DATABASE IF NOT EXISTS mybase; use mybas...
asked by 23.03.2018 / 01:18
3
answers

MySQL Workbench change name to Schema

I'm trying to export / migrate a DB from one server to another, I have the 2 connections in Workbench and the problem is that the bases have different names, I want to take the base to export let's call it test and I want to export it t...
asked by 24.03.2017 / 14:28
2
answers

MySQL query How many children does Berenice have?

This is the Database and what I want to know is how to ask how many children Berenice has create database padres_hijos; use padres_hijos; create table padres(padre_id varchar (20) primary key, nombres varchar(30), apellidos varchar (30))eng...
asked by 14.10.2018 / 05:30
2
answers

Where are the .sql files stored in windows?

I installed MySQL in windows 10 64 bits and I am testing the example databases, download one that they use in an example that I follow, it is called northwind, I do not have it and I download it from the internet, I want to include it so that it...
asked by 15.09.2018 / 21:46
1
answer

problems with the primary key

good morning classmates I have an issue, what happens is that I am doing a database for my project in MySQL but I have a problem, in the requested tables and arealogistica in this area I have a single worker or person in charge of this area a...
asked by 30.03.2018 / 23:10
2
answers

How to update several fields of a table based on a subquery in MySQL?

What I basically want to do is, update precio_preparación of my table platillo , based on the total thrown by my subquery, which is stored in a temporary table. Practically what my temporary table shows is the following:...
asked by 06.03.2018 / 00:37