Questions tagged as 'mysql'

1
answer

Update statment mysql php row in database

Please could you help me what is the error in the following php code to update a record where the record mail is taken in the database ... when executing it I jump to the automatic error "noUpdate". I appreciate your help so that the sentence is...
asked by 01.06.2018 / 05:58
0
answers

Doubt with query in MYSQL

I will try to explain my doubt in a simple way since it is something complex. I have a table called formacion with the fields ID , Tipo , Categoría and SubCategoria A table called alumnos with the fi...
asked by 10.06.2018 / 19:28
1
answer

Close session in hibernate when returning an ArrayList

I have a problem wanting to close a session in hibernate. I enclose the code that works for me public ArrayList<Empresa> getEmpresas() { Session session = null; SessionFactory sesion = HibernateUtil.getSessionFactory(); se...
asked by 21.06.2018 / 07:15
1
answer

Take data from the array to independent variables. MYSQL

I have a query SQL that brings the data that I want perfectly. When doing a print_r it shows it to me like this: Array ( [0] => 6 [idFormacion] => 6 ) Array ( [0] => 9 [idFormacion] => 9 ) Array ( [0] => 12...
asked by 10.06.2018 / 20:25
3
answers

Help with loading SELECT table and INSERT data to display in a PHP MYSQL table!

I am new in these areas I found your page on the WEB and I want a little hand for this system that I am doing, since my expertise with programming and web development is really basic and I am still in the process of perfecting myself and learnin...
asked by 19.06.2018 / 23:15
1
answer

Doubt rollback in PHP / MySQL

I am starting to use TRANSACTIONS in PHP / MySQL but I am observing the following situation: In my tests I have noticed that rollback is not necessary although I have read that they are always put to return the data to its original stat...
asked by 20.06.2018 / 08:02
2
answers

Create "on the fly" records of an SQL query in the interval between 2 dates

I do not know if it is possible, I pose the problem. I want to create records from a SQL query in date range One record per day. From the start date to the end date. SQL query: SELECT TRFEC1 as fecha_inicio ,TRFEC2 as fe...
asked by 31.05.2018 / 21:12
1
answer

Error: 150 "Foreign key constraint is incorrectly formed

I had an error in creating a FOREIGN KEY. I'd like to know what I'm doing wrong. Well, I've been trying for some time to find out what the error is. Thank you Annex code Sql: CREATE DATABASE freatico; USE freatico; CREATE TABLE medicion (...
asked by 18.05.2018 / 22:20
0
answers

Help in relational model for a Time Tracking system

I proceed to explain what the project that I just started is about to explain my concern. It is a time tracking system but at its most basic level, nothing compared to the large systems that already exist (primaERP, Harvest etc) in which the...
asked by 20.05.2018 / 05:25
0
answers

Who can help me build this table in html?

I want to show a table in html of a query of the database of three tables that are related, the tables are structured as follows: Restaurant | Platos | Precios ----------------------------------------- id | id | id nombre...
asked by 21.05.2018 / 05:19