Questions tagged as 'mysql'

Tagged questions
1
answer

Error: MySQL shutdown unexpectedly XAMPP

When I open XAMPP and click on Start MySQL, it gives me the following error, even though it used to work correctly    03:17:20 p.m. [mysql] Error: MySQL shutdown unexpectedly.       03:17:20 p.m. [mysql] This may be due to blocked port, miss...
asked by 05.06.2017 / 23:48
2
answers

How to insert multiple values of a checkbox in a table

I insert an array of a checkbox in a mysql table [seleccionael25] => Array ( [0] => Oximetros de pulso [1] => Linterna (Penlights) [2] => Repuestos Littmann [3] => Doppler fetal [4] =...
asked by 19.06.2017 / 03:35
1
answer

Error creating trigger with phpmyadmin

I have a problem when creating a trigger in phpmyadmin . This is my syntax in the definition field: DECLARE n_ubicacion VARCHAR(45) DEFAULT ''; IF (OLD.id_ubicacion <> NEW.id_ubicacion) THEN SELECT ubicacion INTO n_ubicaci...
asked by 07.06.2017 / 23:59
1
answer

Filtering in laravel with datatables does not work with mysql

I am using Laravel 5.3 and the latest version of the dataTables plugin. Before working with postgres, migrate to mysql for needs of the db, then I encounter a problem, the custom filtering throws me an error that is as follows:    SQLSTATE [H...
asked by 08.06.2017 / 21:49
1
answer

Connect a remote database in Laravel

I am developing an application with Laravel 5.2 and I must connect a remote database, to do it from the command line I type. mysql -u root -p -h 'remote_ip' --skip-secure-auth Doing this does not send any errors, I want to do this from L...
asked by 30.05.2017 / 00:59
1
answer

Store a date in java with the SET and GETTERS methods

my question is how can I store a date in a JFrame having a jDateChooser to select that date, I use the SET and GETTERS methods. My attribute of class Producto is Date fechaVencimiento which has the methods public Date getFechaV...
asked by 29.05.2017 / 04:24
3
answers

create a login system with php

I need to do a PHP login system, I found a page where there is a guide. This works well but I do not know if it is the most correct and safe way to create the login. link: PHP login creation guide database CREATE TABLE 'usuarios' (...
asked by 25.07.2017 / 03:47
1
answer

Doubt when performing an SQL query for an advanced search engine

Good afternoon. I am doing a website and a database for my practice, together with a colleague. Among the functions of the web, there is an advanced search engine, with several options. My problem arises in making a concrete query between...
asked by 16.05.2017 / 15:26
1
answer

Obtain data for the quarter and 10 days more

I need to be able to obtain the information of a mysql table corresponding to a quarter and the 10 days immediately following. Example, data for the first quarter of the year = January + February + March + 10 first days of April. I'm using th...
asked by 26.04.2017 / 18:48
2
answers

I try to get a certain row in MySQL but it returns a wrong value instead of the value I want to return

I would like to know how to get the row highlighted in red because I tried with this query and it returns the username: 15 and more: 2, the problem I have is that I do not know why it is returned to me by username: 21 SELECT idusuario,count(ca...
asked by 08.05.2017 / 00:56