Questions tagged as 'mysql'

Tagged questions
0
answers

DECLARE syntax-error in MySQL

I have this error that has to do with declare , and I tried many ways, but I can not fix it: declare '@i' int set @i = 1 while @i <=10 -- 1.000.000 filas begin insert into neptuno.varchar_variable_dcha select top (100000)...
asked by 12.06.2017 / 21:18
2
answers

How to join 2 fields of a table to only 1 field of another table?

I have 2 tables in my DB, one is "users" with the fields "id", "name" and "surnames" The second "sales" has the fields "id_venta" "id_vendedor" and "id_comprador" and what I want is to generate an html table in which the names and surnames of...
asked by 19.06.2017 / 08:30
1
answer

Doubt Goodby / csv component of the Packagist

I would like to know if anyone has used the component mentioned in the title (Goodby / csv) for PHP, because I have a problem with it. I explain, I am developing an application that manages software licenses where users are loaded by csv files t...
asked by 10.06.2017 / 21:33
0
answers

how to store any date in a java variable and save it in mysql

when sending it to the database I get the following error Data truncation: Incorrect date value: 'null' for column 'dateInscription' at row 1 the capture in visit1 String visit1 = request.getParameter ("txtVisita1"); and I send it to the databas...
asked by 18.06.2017 / 20:54
1
answer

Insert data in textfield through a database

Someone could tell me how I show data (from my database) in various textfield Here the search code:) public void buscar(String id_usu) { try { Object row[] = new Object[15]; conectar conexion = new conectar(); Conne...
asked by 10.06.2017 / 20:31
2
answers

How to populate listview with volley consultation

You can help me to populate a ListView of a query with volley + php + mysql in android studio . I leave the code for these classes, as you can see the content in a textView but I want to show it in a ListV...
asked by 07.06.2017 / 06:50
1
answer

Function Auth does not work for me in Laravel php

I did a manual authentication in Laravel 5.4 and I can not get it to return true the function. In my database, enter a record from the database administrator with username = admin and password = admin. (I also tried to create the username and...
asked by 07.06.2017 / 02:38
1
answer

I can not connect to my xampp database with an external device

I am developing an application that connects to a database hosted on my own PC, via Xampp. In my home I do not have an ADSL connection and I use the shared connection of the mobile phone. In Xampp I use port 8080 and 4433 as an alternative. When...
asked by 07.06.2017 / 05:01
0
answers

TRIM in mysql only works at start and end of the string

I have a field that has the following value RISARALDA Estación Pereira amaneció inundada It is with many unnecessary spaces, when I do a select TRIM () it does not...
asked by 20.06.2017 / 16:29
0
answers

Show selected combobox option with PHP

I have the following code which fills me a combobox with options brought from a database: <?php $conexion = mysqli_connect("localhost" , "root" , ""); $bd = mysqli_select_db ($conexion, "empresa"); $destinos = mysqli_query($co...
asked by 13.06.2017 / 23:39