Questions tagged as 'mysql'

Tagged questions
1
answer

# 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax [closed]

When writing the following procedure: delimiter // create function autor_nac(v_id int) returns NVARCHAR (50) begin declare Nombre_Nacionalidad NVARCHAR (50); set Nombre_Nacionalidad = (select CONCAT (nombre," ",nacionalidad) from autor where...
asked by 23.10.2018 / 04:15
1
answer

com.mysql.jdbc.exceptions.jdbc4.MYSQLSyntaxErrorException: Unknown column 'p.apaterno' in 'field list'

I have a question about that error, because although I check the code I can not find what it is referring to if I see it well written and the values are complete. I think the error may be appearing according to these parts totalregistros =...
asked by 24.06.2018 / 21:05
1
answer

How to insert data from a form into two related mysql tables?

As you can see in the following image, I need to insert data in those two related tables and from the same form, since in the form I ask for all the information of the client table and also several addresses of it. language: java. Database: m...
asked by 08.03.2018 / 00:54
3
answers

does not keep records in mysql database [closed]

I put my code to register but at the time of saving, I do not save anything in the database. This table is taken from the internet and works well, but I added two more fields, address and email, but when saving the data, does not save anything i...
asked by 06.04.2017 / 21:10
1
answer

How to control / restrict users from commenting

I have my end-of-course project (in Web Application Development), in which I allow to value and comment to registered users different small commerce stores. The thing is that how do I check that a user has commented or not to a trade? What I...
asked by 30.03.2016 / 11:42
1
answer

Update database data without updating page [closed]

I have a question: I want to update the data that is seen in my php web that is connected to a database and that what changes in the database is updated on the web without updating. I know it's done with "Ajax" but the only tutorials I found are...
asked by 30.06.2018 / 05:11
1
answer

IN clause and a string

Good morning. I am trying to make a query in MySQL given the following cases. Table codings id| nombre ------------------------ 1 | Correo electronico 2 | Videoconferencia 3 | Foro 4 | Otros Table tutorials id|tipo_tutoria ---------...
asked by 22.09.2017 / 13:43
1
answer

How to get the value of a variable in a php and use the variable in SQL statement in another php

I have an application (Android) where one does the Login and if the user and password is not in the Database you do not enter. Then here you go to fragment where I charge a recyclerview with names of people and the problem is that...
asked by 16.08.2017 / 22:46
1
answer

Mysql inform changes in bd to app java

Is there any way that when a table inserts a certain value example state: positive or negative "warn", and not having to make an inquiry from the application every x time making a query?     
asked by 16.08.2016 / 00:00
3
answers

Error in MySQL query

When I try to run, the next query does not throw anything at me. someone could advise me, thanks. SELECT * FROM bd.tabla WHERE interv='15seg' IF(interv='15seg' AND fecha_hora='2016-08-02 00:00:00' AND fecha_hora >= '2016-08-1...
asked by 18.08.2016 / 22:29