Questions tagged as 'mysql'

Tagged questions
2
answers

Problem connecting to a mysql database hosted on a server with C #

Problem C # and Mysql My problem is that my application created in c # with the IDE Visual Studio 2017 sends me the following message:    unable to connect to any of the specified mysql hosts This problem arose since I moved my local d...
asked by 21.06.2017 / 07:49
2
answers

Define a default value to a double in mysql?

I have the following table: CREATE TABLE IF NOT EXISTS tab_gas_card ( id INT(11) NOT NULL AUTO_INCREMENT, vehicle_id INT(11) NOT NULL, folio VARCHAR(8) NOT NULL, nip VARCHAR(4) NOT NULL, date date NOT NULL, cost DOUBLE NOT NULL, amount DOUBLE...
asked by 21.06.2017 / 22:39
1
answer

Android Studio 2.3 error jdbc mysql connection

Hi, I have downloaded and installed Android Studio 2.3 and I want to make a connection to a remote mysql database. My version of java is the java version "1.7.0_121". I have pasted the file mysql-connector-java-6.0.5-bin.jar in the...
asked by 18.04.2017 / 12:02
1
answer

Help in SQL statement to update

I was creating a procedure but I came across an error in doing it. create procedure actualizar (in id int, in nom varchar(45), in corr varchar(45)) begin update dpersona set nombre=nom, correo=corr where idpersona=id; end In the part of 'i...
asked by 07.05.2017 / 21:11
1
answer

Problem with the permissions in phpMyAdmin

I am using phpMyAdmin as a database manager on my Centos server, despite having access to all of them, in the phpMyAdmin.conf . I have SELinux turned off. When trying to enter from my browser I get the following error:    Forbidden:...
asked by 07.05.2017 / 11:21
1
answer

How to group data from a related table in Laravel?

I want to group the records that have more than one related record. Example: I have a table called assignments and another table called sales, so an assignment can have a lot of sales. In the table assignments I have 2 records and in sales I...
asked by 08.03.2017 / 14:38
1
answer

how to create a switch case within a path in DATATABLES?

I'm painting the data brought from the database in datatables , the problem is that I need to validate a data to be able to paint a badge in the GUI , and I look for the way to do with a switch since if I use a if...
asked by 26.04.2017 / 16:21
1
answer

Problems with a trigger

Hi, I'm trying to make a trigger with a simple update. delimiter // CREATE TRIGGER 'reCalibrados' AFTER INSERT ON 'calibrationtbl' FOR EACH ROW BEGIN UPDATE calibrationtbl SET state='1' WHERE idInteva= (SELECT idInteva FROM...
asked by 17.02.2017 / 20:13
1
answer

Error in 'semicolon' sintaxys and expected input end

I would like help to solve this trigger that throws me errors in the VALUES line says    "syntax error: missing 'semicolon' ' And in the last line in the END appears    "syntax error: extraneus input found - expected end of input ......
asked by 20.02.2017 / 05:41
1
answer

Varchar as Primary Key

Hello I made a database based on a project I found on the Internet to do a REST.   The problem I have is that the Primary Key is type varchar and I can not auto-increment it since Mysql will not let me. I have to do the manual insertion....
asked by 29.01.2018 / 17:30