Questions tagged as 'mysql-workbench'

Tagged questions
2
answers

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' when loading sql

Version: Server version: 10.1.32-MariaDB I have trouble setting a password in mysql o mariadb use xampp 5.6 I install xampp I enter the console and with mysql -u root log me in. Following different examples that I...
asked by 04.08.2018 / 16:09
1
answer

group result of statement mysql-workbench

I have this sentence. select nombrem,idparcial,calificacion from calificacion inner join parcial on parcial.idparcial=calificacion.fkparcial inner join materia on materia.idmateria=calificacion.fkmateria; and it gives me this result. nomb...
asked by 31.07.2018 / 03:45
2
answers

Mysql Select Multiple query

How about, I have the following table: What I want to do is a table like the following: Where I show the number of students per semester in each career, in my table History, there are more than one student with the same id beca...
asked by 30.05.2018 / 02:44
2
answers

foreign wrongly entered

I have been with this error for hours: Error Code: 1005. Can not create table prueba . montaje (errno: 150 "Foreign key constraint is incorrectly formed") Can someone tell me what I have wrong with my code? CREATE TABLE Mo...
asked by 14.10.2018 / 04:01
1
answer

CREATE SCHEMA or DATABASE has a difference? and placing the CONSTRAINT before an FK is necessary?

I have those doubts in SQL .. It is a language that is not so strict and runs despite the different ways of writing it .. What exactly is the difference between CREATE SCHEMA and CREATE DATEBASE when I started to see the code generated by Workbe...
asked by 24.05.2017 / 01:05
1
answer

I do not understand why I get this error 1136?

   Operation failed: There was an error while applying the SQL script to the database. Executing: INSERT INTO 'bdaeropuerto'.'tb_hangars' ('Clave', 'Aeropuerto', 'Capacidad', 'Tipo', 'Aerolinea', 'Estatus', 'Aeropuertos_Id', 'Avione...
asked by 08.04.2017 / 21:17
1
answer

When joining three mysql tables, one record appears duplicated

As you can see, the problem is that the genres appear repeated, although the number of times that is repeated is correct Note: I already solved the problem, the group by was the one that was interfering SELECT serie_db.nombre,rat...
asked by 08.03.2017 / 16:59
1
answer

How can I solve this problem in a procedure stored in MYSQL?

Greetings to the community I have this error in the creation of this procedure stored in MYSQL DELIMITER $$ CREATE PROCEDURE insertarnuevo15( IN Vnumfact BIGINT(20), IN Vserfact BIGINT(20) ) BEGIN DECLARE Vnumfact BIGINT(20); SET V...
asked by 11.10.2018 / 04:19
2
answers

stored procedure does not return response [mysql]

Hello all good morning, I have to do a search in a form of c #, for this I have a procedure stored in MYSQL that will show the results of a certain word entered in a textbox, the issue is that the sp does not return any result, the procedure cod...
asked by 14.08.2018 / 17:27
1
answer

Drop table in a MySQL trigger

I would like to know if there is a possibility of having the sentence "DROP TABLE TABLATEMPORAL" using MySQL inside a trigger, since when trying to save the trigger with this sentence I get the following error: "There was an error while apply...
asked by 05.09.2018 / 07:07