Questions tagged as 'mysql'

1
answer

how to visualize a subquery while viewing the web without apliacr submit [closed]

I explain if when creating this website, I select a table: Table sr_productos id nombre_esp 1 NombreA 2 NombreB 3 NombreC 4 NombreD the id 1 who in the textarea part marks the result of immediate in the variable: $id_producto2 T...
asked by 16.01.2017 / 01:32
1
answer

How to avoid duplicate data in a combobox?

Good day, I have an error with my project, it turns out that in my combobox I have registered 4 products, but when I change the selection and return to it, these products are duplicated, how can I correct that? I'm working on windows form linked...
asked by 25.04.2017 / 15:25
1
answer

Import an excel document to mysql using php

I'm looking at how to upload a CSV file and xlsx to a MySQL database from PHP strong>. I've already researched Google and I've taken the examples they give but they do not work for me. What happens is that I'm in charge of the form...
asked by 11.01.2017 / 19:14
1
answer

Is the syntax of the database query OK?

I have this query to the DB, but I do not know if the syntax is ok $this->db->select('rut_usu, fecha_ini, fecha_ter'); $this->db->from('hoario'); $this->db->where('rut_usu=',$rut_usu,'AND fecha_ini=',$fecha_ini,'A...
asked by 21.09.2017 / 19:07
1
answer

MySQL query of 2 tables [duplicated]

I have the client table: id nombre idCiudad The city table: id nombre How can I make a selection so that it shows me everything in the client table but instead of taking me out the idCiudad, show me the name of that city directly?...
asked by 30.04.2017 / 19:34
1
answer

MySql connection linux server from app in windows

I do not know if this query is in the target range of the page. Has anyone ever encountered having to connect an application from visual studio to a DB MySql hosted on a linux server? Try connecting to a connection string by changing t...
asked by 18.12.2018 / 13:23
2
answers

How do I show the records of a table in MySQL?

DROP DATABASE escuela; CREATE DATABASE escuela; USE escuela; CREATE TABLE alumnos(NO_LISTA int not null,NO_CONTROL VARCHAR(30) not null,NO_ALUMNO VARCHAR(50)); CREATE TABLE alumnos301(NO_LISTA int not null,NO_CONTROL VARCHAR(30) not null...
asked by 01.12.2018 / 22:57
2
answers

Convert javascript variable to PHP

My problem is that I have a button which sends a parameter to a javascript function. When I receive it in this function, I want to execute an sql query where the where includes this received variable (this to generate a pdf jspdf and not having...
asked by 07.09.2018 / 13:22
1
answer

How to repair tables "in use" on phpmyadmin?

A table appears in use and does not allow access to this     
asked by 15.09.2018 / 20:44
3
answers

JPA Loading a list in datatable [closed]

Good morning, In one method I am bringing two lists with the work order parameter ( idOrdentrabajo ) the first list loads me correctly in a datatable but the second list gives me the following error.    Information: ERROR: Query argu...
asked by 12.01.2017 / 12:36