Questions tagged as 'mysql'

Tagged questions
1
answer

How to make the union of tables in the database

Try to join the tables but you can not here the code of the sentence $consulta = "SELECT * FROM usuario AS u, materiales AS m WHERE "; $resultado = $conexion->query($consulta) OR DIE("Error al Ejecutar Consulta de Usuario y Materiales".my...
asked by 28.05.2017 / 20:16
1
answer

Error saving EF ASP.NET image

Currently I have the following structure in my model for an image field of my bd [Table("especialidad")] public class clsEspecialidad { private int iId_Especialidad; [Key] [Column("id_especialidad")] [Display(Name = "Id Espe...
asked by 11.05.2017 / 19:18
1
answer

Detect duplicate records in MySQL

I want to find records that are exactly the same in all their fields and show them. I have the following table: I apply the following query: SELECT * FROM control WHERE (no IN(SELECT no FROM control GROUP...
asked by 04.05.2017 / 16:09
2
answers

Redirect page by clicking on image

I am trying to create a web page and I am encountering some problem. Through classes in php I've shown an image and a text on the main page, now I need to click on the photo to take me to another page where I can show the information but I...
asked by 04.05.2017 / 10:04
0
answers

Why does hibernate create the id column when I specify another primary key?

I'm working on OpenXava , a framework based on Java , and when using Hibernate I create a column called id in database ( MySql ), even if specific in the class that the key would be is called login . I put the cod...
asked by 04.05.2017 / 13:41
1
answer

query inserts me a single value Mysql - PHP [closed]

hi people I have a problem, with this query: INSERT INTO resultado(idpartido) SELECT idpartido FROM partido where idpartido not in (SELECT idpartido FROM resultado) The problem is that on the PHP side when I run it, it inserts only 1 row...
asked by 04.05.2017 / 13:05
0
answers

Error in mail server Postfix- Dovecot

I have this error in mail.log :    corpocar postfix / trivial-rewrite [2324]: warning: do not list domain   corpocar.com in BOTH mydestination and virtual_mailbox_domains But delete my domain of mydestination , I pulled localhost,...
asked by 17.05.2017 / 20:31
2
answers

Problems when extracting several jsons with queries in a nodejs module

I have a module in a route that needs to return a json with the content of several queries made in the same module and some of these queries are made with data extracted from the first queries, my code is similar to the following, but the proble...
asked by 17.05.2017 / 21:57
1
answer

Help, I need to insert a value that comes from a putextra, adroid studio and mysql

// THIS IS MY ACTIVITY FROM INSERTING USER The value is an extra put, loguser, it shows me the value on the screen but it does not register it in the database. protected void onCreate(Bundle savedInstanceState) { super.onCreate(sav...
asked by 25.05.2017 / 21:47
0
answers

how to load an xls file and update the records in the database with php

hi community I am developing an information system where you have an inventory module the idea is to download the inventory in xlsx format I have the code that I downloaded the file but in xls format but I want to format xlsx This is the c...
asked by 04.05.2017 / 16:38