Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Failed Mysql workbench error 1215

I have to make a database of a hospital, I'm new to mysql and in this forum. I get the error when creating the foreing key. DROP DATABASE IF EXISTS 'hospital2'; CREATE DATABASE IF NOT EXISTS 'hospital2' /*!40100 DEFAULT CHARACTER SET utf8 COL...
asked by 30.04.2018 / 12:32
1
answer

DataModel must implement org.primefaces.model.SelectableDataModel when selection is enabled

hello good morning I'm working with the following xhtml      <h:form id="form_emisor_listado"> <p:growl id="messages" showDetail="true" /> <h:outputText id="txt_validador_controlador"> <...
asked by 21.04.2018 / 16:13
0
answers

{"Error parsing column 6 (Birthdate = 1 - UInt64)"} DAPPER

I'm using DAPPER with JSON and C # where I'm looking to update 2 tables of a database made in MYSQL: PERSON and MASTER ... Then I leave the fields of both objects in C #, the setting of the JSONs that I use to insert, the fields of the tables an...
asked by 15.04.2018 / 00:41
0
answers

trigger in tables with foreign keys?

Good morning classmates I have a question, I'm working on mysql and I'm creating a trigger audit of merchandise entry, what happens is that the table has a foreign key and the triggers that I have done have only been in tables without foreign ke...
asked by 03.04.2018 / 17:24
1
answer

Database and Java

I am trying to filter in a database from a combobox, for example if in the combobox you choose systems in the table you should show the data of only that area, I have this code: String lugar=String.valueOf(combo.getSelectedItem()); ResultSet c...
asked by 07.04.2018 / 21:56
1
answer

Basic query of Database

My query is about how to do an update to update several columns at the same time, work with java and mysql. stat.executeUpdate("Update producto set Prod_nombre= '"+Nom+"' , Prod_precio="+pre+" , Prod_existencia="+exis+" , Prove_id= " +prove...
asked by 08.03.2018 / 05:05
0
answers

Null value inserts 20 equal data

I have a question that is burning me the coconut, I'm with jsp and mysql Workbench, in one of the tables there is an attribute with an id with autoincremento, At the moment of entering the data from the form, I enter 20 repeated data, the Insert...
asked by 27.02.2018 / 04:02
3
answers

Add different values MySql

I have a table with three columns in which one of the columns has the client_id (columnA), in the second the orders made (columnB) and in the last one the order date (columnC) columnaA columnaB columnaC 1 26 2018-02-09...
asked by 28.02.2018 / 15:53
0
answers

Mysql query select several months in different columns

I am trying to make a query in which all the clients of a year separate me and their faturation for each month in a column. I give example: Cliente Enero Febrero Marzo .... cliente1 300 350 800 cliente2 500...
asked by 04.03.2018 / 17:23
0
answers

How to add columns with UNION?

I have two tables: Sales and history. In the sales table this is practically what the client owes, and in history what he has already paid for. I want to make a query that tells me which product is the most consumed. For this I have to...
asked by 09.02.2018 / 18:15