Questions tagged as 'mysql'

Tagged questions
0
answers

Stored procedure with Declare and Set phpmyadmin

I try to do a stored procedure by declaring a variable that stores a data, but apparently I have an error. Procedure: create procedure insertarempleado ( cedula varchar(10), pass varchar(15), nombre varchar(30), apellido varchar(30)...
asked by 09.07.2018 / 03:30
0
answers

How to do a procedure stored in mysql that inserts the id from one table to another?

How to do a procedure stored in mysql that allows to validate if a repeated data is found and if so to be able to register in two related tables otherwise insert only the id in a table? I have the following SQL script works if cc is not found...
asked by 06.07.2018 / 01:58
0
answers

ZEROFILL field in PHP

I require that the id ( id_servicios ) of my table servicios contain the attribute unsigned zerofill of MySQL, until here, everything is fine. The problem arises when I return the query data with PHP, the id_servicios returns a v...
asked by 06.07.2018 / 02:44
3
answers

Can not I update with Eloquent in laravel 5.6.25?

Hi, I'm trying to update Laravel, I'll leave my model and my controller, I'll even show the values in the log and if they are correct. My database is Mysql. This use in Ajax $.ajax({ type: 'PUT', url: 'posts/...
asked by 06.07.2018 / 04:11
0
answers

PHP JSON join 2 values

I'm creating a PHP to create a JSON and load a table where I can check the order records, where I have directions and directions to get separately. I want to be able to join those two columns to be able to put those results in a single column of...
asked by 12.07.2018 / 16:27
0
answers

How to use the "IF" statement with Mysql (JavaSwing)

I know I should learn a little more about java & MySQL, my apologies, but I need you to clarify this question or help me with a small code. What I want to do is the following: - I have a table of users but I want that when a user places h...
asked by 05.07.2018 / 01:57
0
answers

SQLSTATE [HY000] [2002] Can not connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")

A few hours ago mysql started to fall on my server. Restarted and hung up after a while. Now I can not even lift it, I get the error:    SQLSTATE [HY000] [2002] Can not connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'...
asked by 04.07.2018 / 10:17
0
answers

Insert incremental auto data mysql php according to foreign id

I have the following PHP code: if(!empty($_POST)){ if( empty($_POST['usuario_rut_administrador']) || empty($_POST['nombre_estacionamiento']) || empty($_POST['cantidad_cupos']) || empty($_POST['latitud'])...
asked by 05.07.2018 / 07:26
0
answers

Error in Java EE login

I'm trying to login to Java EE with a MySQL database. I am capturing the parameters from the form and sending them to a servlet as shown in the following code. index.jsp : <form action="./Login" method="post"> <div...
asked by 07.07.2018 / 01:46
0
answers

I want to fill a listview in Xamarin Android from a mysql server

As the title says, I need to fill a Listview from a mysql database, I have read and I was recommended to use JSON for a security issue, if someone gives me a tutorial link or explains how to do it (what programs should I use , etc) step by step...
asked by 03.07.2018 / 05:07