Questions tagged as 'mysql-workbench'

Tagged questions
0
answers

Add records using PA with variable

I do not have an id to enter a student who is from abroad with Carrera and I want to calculate it using a SELECT in my PA, but it tells me Error Code: 1136. Column count does not match value count at row 1 DELIMITER $ CREATE PROCEDURE agregarE...
asked by 19.08.2018 / 19:03
1
answer

registry update problems (ondelete on update)

Hello good afternoon to all, again consulting you the following: I have a table (citations) in which I need to store a series of IDs from other tables, including the idRegistration of a doctor, and the idRegistro of an official, the insert ok bu...
asked by 31.07.2018 / 19:44
0
answers

How to connect MySQL Workbench with C ++ code in Codeblock?

Install MySQL installer community with all its features, what I need to know is how to connect this database with the code in c ++?. I do not know if I need to download a library or if it already comes with the MySQL Connector C / C ++. Thank yo...
asked by 25.06.2018 / 00:26
1
answer

Error starting a project in laravel from localhost

I am developing a project in laravel in windows 10, but when trying to start it from localhost to be able to execute what I have done it does not leave me, it shows me a list of folders when I place the route and when entering the public folder...
asked by 15.06.2018 / 15:40
1
answer

error when inserting a double value in a database

I try to make an insert of a double value into a database (MySQL) and it shows me the error: java.sql.SQLException: '∞' is not valid numeric or approximate numeric value Connection conexion = AdminConexion.getInstancia().obtenerConexion();...
asked by 17.06.2018 / 03:34
1
answer

Problems importing MySQL database to WorkBench and PHPMyAdmin

I'm trying to import a database MySQL , both through WorkBench , and PHPMyAdmin , everything runs correctly, but it does not matter absolutely nothing. Imported in WorkBench Imported PHPMyAdmin    Messages in red...
asked by 01.06.2018 / 07:42
0
answers

execute a query for a month in a mysql workbench event

How can I execute this query for a month in an event? SELECT * FROM clientes WHERE MONTH(CoberturaFechaHasta) = 5 AND YEAR(CoberturaFechaHasta) = 2018 use myslq workbench     
asked by 01.06.2018 / 00:31
0
answers

Select conditioned MySQL WOrkbench

How about, I have the following table: These data I have entered for the moment: Where you can see that I have the subjects of the students, I need to take out the semester in which each student goes, because in this table he s...
asked by 30.05.2018 / 22:57
0
answers

mysql error installing a post pos

I'm trying to configure unicenta but I get the following error, the database is created in mysql but it's like I do not have access to help please. p> [     
asked by 29.05.2018 / 18:08
1
answer

Count cell values in a MYSQL WorkBench row

How about, I have a table in which I want to count the values that each cell of a line has to compare them with the values of the cells of the following lines. To finally take the higher value. This is an example of my table, in which the...
asked by 26.05.2018 / 05:41