Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Help in SQL statement to update

I was creating a procedure but I came across an error in doing it. create procedure actualizar (in id int, in nom varchar(45), in corr varchar(45)) begin update dpersona set nombre=nom, correo=corr where idpersona=id; end In the part of 'i...
asked by 07.05.2017 / 21:11
1
answer

Problems in mysql workbench "Error Code: 1005. (errno: 150" Foreign key constraint is incorrectly formed ")"

I have this problem in a database for a final school project    Error Code: 1005. Can not create table gymn-os . maestros (errno: 150 "Foreign key constraint is incorrectly formed") Here I leave the script of the database I h...
asked by 25.08.2017 / 23:22
1
answer

How to create relationships between SQL tables

There are different ways to create a relationship in the tables, which is to make use of the Foreign Key (FK), I have these understood ways of doing it: 1) In the case of the creation of FK by SQL code ... to create a serious FK: FOREI...
asked by 08.07.2017 / 06:37
0
answers

MySQL Workbench quits unexpectedly after starting

Installe MySQL Workbench 6.3.10 in openSUSE LEAP 15 . When I want to open this application it tries to start but closes immediately and this message appears after running in "Konsole". sudo mysql-workbench    Found /usr/lib64/libprojectM-q...
asked by 19.12.2018 / 22:06
0
answers

Remote access in shared server

I am using a shared server, for which I planned to access the files on my website (Via WinSCP) and its database (Via Mysql-Workbench). In Workbench I get the access error:    Can not connect to MySQL server on 's985.tmd.cloud' (10061) In...
asked by 17.08.2018 / 17:37
1
answer

MySQL query does not show data [closed]

Someone to help me, I'm doing a query in MySQL with C #, but it does not show me any data, this is the query I'm doing: public DataTable Espera(String Programa, String FI, String FF) { DataTable dt = new DataTable(); String...
asked by 02.10.2018 / 00:04
2
answers

Select records based on two different values for the same field

I have this table and I want you to select the lots as long as they have a start and end, not just one of the two. I tried with a and but I was not selected at all since I think that with that sentence I waited for a single field to me...
asked by 17.04.2018 / 20:46
2
answers

How do I change the constraints of referential integrity once the tables are created?

I have a table called usuario . The code you use to create it is the following: CREATE TABLE IF NOT EXISTS 'cumplimiento'.'usuario' ( 'idusuario' VARCHAR(10) NOT NULL, 'pass' VARCHAR(100) NOT NULL, 'rol' INT NOT NULL, 'activo' TI...
asked by 15.08.2017 / 17:34
1
answer

HELP! I'm trying to update a table and send error

Try to update the score field in my dashboard but send me an error:    code: 1093 You can not specify target table 'partitioned' for update in   FROM clause I leave my sentence use noble; update dpartida set score=1 where id...
asked by 22.05.2017 / 00:47
1
answer

I can not put a data with null value in a null table mysql workbench

I have a problem, I have a table with some fields not null, and a couple of fields that can have null values, the problem is when I want to upload data, only the rows that have all the values, and the rows that They have empty fields, they do no...
asked by 20.11.2018 / 20:48