Questions tagged as 'mysql'

Tagged questions
1
answer

Can you install two different versions of a MySql database on the same computer?

Is it possible to install a MySql database version (5.7.20.0) on a PC that has already installed a wampserver server that comes by default with a Mysql database version (5.7.19)? I mean, can you install two different versions of a MySql database...
asked by 17.02.2018 / 00:26
1
answer

Can you install two different versions of a MySql database on the same computer?

Is it possible to install a MySql database version (5.7.20.0) on a PC that has already installed a wampserver server that comes by default with a Mysql database version (5.7.19)? I mean, can you install two different versions of a MySql database...
asked by 17.02.2018 / 00:26
0
answers

Mysql query select several months in different columns

I am trying to make a query in which all the clients of a year separate me and their faturation for each month in a column. I give example: Cliente Enero Febrero Marzo .... cliente1 300 350 800 cliente2 500...
asked by 04.03.2018 / 16:23
1
answer

how could you reuse this code to insert data into two different tables

I have two tables with the same fields and I'm using two equal methods for each insert in each table the only thing that changes is the name of the table. I would like to reuse the code just by changing the name of the table through a combobox....
asked by 20.02.2018 / 16:03
1
answer

I have a simple jsp I'm using java and I want to run a report by irreport from a link but I get an error

This is the servlet code, here is the report route: package Controlador; import Modelo.Conexion; import java.io.FileInputStream; import java.io.IOException; import java.io.OutputStream; import java.sql.SQLException; import java.util.HashMap;...
asked by 16.02.2018 / 12:49
0
answers

site PHP surveys dynamics

I am in a dilemma with this project, I am new to PHP and I am finishing a survey project only that I am very stuck in a modification that I want to make at the end of the project. I have my code where I create the survey. <section...
asked by 13.02.2018 / 20:59
1
answer

multiple query in nodejs

I want to show a post and the respective comments for this I have 2 tables in mysq l a " post " and the other " comments " Use mcv model view controller with nodejs and express . model.js getOne(id, cb) { conn.que...
asked by 13.02.2018 / 19:57
1
answer

Change column of a table to be AUTO_INCREMENT

I have a table with an Id and a name. I am trying to populate it in the following way: SET FOREIGN_KEY_CHECKS = 0; load data infile'C:LarutademiCSV.csv' into table t1 fields terminated by ';' lines terminated by '\n' IGNORE 1 lines (idt1, nomb...
asked by 18.02.2018 / 16:47
4
answers

Why does the Inspector Character ( ) appear in some data obtained from the Database?

I was dealing with the dilemma of converting the accents and special characters of my system. It happens that now some of the data obtained from the database that have tildes come out with this: . The strange thing is that there can be up...
asked by 31.03.2017 / 12:53
0
answers

How to disable items and enable them from a checklistbox according to MS Visual Basic conditions?

Cordial greeting colleagues, It turns out that I have a form with 2 checklistbox that are filled by means of a query to a database that I have, a checklistbox is for activities to be done and the other for workers (engineers). What I am trying t...
asked by 15.02.2018 / 14:56