Questions tagged as 'mysql'

Tagged questions
2
answers

Existence of the Missing Index in MySQL Does it exist?

I have been working a bit with MySQL and SQL Server, and I have a question: si el script "Missing Index" existe en MySQL In SQL Server I know that it shows the missing indexes of each table in a database, and for that I would like to k...
asked by 02.06.2017 / 18:53
1
answer

Failed to query javaFx through sql statements

Well, I have the problem that I want to get the records of a simple select * from table, but it tells me that it does not get any record The query code ConexionBD("eduware", "root", "", "3306"); Conexion(); this.cone...
asked by 08.10.2016 / 21:59
2
answers

How to convert an image to an array of bytes in java?

I'm trying to convert an image to an array of bytes in java to save it in a database, I used several methods to perform the conversion, and you could say that if it does, but it always returns a small part, this one of the codes that I have occu...
asked by 08.10.2016 / 01:11
1
answer

Adjust timezone in each query from Laravel

I have developed a portal for a client and, at the last minute, he has asked me to adjust all the dates and times for foreign schedules. Is there any way for MySQL to provide the translated date to another Timezone from Laravel? I know the...
asked by 19.10.2016 / 09:40
2
answers

Error in web service: Error: SQLSTATE [HY000] [2002] Connection refused

<?php $usu = $_REQUEST['usu']; $pas = $_REQUEST['pas']; try{ // establecemos la conexion con PDO $conexion = new PDO("mysql:host=pagina.000webhostapp.com;port=3306;dbname=id554244_basededatos", "id453244_usuario", "contraseña");...
asked by 17.10.2016 / 07:31
1
answer

Problem with SSL when connecting to MySQL

Every time I connect to the Database or try to execute a query, I get the following error in console: Sat Sep 10 17:38:48 BOT 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQ...
asked by 10.09.2016 / 23:43
1
answer

How to fill a Java box combo from another class Using MySql

It turns out that I created a class with java interface in conjunction with NetBeans. Well I have a combo that filled it with the result of a query but when opening a new frame I insert a data to mysql and when it closes I want it to update auto...
asked by 14.09.2016 / 03:02
1
answer

Is it possible to import a sql script and split the queries?

I'm looking to create a database from a one-button event, the problem is that the way I'm doing it at the moment, is to take each query, add it manually and execute it, all right up there. The problem is that every time there is a change in the...
asked by 22.09.2016 / 16:57
4
answers

value auto-incremental ID

I have a question about the AUTOINCREMENT values in MySQL In a system that I am developing allows you to save projects and the corresponding paperwork that must be kept (records, letters, forms), in the registration window it asks you to ente...
asked by 26.05.2016 / 06:56
1
answer

SQL script with column '-1'

I have this SQL script: create view transactview as ( select SUM(quantity) as venta,tag,shift_id,pump,nozzle from transactions where tag in (100,200,300,400) group by tag,shift_id,pump,nozzle union select SUM(quantity) as venta,'-1',shift_...
asked by 12.08.2016 / 16:13