Bernardo Harreguy's questions

I am trying to call the following function:

public void seleccionarpanelsecundario([Optional, DefaultParameterValue(null)] ref TabPage a, [Optional, DefaultParameterValue(false)]  bool regresaralpaneldeterminado) // cambia el panel secundario a travez de tabitem
        {

And what I want to do is call it only the second parameter. In the following way:

seleccionarpanelsecundario(, true);

and it tells me that an argument is missing, but it's optional.

In another case I try to call a function where it also sent a parameter, of which it is optional as follows. I have the following function:

 public string rellenarlistadetickets(string iniciofecha, string finfecha, [Optional, DefaultParameterValue(0)] ref decimal total, bool obtenerdecajaabierta = false)
        {

And I call it in the following way and it also gives me an error:

console.writeline(ticketaanular.rellenarlistadetickets(desde.Text, desde.Text, obtenerdecajaabierta: true))

In the latter, the following poster tells me:

How can I achieve what I'm trying to do, call a function while avoiding an optional parameter?

I want to import products through some MYSQL procedures, I simply have the "import_items" table where the items to be imported are located, and I have the products table, and prices that would be where the data would be destined: The data is entered manually up to this table "Import_items" and a procedure will check if the products are duplicates. Below are the declarations of said tables described: Import_items table

CREATE TABLE `importar_items` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `idimportar` INT(11) NOT NULL DEFAULT '0',
    `cantidad` DECIMAL(11,2) NULL DEFAULT NULL,
    `nombre` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    `categoria` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    `codigobarras` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    `precio` DECIMAL(10,2) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idimportar` (`idimportar`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

Products Table

CREATE TABLE `productos` (
    `cantidad` DECIMAL(11,2) NOT NULL DEFAULT '0.00',
    `cantidadbultoabierto` DECIMAL(11,2) NULL DEFAULT NULL,
    `cantidadbultocerrado` DECIMAL(11,2) NULL DEFAULT NULL,
    `categoria` INT(11) NULL DEFAULT NULL,
    `eliminado` TINYINT(1) NOT NULL DEFAULT '0',
    `especial` TINYINT(1) NOT NULL DEFAULT '0',
    `fecha` DATETIME NOT NULL,
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `ingresosbrutos` DECIMAL(3,2) NOT NULL DEFAULT '0.00',
    `nombre` VARCHAR(250) NOT NULL COLLATE 'utf8_general_ci',
    `proveedor` INT(11) NULL DEFAULT NULL,
    `stockminimo` DECIMAL(11,2) NOT NULL DEFAULT '4.00',
    `tipodeproducto` INT(11) NULL DEFAULT NULL,
    `ultimamodificacion` DATETIME NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `balanzaid` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `id` (`id`, `nombre`) USING BTREE,
    INDEX `eliminado` (`eliminado`) USING BTREE,
    INDEX `ultimamodificacion` (`ultimamodificacion`) USING BTREE,
    INDEX `id2` (`id`) USING BTREE,
    FULLTEXT INDEX `nombre` (`nombre`),
    FULLTEXT INDEX `nombre_2` (`nombre`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

Price Table

CREATE TABLE `precios` (
    `ganancia` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `idproducto` INT(11) NOT NULL DEFAULT '0',
    `impuesto` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `ingresosbrutos` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `numerodepreciodelista` INT(10) NOT NULL DEFAULT '0',
    `porcentaje` DECIMAL(4,2) NOT NULL DEFAULT '0.00',
    `precio` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `precio2` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `costo` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `id` (`id`) USING BTREE,
    INDEX `numerodepreciodelista` (`idproducto`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

The destination tables are "products" and "Prices": The idea of ​​the tables is as follows, each product is detailed in the products table and is identified with products.id and products.name, each product corresponds to a price, from which is related as follows products.id = prices.idproduct. Each product can have multiple prices deferred by Price.listpricenumber. In other words, the product "PAN" has a price of "3" as a list price number 0, and this cannot be repeated, it cannot have two prices Price.listpricenumber=0.

The procedure checks if the product and its price exists and inserts it, and if not, it updates it and here is the problem. The products are added and if they are added, update their name. But the prices are inserted even if they already exist, and not as it should be, which is to update the "Price.price"

Each import is identified with an id_importacion to group the products by process, to differentiate from another in case there is the case that two imports are being done at the same time!

Here is the formula:

/*aquí agrego los productos */
INSERT IGNORE INTO productos (nombre, cantidad, fecha) SELECT nombre, cantidad, CURRENT_TIMESTAMP() FROM importar_items WHERE importar_items.idimportar= ultimoidimportar;
/*aquí actualizo los nombre de los productos por sus codigo de barras*/
update productos a inner JOIN codigobarras b ON (a.id = b.idproducto ) INNER JOIN importar_items c ON c.codigobarras = b.codigobarras set a.nombre = c.nombre  where c.idimportar= ultimoidimportar AND c.codigobarras IS NOT NULL;

The question query is as follows:

/*aqui los precios que debo ingresar pero se duplican*/
INSERT IGNORE INTO precios (idproducto, precio) SELECT productos.id, importar_items.precio FROM importar_items , productos WHERE productos.nombre = importar_items.nombre AND importar_items.idimportar= ultimoidimportar AND importar_items.precio IS NOT null;

My idea would be an INSERT INTO prices of idproduct and price of IMPORTAR_ITEMS without them being repeated and the condition of prices.numberofpriceoflist=0 not being repeated. in that case update!

In the event that they exist, it works for me with the following query:

/*actualizo precios*/
update precios u inner JOIN productos c ON (u.idproducto = c.id ) INNER JOIN  importar_items d ON d.nombre = c.nombre set u.precio = d.precio  where u.numerodepreciodelista = 0 AND d.idimportar= ultimoidimportar AND d.precio IS NOT NULL;

I am entering all the functions that do work so you can see how the import is done.

Is it possible to import the products and prices without duplicating them and in the event that they are found, update product.name and price.price? And to make the procedure faster, can it be done all in one query? to avoid excess query time when importing thousands of products? Well I hope someone can help me Thank you very much in advance

Hello how about you see a problem with git, it made me revert to a version that I didn't want, so I had to re-edit the whole repository from an even older version Currently the local repository doesn't have any GIT file, how can I add the local folder to a remote repository, without altering anything in the local and rewriting everything in the remote?

EXAMPLE I had repository X running version 56 and wanted to ROLL BACK to version 55 but instead rolled back to version 45 From the repository Download version 55 and delete all files that reference git I mean the ".git" folder. And work on the repository until you achieve the modifications you wanted and would like to place it, I don't know how to add it so that the changes made can be uploaded to the remote repository as revision 57, locally it is not as a repository because the folder is totally deleted. How I should proceed? From already thank you very much

How's it going? I have the following openssl command

openssl pkcs12 -export -out certificado_destino.pfx -inkey clave -in Certificado_original.crt

How can I get this command not to ask me for a password? It tells me "Enter password" and then repeat it, does anyone know? I hope someone can help me thanks

I need it to go with pkcs12, to encrypt a certificate, and this encryption is required by the system that is handled in my country, I cannot remove the "pkcs12" command

When using the passout command:

openssl pkcs12 -export -inkey privada -in certificado.crt -out alias.p12 -passout privada

Returns the error that it must have a valid value,

Invalid password argument "privada" Error getting passwords

I have a complex MYSQL query with INNER JOIN and what I need is to limit the result by one column. Basically I want to know the employees who are commission agents and when was the last date they were registered. In the movement of employees, a movement is written that is called "registration of commission agent" when it is registered, but it may happen more than once, and here is the problem. Step raise the tables that you use.

Employees table

CREATE TABLE `empleados` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `nombre` VARCHAR(50) NOT NULL,
    `apellido` TEXT NOT NULL,
    `telefono` TEXT NOT NULL,
    `comisionista` TINYINT(1) NOT NULL DEFAULT 0,
    `contrasena` TEXT NOT NULL,
    `eliminado` TINYINT(1) NOT NULL DEFAULT 0,
    `domicilio` TEXT NOT NULL,
    `correoelectronico` TEXT NOT NULL,
    `facebook` TEXT NOT NULL,
    `ganancia` DECIMAL(10,2) NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    FULLTEXT INDEX `nombre` (`nombre`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4
;

Employee movement table

CREATE TABLE `movimientosempleados` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `fecha` DATETIME NULL DEFAULT NULL,
    `tipodemovimiento` TEXT NOT NULL,
    `numero` INT(11) NOT NULL DEFAULT 0,
    `empleado` INT(11) NOT NULL DEFAULT 0,
    `datonuevo` DECIMAL(10,2) NULL DEFAULT NULL,
    `datoanterior` DECIMAL(10,2) NULL DEFAULT NULL,
    `nombrenuevo` TEXT NULL DEFAULT NULL,
    `nombreanterior` TEXT NULL DEFAULT NULL,
    `usuarioqueedita` INT(11) NULL DEFAULT NULL,
    `host` TEXT NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1757
;

The query in question is:

SELECT DISTINCT 
empleados.id, 
nombre, 
apellido, 
comisionista, 
ganancia, 
movimientosempleados.fecha 
FROM empleados 
INNER JOIN (movimientosempleados) ON (movimientosempleados.empleado = empleados.id)  
WHERE eliminado = 0  AND comisionista = 1 AND tipodemovimiento = 'ALTA COMISIONISTA';

The result I get is the following:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
  <head>
    <title>TablaDesconocida</title>
    <meta name="GENERATOR" content="HeidiSQL 10.2.0.5683">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style type="text/css">
      thead tr {background-color: ActiveCaption; color: CaptionText;}
      th, td {vertical-align: top; font-family: "Segoe UI", Arial, Helvetica, sans-serif; font-size: 9pt; padding: 3px; }
      table, td {border: 1px solid silver;}
      table {border-collapse: collapse;}
      thead .col0 {width: 47px;}
      .col0 {text-align: right;}
      thead .col1 {width: 128px;}
      thead .col2 {width: 70px;}
      thead .col3 {width: 95px;}
      .col3 {text-align: right;}
      thead .col4 {width: 76px;}
      .col4 {text-align: right;}
      thead .col5 {width: 138px;}
    </style>
  </head>

  <body>

    <table caption="TablaDesconocida (5 rows)">
      <thead>
        <tr>
          <th class="col0">id</th>
          <th class="col1">nombre</th>
          <th class="col2">apellido</th>
          <th class="col3">comisionista</th>
          <th class="col4">ganancia</th>
          <th class="col5">fecha</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <td class="col0">-1</td>
          <td class="col1">ADMINISTRADOR</td>
          <td class="col2"></td>
          <td class="col3">1</td>
          <td class="col4">9,00</td>
          <td class="col5">2019-10-11 15:12:16</td>
        </tr>
        <tr>
          <td class="col0">-1</td>
          <td class="col1">ADMINISTRADOR</td>
          <td class="col2"></td>
          <td class="col3">1</td>
          <td class="col4">9,00</td>
          <td class="col5">2019-10-11 15:19:25</td>
        </tr>
        <tr>
          <td class="col0">0</td>
          <td class="col1">USUARIO</td>
          <td class="col2">DF</td>
          <td class="col3">1</td>
          <td class="col4">900,00</td>
          <td class="col5">2019-10-11 15:21:20</td>
        </tr>
        <tr>
          <td class="col0">3</td>
          <td class="col1">BERNARDO</td>
          <td class="col2"></td>
          <td class="col3">1</td>
          <td class="col4">12,00</td>
          <td class="col5">2019-10-11 14:35:19</td>
        </tr>
        <tr>
          <td class="col0">3</td>
          <td class="col1">BERNARDO</td>
          <td class="col2"></td>
          <td class="col3">1</td>
          <td class="col4">12,00</td>
          <td class="col5">2019-10-11 16:17:58</td>
        </tr>
      </tbody>
    </table>


  </body>
</html>

What I need would be, that the results be limited for each employee, that is to say that the employees are not repeated because they are repeated because there are several times that the 'HIGH COMMISSION AGENT' movement is carried out and also I only need to obtain the last date of "high commission agent " which would be the DATETIME of DATE in movimientosempleadosthe previous ones are not necessary! I hope someone can help me, Thanks.

I have the need to create an event that is executed when changing the properties of 3 objects that I have in a class. In order to present everything, I must show you what I have done: Below is the complete class, whose function is to create ToolStripa search filter fechawhere you can choose a date, between two dates or always, and it is as follows:

Public Class filtrofecha
    Implements IDisposable

    Private labelfiltroporfecha As ToolStripLabel
    Public Property hora1 As New DateTime
    Public Property hora2 As New DateTime
    Public Property tipodeintervalo As New intervalo
    Public Enum intervalo
        porfecha 
        porintervalo 
        todoeltiempo
    End Enum
    Private horas1lab As Label
    Private horas2lab As Label
    Public horas1 As DateTimePicker
    Public horas2 As DateTimePicker
    Public tiempo As ComboBox
    Private barraaagregar As ToolStrip
    Private barra As ToolStripControlHost

    Sub New(ByRef barraaagregar0 As ToolStrip, ByRef horas01 As DateTimePicker, ByRef horas02 As DateTimePicker, ByRef tiempo0 As ComboBox)
        barraaagregar = barraaagregar0
        horas1 = horas01
        horas2 = horas02
        horas1lab = New Label
        horas2lab = New Label
        tiempo = tiempo0
        labelfiltroporfecha = New System.Windows.Forms.ToolStripLabel()
        labelfiltroporfecha.Name = "labelfiltroporfecha"
        labelfiltroporfecha.Size = New System.Drawing.Size(94, 24)
        labelfiltroporfecha.Text = "Filtro de tiempo:"
        horas1lab.Text = "Desde:"
        horas2lab.Text = "Hasta:"
        horas1.Format = DateTimePickerFormat.Short
        horas2.Format = DateTimePickerFormat.Short
        horas1.Width = 85
        horas2.Width = 85
        horas1.CustomFormat = "dd-MM-yyyy"
        horas2.CustomFormat = "dd-MM-yyyy"
        tiempo.Items.Add("Fecha")
        tiempo.Items.Add("Intervalo")
        tiempo.Items.Add("Todo el tiempo")
        tiempo.DropDownStyle = ComboBoxStyle.DropDownList
        barraaagregar.Items.Add(labelfiltroporfecha)
        barra = New ToolStripControlHost(tiempo)
        barraaagregar.Items.Add(barra)
        barra = New ToolStripControlHost(horas1lab)
        barraaagregar.Items.Add(barra)
        barra = New ToolStripControlHost(horas1)
        barraaagregar.Items.Add(barra)
        barra = New ToolStripControlHost(horas2lab)
        barraaagregar.Items.Add(barra)
        barra = New ToolStripControlHost(horas2)
        barraaagregar.Items.Add(barra)
        AddHandler tiempo.SelectedIndexChanged, AddressOf TiempoSelectedIndexChanged
        AddHandler horas1.ValueChanged, AddressOf horas1_ValueChanged
        AddHandler horas2.ValueChanged, AddressOf horas2_ValueChanged
        tiempo.SelectedIndex = 2
    End Sub
    Private Sub compararfechas()
        Me.hora1 = horas1.Value
        Me.hora2 = horas2.Value
        If tiempo.SelectedIndex = 2 Then
            If Not (DateTime.Compare(horas1.Value, horas2.Value) > 0) Then
                mensaje("Ingreso de fechas incorrecto!", True)
            End If
        End If
    End Sub
    Private Sub horas1_ValueChanged(sender As Object, e As EventArgs)
        compararfechas()
    End Sub
    Private Sub horas2_ValueChanged(sender As Object, e As EventArgs)
        compararfechas()
    End Sub
    Sub TiempoSelectedIndexChanged(sender As Object, e As EventArgs)
        Select Case tiempo.SelectedIndex
            Case 1
                tipodeintervalo = intervalo.porintervalo
                horas2.Visible = True
                horas2lab.Visible = True
                horas1lab.Visible = True
                horas1.Visible = True
            Case 0
                tipodeintervalo = intervalo.porfecha
                horas2.Visible = False
                horas2lab.Visible = False
                horas1lab.Visible = True
                horas1.Visible = True
            Case 2
                tipodeintervalo = intervalo.todoeltiempo
                horas2.Visible = False
                horas2lab.Visible = False
                horas1.Visible = False
                horas1lab.Visible = False
        End Select
    End Sub

#Region "IDisposable Support"
    Private disposedValue As Boolean ' Para detectar llamadas redundantes

    ' IDisposable
    Protected Overridable Sub Dispose(disposing As Boolean)
        If Not disposedValue Then
            If disposing Then
                ' TODO: elimine el estado administrado (objetos administrados).
            End If

            ' TODO: libere los recursos no administrados (objetos no administrados) y reemplace Finalize() a continuación.
            ' TODO: configure los campos grandes en nulos.
        End If
        disposedValue = True
    End Sub

    ' TODO: reemplace Finalize() solo si el anterior Dispose(disposing As Boolean) tiene código para liberar recursos no administrados.
    'Protected Overrides Sub Finalize()
    '    ' No cambie este código. Coloque el código de limpieza en el anterior Dispose(disposing As Boolean).
    '    Dispose(False)
    '    MyBase.Finalize()
    'End Sub

    ' Visual Basic agrega este código para implementar correctamente el patrón descartable.
    Public Sub Dispose() Implements IDisposable.Dispose
        ' No cambie este código. Coloque el código de limpieza en el anterior Dispose(disposing As Boolean).
        Dispose(True)
        ' TODO: quite la marca de comentario de la siguiente línea si Finalize() se ha reemplazado antes.
        ' GC.SuppressFinalize(Me)
    End Sub
#End Region
End Class

Here the properties that I want to import would be Hora1and Hora2that they are Datetime, and tipodeintervalothat it is a custom object Enumerable. The event to create is when the values ​​of these properties are changed

Here is the code of how I create an object of this class:

Private filtroitemsanulados As filtrofecha
 Dim tiempofiltro As New ComboBox
                AddHandler tiempofiltro.SelectedIndexChanged, AddressOf fitroanulaciones
                Dim horas1filtro As New DateTimePicker
                AddHandler horas1filtro.ValueChanged, AddressOf fitroanulaciones
                Dim horas2filtro As New DateTimePicker
                AddHandler horas2filtro.ValueChanged, AddressOf fitroanulaciones
                filtroitemsanulados = New filtrofecha(Barradeitemsanulados, horas1filtro, horas2filtro, tiempofiltro)

Here the default events of Valuechangedand SelectedIndexChangedof the parameters of horas1filtro, horas2filtroand tiempofiltrothey are something similar to what I am looking for, the problem with this is that the previously mentioned properties are not modified in these events, but a few milliseconds later. That is to say that they do not work for me, for example when changing the index of the combo box tiempofiltrothe index changes but what happens in the class in the same event is the following, I quote code:

Sub TiempoSelectedIndexChanged(sender As Object, e As EventArgs)
        Select Case tiempo.SelectedIndex
            Case 1
                tipodeintervalo = intervalo.porintervalo
                horas2.Visible = True
                horas2lab.Visible = True
                horas1lab.Visible = True
                horas1.Visible = True
            Case 0
                tipodeintervalo = intervalo.porfecha
                horas2.Visible = False
                horas2lab.Visible = False
                horas1lab.Visible = True
                horas1.Visible = True
            Case 2
                tipodeintervalo = intervalo.todoeltiempo
                horas2.Visible = False
                horas2lab.Visible = False
                horas1.Visible = False
                horas1lab.Visible = False
        End Select
    End Sub

As you can see, the tipodeintervalo, changes value after passing through this sub. What I want is to create an event like the following:

Private filtroitemsanulados As filtrofecha
Dim tiempofiltro As New ComboBox                    
Dim horas1filtro As New DateTimePicker
Dim horas2filtro As New DateTimePicker
filtroitemsanulados = New filtrofecha(Barradeitemsanulados, horas1filtro, horas2filtro, tiempofiltro)
AddHandler filtroitemanulados.cambianpropiedades, AddresOf Rellenado

So when I go to said subit would have something like this:

Sub rellenado ()
'alguno de los siguientes cambian
msgbox(filtroitemsanulados.hora1.tostring) <--- con hora cambiada
msgbox(filtroitemsanulados.hora2.tostring) <--- con hora cambiada
msgbox(filtroitemsanulados.tipodeintervalo.tostring) <--- con variable ambiada
end sub

In the latter, only the variables will be displayed on the screen, the interesting thing would be that the changes die as soon as they are made by the user. I hope I explained myself well! THANK YOU

I know that it is possible to create a list of forms with "List Of", below how the list would be to be able to identify:

Private ChildFormList As List(Of Form) = New List(Of Form)()

I would like to know if it is possible to add to this list of forms, in the same list, a variable of type "Integer" and a toolstrip button "toolstripbutton", then an imaginative solution, it is to explain myself.

Private ChildFormList As List(Of Form, Integer, ToolstripButton) = New List(Of Form, Integer, ToolstripButton)()

The idea is that each form generates a corresponding number with a button, for example

form.name("Form 1"), 1, toolstripbutton.name("button1")

That is to say that the form "Form 1" corresponds to the number 1, and the button called "button1", with this I differ from a matrix, where there can be more than one form than a number, or a button. Each form must contain a number and a button! I hope I have expressed myself well, thank you

I would like to know how I can identify an MDI-Child form, and differentiate one from another. I know how to identify it by name, as you can see as follows:

DirectCast(Application.OpenForms.Item(formulario.Name), formulario)

But what happens in this example if the same form obviously has a repeated name, I can differentiate one form from another. I want to know how I can list the forms and go through them, and be able to differentiate between them, through an identification or something, Like an open process has a PID, a form surely has something similar, right? THANK YOU

I have to make a project under a plugin that requires Eclipse 3.7.2 , but it was no longer supported when Java 8 came out.

I currently have Linux Mint 19 and the latest version of OpenJDK. Is there any way to make it work?

With a bottle of JDK version 7 I think, it works, right?

I would like to know how a new record can be inserted in a table when a condition is met. In SQLlite you can as far as I know, but in MARIADB I can't do it. An example of what I would like to do:

INSERT INTO rubros (nombre) SELECT 'Articulos varios' WHERE nombre != 'Articulos varios' ;

This code is tested and returns the following error:

sql error(1064): Something is wrong in your syntax near "WHERE name != 'Miscellaneous Items'" on line 1

In this case, it would be to enter in the table "Items" the record with the name "Miscellaneous articles" if it does not exist. Namely

INSERT INTO table (value) SELECT * WHERE (Condition) In condition, if it is fulfilled, the record is inserted.

PS: I have tried this answer and it didn't work, I have MariaDB version 10.3.12. The code I used to try to use "EXISTS" is the following code:

INSERT INTO rubros (nombre, descripcion) 
SELECT 'Articulos varios', '' 
WHERE EXISTS (
    SELECT nombre FROM rubros WHERE nombre = 'Articulos varios'
)  ;

The error that I get is the following:

sql error(1064): Something is wrong in your syntax near " WHERE EXISTS (SELECT name FROM items WHERE name = 'Miscellaneous Items') " on line 1

From already thank you very much

I have a query that makes the MariaDB server use 100% CPU for more than 10 minutes and finally the page times out.

The query in question is the following:

SELECT 
  formasdepago.nombre as 'Forma de pago', 
  SUM(transaccion) AS Total 
FROM contabilidad 
INNER JOIN formasdepago ON formasdepago.id = contabilidad.formadepago 
WHERE contabilidad.anulado = 0  
Group By formadepago 

The corresponding tables are the following:

Accounting :

CREATE TABLE `contabilidad` (
    `anulado` TINYINT(1) NOT NULL DEFAULT '0',
    `cuentacorriente` INT(11) NOT NULL DEFAULT '0',
    `cuotas` DECIMAL(10,2) NOT NULL DEFAULT '0',
    `empleado` INT(11) NOT NULL DEFAULT '0',
    `fecha` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `formadepago` INT(11) NOT NULL DEFAULT '1',
    `id` INT(11) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
    `idgasto` INT(11) NOT NULL DEFAULT '0',
    `interesfinanciero` DECIMAL(10,2) NOT NULL DEFAULT '0',
    `interesformadepago` DECIMAL(10,2) NOT NULL DEFAULT '0',
    `ticketid` INT(11) NOT NULL DEFAULT '0',
    `tipodetransaccion` VARCHAR(50) NOT NULL,
    `transaccion` DECIMAL(10,2) NOT NULL DEFAULT '0',
    `valordecuota` DECIMAL(10,2) NOT NULL DEFAULT '0',
    `valorfinal` DECIMAL(10,2) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    INDEX `fecha` (`fecha`),
    INDEX `ticketid` (`ticketid`),
    INDEX `idgasto` (`idgasto`),
    INDEX `formadepago` (`formadepago`),
    FULLTEXT INDEX `tipodetransaccion` (`tipodetransaccion`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=13975947
;

Form of payment :

CREATE TABLE `formasdepago` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `habilitado` INT(1) NOT NULL DEFAULT '1',
    `eliminado` INT(1) NOT NULL DEFAULT '0',
    `simbolo` VARCHAR(5) NOT NULL,
    `diferencia` DECIMAL(11,2) NOT NULL DEFAULT '0',
    `imagen` MEDIUMBLOB NULL DEFAULT NULL,
    `nombre` VARCHAR(50) NOT NULL,
    `preciodelista` INT(1) NOT NULL DEFAULT '0',
    `numeropreciodelista` INT(5) NOT NULL DEFAULT '1',
    `financiacion` INT(5) NOT NULL DEFAULT '0',
    `imagenmini` BLOB NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    INDEX `id` (`id`),
    INDEX `eliminado` (`eliminado`),
    INDEX `habilitado` (`habilitado`),
    FULLTEXT INDEX `nombre` (`nombre`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=8
;

Accounting has 1.5 GB of information, while payment method only has 3 records.

With such a large amount of data, I separate it by date to perform a smaller query, but I don't understand what the delay is.

Could anyone give me some clue as to what the server is doing that is taking so long? I do not understand, really. I hope someone can help me, thank you very much.

I'm looking for a way to recursively search over a folder (exploring directory and subdirectories) for files to be uploaded with AngularJS Upload, but the important thing is to en-list the files and search in a local folder. That is, a function that returns in an array, for example, the mp3 files found in a specified folder, I am not so interested in the upload part.

The idea is to do it in AngularJS if possible or by JavaScript or jQuery maybe. Does anyone know something? It would also be nice if it finds files with the same name, just take one, not both.

something very strange that happens to me, is that I try to place getApplicationContext() and it tells me that

"cannot find symbol"

I do the corresponding import and it does not give an error

import android.content.ContextWrapper;

For you to understand, the mediaplayer works for me, I can create an android mediaplayer, but I can't make that work, why? hope someone knows thanks

The source code where this problem occurs is the following package bfhsoftware.soundambiental;

import android.content.Context;
import android.media.MediaPlayer;
import android.media.MediaPlayer.OnCompletionListener;
import android.widget.Toast;

/**
 *
 * @author bfhsoftware
 */
public class ReproductorAndroid extends reproductor{
    private static MediaPlayer reproductor = null;
    OnCompletionListener escuchar = sedetienelamusica();
    public ReproductorAndroid() {
        super();
    }

    @Override
    public void empezar(String proximotema) {        
        super.empezar(proximotema);
        //
        if ((reproductor == null)){
            try {
                if (proximotema.equals("")){                    
                    System.out.println(proximotema);
                    //Environment.getExternalStorageDirectory().getPath()+
                    //Uri myUri = Uri.parse(proximotema);
                    reproductor = new MediaPlayer();                 
                    reproductor.setDataSource(getApplicationContext(),Uri.parse(proximotema)); 

                    reproductor.prepare(); // might take long! (for buffering, etc)                                        
                    reproductor.setOnCompletionListener(escuchar);
                    reproductor.start();
                    System.out.println("deberia estar reproduciendo");
                }
            } catch(Exception e ) {
                e.printStackTrace();
                System.out.println("error al reproducir");
                System.out.println(e.getMessage());        
            }
        }
        reproduciendo = (reproductor != null);
    }

    @Override
    public void parar() {
        /* Llamamos a la implementación común de parada */
        super.parar();
        /* Implementamos aquí el método en android */
    }

    @Override
    public void pausa() {
        /* Llamamos a la implementación común de pausa */
        super.pausa();
        /* Implementamos aquí el método en android */
    }

    private OnCompletionListener sedetienelamusica() {
        reiniciar();
        reproducir();
        return null;
    }
    private void reiniciar(){
        reproduciendo = false;
        if (reproductor != null)
            reproductor.stop();
        reproductor = null;
    }
    public static void displayExceptionMessage(Context context, String msg)
{
    Toast.makeText(context, msg , Toast.LENGTH_LONG).show();
}
}

in the line player.setDataSource(getApplicationContext(),Uri.parse(nexttopic)); the compiler tells me that getApplicationContext is not recognized as a symbol, I have tried in netbeans and intellij idea community version. For me the code is correctly entered, for me the problem is the platform, it is not Android where I execute it, how to place this syntax and compile it, and that it only be executed if the operating system is not android?

I have a multi-platform system, and in order to design it I need to know how I could execute a class depending on the operating system.

I have created the following simple function Public Boolean esandroid(){....}where if the system is android it is true otherwise it is false, In this way I have managed well placing if everywhere, but it is not practical, I want to know if there is any way to make classes depending on the operating system for example .

Class reproducir (){ 
...Codigo para reproducir en android...
}
Class reproducir (){
...Codigo para reproducir que no sea en android...
}

The idea is that depending on the operating system that executes the corresponding class.

Having two classes in the previous example, the same class is referenced, and it executes the one corresponding to the operating system where it currently operates. It's possible?

Hi how are things? I have a mysql function that worked at one point, and now for no apparent reason it fails, and always throws me the same error, here is the code

CREATE DEFINER=`root`@`localhost` PROCEDURE `borrar_columna`(
    IN `nombredecolumna` TEXT ,
    IN `nombredetabla` TEXT)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
IF (SELECT count(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = nombredetabla AND table_schema = DATABASE()) = 1 THEN
SET @sqlstmt = CONCAT('DROP TABLE `', nombredetabla ,'`;');
PREPARE st FROM @sqlstmt;
EXECUTE st;
DEALLOCATE PREPARE st;
ELSE
IF (SELECT count(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = nombredecolumna AND table_name = nombredetabla AND table_schema = DATABASE()) = 1 THEN
SET @sqlstmt = CONCAT('ALTER TABLE `', nombredetabla ,'` DROP COLUMN `', nombredecolumna ,'`;');
PREPARE st FROM @sqlstmt;
EXECUTE st;
DEALLOCATE PREPARE st;
END IF;
END IF;
END

The error I get is the following...

SQL error (1054) column '123' in field list is unknown

the command I give is like this

CALL borrar_columna(`123`,`prueba`);

Of course the column and the table exist and are created to do the test. It worked several times, but now it fails, I don't understand why, I see everything correctly, I hope you can help me. Thanks.

Hi how are things? I am working on an app under android-studio. I want to make an option in my application that says "start when the device is turned on", that the application itself checks if it starts when the device is turned on and auto-check the option, otherwise not, that when it works, how can they be given account, the application starts when android starts. How is this possible? I'm looking and I don't know how to do it thanks

the query that I want to perform is about the selection of a musical theme with certain specifications, to make a playlist, it is generated as the themes are played, the query is something like selecting the next song. In the table I have a logical data like, "played" where it turns to true when it is played and "lastplayed" where the DATETIME is placed at the time of playback. Here is the database schema:

albums table

CREATE TABLE "albums" ( `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, `nombre` TEXT );

music table

CREATE TABLE "musica" ( `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, `nombreyruta` TEXT NOT NULL, `anulado` NUMERIC NOT NULL DEFAULT 0, `album` INTEGER, `reproducido` INTEGER NOT NULL DEFAULT 0, `ultimareproduccion` TEXT );

Reproduction table

CREATE TABLE "reproduccion" ( `Id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, `idalbum` INTEGER NOT NULL DEFAULT 0, `habilitado` INTEGER NOT NULL DEFAULT 1 )

I would need that in the selection of the next theme, it is based on a SELECT query, that it chooses the next theme to play in the following way, that it has the data PLAYBACK = 0, and that it avoids selecting those that have been played recently, and also, that within this in a percentage you can perform a Ramdom, or random selection. An example, the playback theme is requested to be ordered from highest to lowest in "LAST PLAY" and that from the 40% of these oldest, it can be selected randomly. The main idea is that the playlist is not repetitive, that is, that the list is not always the same, and that the songs are not heard one after the other.

Here I leave the select that I have to preview, what it does is select all the songs that can be chosen for playback:

SELECT musica.id from musica inner join reproduccion on musica.album = reproduccion.idalbum  WHERE musica.reproducido = 0;

As you can see, the playback is not carried out in the database, but is done when you ask with a SELECT which is the next song to play. which is what it would take to solve this question!

I hope you can help me thank you very much

I have done a procedure in a loop, but it seems pretty precarious to me, which leads to a process too slow for MYSQL, around 15 minutes. the procedure is the next

DELIMITER \
    CREATE DEFINER=`root`@`localhost` PROCEDURE `actualizarbasededatos`()
    LANGUAGE SQL
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
    BEGIN
    DECLARE x INT(11); 
    SET x = (SELECT id FROM productos ORDER BY id ASC LIMIT 1);
    REPEAT
    IF ifnull((SELECT codigobarras FROM productos WHERE x=id AND eliminado = 0), ")) != " AND ifnull((SELECT codigobarras FROM codigobarras WHERE idproducto = x),") = ifnull((SELECT codigobarras FROM productos WHERE x=id AND eliminado = 0), "))  THEN
    INSERT INTO codigobarras (codigobarras, idproducto) SELECT codigobarras, id FROM productos WHERE id = x;
    END IF;
    IF (IFNULL((SELECT id FROM precios WHERE x=idproducto AND numerodepreciodelista = 0 limit 1), -1)) = -1 AND (IFNULL((SELECT id FROM productos WHERE x=id AND eliminado = 0 limit 1), -1)) != -1 THEN
    INSERT INTO precios (precio, precio2, idproducto, numerodepreciodelista) SELECT precio, precio2, id, 0 FROM productos WHERE id=x;
    END IF;
    SET x = x + 1;
    UNTIL x > (select id from productos order by id desc limit 1) END REPEAT;
    SET x = (SELECT id FROM tickets ORDER BY id ASC LIMIT 1);
    REPEAT
    IF (select total from tickets WHERE id = x) != (ifnull((SELECT SUM(transaccion) FROM contabilidad WHERE    tipodetransaccion ='pago' and ticketid = x),0)) THEN    
    IF (ifnull((SELECT SUM(transaccion) FROM contabilidad WHERE tipodetransaccion ='pago' and ticketid = x),0)) = 0 THEN    
    INSERT INTO contabilidad (tipodetransaccion, ticketid, transaccion, formadepago) VALUES ('pago', x, (SELECT total FROM tickets WHERE id = x), 'Efectivo');
    END IF;
    END IF;
    SET x = x + 1;
    UNTIL x > (select id from tickets order by id desc limit 1)  END REPEAT;
    END
\ DELIMITER;

What the procedure performs is an update of the structure in the database, where the payments of the tickets can be carried out in an independent table, in addition to the barcodes of the products are also registered in another separate table. The operation of it is more optimal and it seems much better to me that's why the change, the problem is that the update, the process takes too long as I already said. The following code refers to the structure of the Barcode Table database.

DROP TABLE IF EXISTS `codigobarras`;
CREATE TABLE IF NOT EXISTS `codigobarras` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idproducto` int(11) NOT NULL DEFAULT '0',
  `codigobarras` text NOT NULL,
  `idrubro` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3891 DEFAULT CHARSET=utf8;

Products table

DROP TABLE IF EXISTS `productos`;
CREATE TABLE IF NOT EXISTS `productos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `promocionid` int(11) NOT NULL DEFAULT '0',
  `nombre` text NOT NULL,
  `tipodeproducto` int(11) NOT NULL DEFAULT '0',
  `cantidadbultocerrado` decimal(10,3) NOT NULL DEFAULT '0.000',
  `cantidadbultoabierto` decimal(10,3) NOT NULL DEFAULT '0.000',
  `especial` tinyint(4) NOT NULL DEFAULT '0',
  `ganancia` decimal(10,2) NOT NULL DEFAULT '0.00',
  `impuesto` decimal(3,2) NOT NULL DEFAULT '0.00',
  `ultimamodificacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ingresosbrutos` decimal(3,2) NOT NULL DEFAULT '0.00',
  `categoria` char(5) NOT NULL,
  `proveedor` varchar(5) NOT NULL,
  `cantidad` decimal(11,2) NOT NULL DEFAULT '0.00',
  `stockminimo` int(11) NOT NULL DEFAULT '4',
  `precio` decimal(10,2) NOT NULL DEFAULT '0.00',
  `costo` decimal(10,2) NOT NULL DEFAULT '0.00',
  `precio2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pesoprecio` decimal(10,2) NOT NULL DEFAULT '1.00',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `codigobarras` varchar(50) NOT NULL DEFAULT '',
  `imagen` blob,
  `eliminado` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9031 DEFAULT CHARSET=utf8;

Ticket table

DROP TABLE IF EXISTS `tickets`;
CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `anulacion` int(11) NOT NULL DEFAULT '0',
  `pagadocon` decimal(11,2) NOT NULL DEFAULT '0.00',
  `total` decimal(11,2) NOT NULL DEFAULT '0.00',
  `formadepago` int(11) NOT NULL DEFAULT '0',
  `descuento` decimal(5,2) NOT NULL DEFAULT '0.00',
  `cuentacorriente` int(11) NOT NULL DEFAULT '0',
  `empleado` int(10) NOT NULL DEFAULT '0',
  `rubro` int(10) NOT NULL DEFAULT '0',
  `financiamiento` int(5) NOT NULL DEFAULT '0',
  `recargodeformadepago` decimal(11,2) NOT NULL DEFAULT '0.00',
  `recargofinanciamiento` decimal(11,2) NOT NULL DEFAULT '0.00',
  `cuotas` int(2) NOT NULL DEFAULT '0',
  `terminal` text,
  `deuda` decimal(11,2) NOT NULL DEFAULT '0.00',
  `retiro` int(11) NOT NULL DEFAULT '0',
  `pago` decimal(11,2) NOT NULL DEFAULT '0.00',
  `senacliente` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=latin1;

So far the old tables, I'll do some optimizations, and indexing, in the upgrade, but that's not important at the moment. The following tables are created for "database upgrade" purposes. As I mentioned before, the update more than anything involves optimizing future database queries. That is why the separation of data, to be able to create indexes.

accounting table

CREATE TABLE `contabilidad` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `ticketid` INT(11) NOT NULL DEFAULT '0',
    `cuentacorriente` INT(11) NOT NULL DEFAULT '0',
    `empleado` INT(11) NOT NULL DEFAULT '0',
    `fecha` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `interesfinanciero` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `interesformadepago` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `cuotas` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `transaccion` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `anulado` TINYINT(1) NOT NULL DEFAULT '0',
    `idgasto` INT(11) NOT NULL DEFAULT '0',
    `valordecuota` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `valorfinal` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `tipodetransaccion` TEXT NOT NULL,
    `formadepago` TEXT NOT NULL,
    PRIMARY KEY (`id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=131
;

Price Table

CREATE TABLE `precios` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `porcentaje` DECIMAL(4,2) NOT NULL DEFAULT '0.00',
    `precio` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `precio2` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `idproducto` INT(11) NOT NULL DEFAULT '0',
    `numerodepreciodelista` INT(10) NOT NULL DEFAULT '0',
    `ganancia` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `costo` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `impuesto` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `ingresosbrutos` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    PRIMARY KEY (`id`),
    INDEX `idproducto` (`idproducto`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=5563
;

Here with all the structures you can see how the procedure works, it would simply be executed once. But the idea is to make it faster, and obviously it works but very slowly. From already thank you very much

I'm having trouble getting a table with relationships. The problem arose that I had a complex query with many relationships, when I asked the question they helped me make the query efficient and fast, but when I placed it in my VB.NET-based program I got the following error:

No se pudieron habilitar las restricciones. Una o varias filas contienen valores que infringen las restricciones NON-NULL, UNIQUE o FOREIGN-KEY.

The system must show on the screen through a datagridview all the products, simple words but complex to carry out.

I have made classes for each thing, because the system is becoming more complex and I have separated everything into classes.

The datagridview uses a bindingsource, as follows:

Public datosdeproductos As New BindingSource
Private listadodeproducto As New DataSet
datosdeproductos.DataSource = listadodeproducto
Using conexion As New MySqlConnection(conexionstring)
    conexion.Open()
    If listadodeproducto Is Nothing Then
        listadodeproducto = New DataSet()
        listadodeproducto.BeginInit()
    End If
    dim consulta as string = "SELECT pr.id, pr.nombre as Nombre, cp.nombre AS Categoria, pv.nombre AS Proveedor, cantidad as Cantidad, stockminimo AS 'Stock Mínimo', (p.precio) AS Precio, (p.precio2) AS 'Precio %', (p.costo) AS 'P. costo', (p.ganancia) AS Ganancia, ultimamodificacion AS 'Fecha última modificación', cod.codigobarras AS 'Código de Barras' FROM productos pr INNER JOIN precios p ON p.idproducto = pr.id INNER JOIN proveedores pv ON pv.id = pr.proveedor INNER JOIN categoriadeproductos cp ON cp.id = pr.categoria INNER JOIN codigobarras cod ON cod.idproducto = pr.id WHERE p.numerodepreciodelista = 0 AND pr.eliminado = 0;"
    Using adaptador As New MySqlDataAdapter(consulta, conexion)
        adaptador.Fill(listadodeproducto, "listadodeproductos")
    End using
    conexion.close
End using
planillalistadeproductos.datasource = listadodeproducto ' 
planillalistadeproductos es el datagridview
planillalistadeproductos.DataMember = "listadodeproductos"

The query I am using is the following:

SELECT 
pr.id, 
pr.nombre as Nombre,
cp.nombre AS Categoria,
pv.nombre AS Proveedor, 
cantidad as Cantidad,
stockminimo AS 'Stock Mínimo',
(p.precio) AS Precio,
(p.precio2) AS 'Precio %',
(p.costo) AS 'P. costo',
(p.ganancia) AS Ganancia,
ultimamodificacion AS 'Fecha última modificación',
cod.codigobarras AS 'Código de Barras'
FROM productos pr 
INNER JOIN precios p ON p.idproducto = pr.id
INNER JOIN proveedores pv ON pv.id = pr.proveedor 
INNER JOIN categoriadeproductos cp ON cp.id = pr.categoria
INNER JOIN codigobarras cod ON cod.idproducto = pr.id -- Probablemente devuelva mas de un resultados si tenes mas de un Codigo de Barra para un solo producto
WHERE 
p.numerodepreciodelista = 0 AND pr.eliminado = 0;

This query is functional, I mean I run it in the database server console and it answers correctly without errors, and quickly, this query is the answer to another question, the link to the question is below.

The dataset doesn't have any table loaded so far, but after loading this table, I need to add more, so I can't use datatable, I have to use if or if a dataset.

As you can see, in the code, when filling in the dataset, "listadodeproducto" gives the error (Could not be enabled...), I have tried everything but I can't find a solution.

All query details are in this question: stackoverflow

From already thank you very much

Hi how are things? I'm trying to perform a database query (MYSQL) and I need to optimize it to be as fast as possible, for now I've dropped from 2 seconds to 1.27, and it's still slow, Here are the tables that are inside the query:

Price table

CREATE TABLE `precios` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `porcentaje` DECIMAL(4,2) NOT NULL DEFAULT '0.00',
    `precio` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `precio2` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `ganancia` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `costo` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `idproducto` INT(11) NOT NULL DEFAULT '0',
    `numerodepreciodelista` INT(10) NOT NULL DEFAULT '0',
    `impuesto` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    `ingresosbrutos` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    PRIMARY KEY (`id`, `idproducto`)
)

Bar code table

CREATE TABLE `codigobarras` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `idproducto` INT(11) NOT NULL DEFAULT '0',
    `codigobarras` TEXT NOT NULL,
    `idrubro` INT(11) NOT NULL DEFAULT '0',
    `idpromocion` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
)

Product categories table

CREATE TABLE `categoriadeproductos` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `nombre` TEXT NOT NULL,
    `ganancia` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
    PRIMARY KEY (`id`)
)

Suppliers table

CREATE TABLE `proveedores` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `nombre` VARCHAR(50) NOT NULL DEFAULT '0',
    `descripcion` TEXT NULL,
    `domicilio` VARCHAR(50) NULL DEFAULT NULL,
    `localidad` VARCHAR(50) NULL DEFAULT NULL,
    `telefono` VARCHAR(50) NULL DEFAULT NULL,
    `fax` VARCHAR(50) NULL DEFAULT NULL,
    `codigo postal` VARCHAR(50) NULL DEFAULT NULL,
    `contacto` VARCHAR(50) NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
)

Products table

    CREATE TABLE `productos` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `nombre` TEXT NOT NULL,
    `categoria` INT(11) NOT NULL,
    `proveedor` INT(11) NOT NULL,
    `cantidad` DECIMAL(11,2) NOT NULL DEFAULT '0.00',
    `cantidadbultoabierto` DECIMAL(11,2) NOT NULL DEFAULT '0.00',
    `cantidadbultocerrado` DECIMAL(11,2) NOT NULL DEFAULT '0.00',
    `stockminimo` DECIMAL(10,2) NOT NULL DEFAULT '4.00',
    `fecha` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `codigobarras` VARCHAR(50) NOT NULL DEFAULT '',
    `imagen` BLOB NULL,
    `eliminado` TINYINT(1) NOT NULL DEFAULT '0',
    `especial` TINYINT(4) NOT NULL DEFAULT '0',
    `ingresosbrutos` DECIMAL(3,2) NOT NULL DEFAULT '0.00',
    `tipodeproducto` INT(11) NOT NULL DEFAULT '0',
    `ultimamodificacion` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `id` (`id`),
    INDEX `nombre` (`id`)
)

Now the query I am doing is the following

SELECT productos.id, productos.nombre as Nombre
, categoriadeproductos.nombre AS Categoria
, proveedores.nombre AS Proveedor 
, cantidad as Cantidad
, stockminimo AS 'Stock Mínimo'
, (precios.precio) AS Precio
, (precios.precio2) AS 'Precio %'
, (precios.costo) AS 'P. costo'
, (precios.ganancia) AS Ganancia
, ultimamodificacion AS 'Fecha última modificación'
, (select codigobarras.codigobarras From codigobarras WHERE codigobarras.idproducto = productos.id LIMIT 1) AS 'Código de Barras' 
FROM productos INNER JOIN (precios, proveedores, categoriadeproductos) ON  proveedores.id = productos.proveedor AND categoriadeproductos.id = productos.categoria AND precios.idproducto = productos.id WHERE precios.numerodepreciodelista = 0 AND productos.eliminado = 0;

It takes approximately always between 1.2 and 1.3 seconds. The explain of the query is as follows:

+------+--------------------+----------------------+--------+-------------------+---------+---------+---------------------------------+------+--------------------------------------------------------+
| id   | select_type        | table                | type   | possible_keys     | key     | key_len | ref                             | rows | Extra                                      |
+------+--------------------+----------------------+--------+-------------------+---------+---------+---------------------------------+------+--------------------------------------------------------+
|    1 | PRIMARY            | precios              | ALL    | NULL              | NULL    | NULL    | NULL                            | 2073 | Using where                                      |
|    1 | PRIMARY            | productos            | eq_ref | PRIMARY,id,nombre | PRIMARY | 4       | sistema_tpv2.precios.idproducto |    1 | Using where                                      |
|    1 | PRIMARY            | proveedores          | ALL    | PRIMARY           | NULL    | NULL    | NULL                            |    2 | Using where; Using join buffer (flat, BNL join)        |
|    1 | PRIMARY            | categoriadeproductos | ALL    | PRIMARY           | NULL    | NULL    | NULL                            |    3 | Using where; Using join buffer (incremental, BNL join) |
|    2 | DEPENDENT SUBQUERY | codigobarras         | ALL    | NULL              | NULL    | NULL    | NULL                            | 1926 | Using where                                      |
+------+--------------------+----------------------+--------+-------------------+---------+---------+---------------------------------+------+--------------------------------------------------------+

Explanation of the query

The query makes a list of all the products found in the database. Each product comprises a category and a supplier, which are pointed to the subsequent tables with their ID or Index. This part is quite optimized, but the complication is with the prices, each product has a cost, a price, a fractional price (price2), a profit based on the cost (profit), and in the prices table, there is the PRODUCTID field that refers to the product , and for each product there may be several prices. Each price is identified by LISTPRICENUMBER, by default it is 0 which is the basic one, and in the query I am only interested in showing this. then in the WHERE I put numberoflistprices = 0. And finally for each product there is a barcode (codigobarras) that can be more than one for each product, and for this reason I have to limit it to 1, as it is in the query, each barcode refers to the product for which PRODUCTID field. In the query I used inner join, as you can see, but I couldn't optimize it for more than 1.20 sec. I hope to find a better way! thanks since now

CLARIFICATION: All Tables are secondary to Products. Secondary tables:

Barcode

Codigobarras contains the product barcode. The idproduct field refers to the id of each product. There can be more than one barcode per product, that is, a product can have more than one barcode.

Prices

prices contains the prices of each product. The productid field refers to the product id. The prices must have as a condition numberoflistprice = 0, because the other prices do not interest me in this query.

Categories

Each product has a category, and in the products table the category field refers to the id of the category to which it belongs

providers

Like categories, each product belongs to a provider and each provider has an id, and the provider field refers to this.

In suppliers and categories there are only 3 records for each table in prices and barcodes there are the same number of records as products, maybe more and products have 2800 records

Here the base sql that I have file.sql