Questions tagged as 'mysql'

Tagged questions
1
answer

Select in Mysql and insert in Firebird [closed]

How to do a "select" in the Mysql / Mariadb database and "insert" the data collected in firebird (interbase).     
asked by 21.12.2016 / 19:51
1
answer

Populate graph with mysql data

I am developing a C # application and need to fill in a graph with the amount of data registered in 3 MySql tables. It is as follows: The graph should inform the user in different columns how much data are registered in the product tables, logse...
asked by 20.12.2016 / 15:00
1
answer

java.net.BindException: Address already in use /127.0.0.1:13444

I have an application running in the intagrator and today the system crashed, seeing the logs I came across this error: java.net.BindException: Address already in use /127.0.0.1:13444 at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpo...
asked by 04.02.2017 / 13:50
1
answer

calculate duration between 2 values within the input

Hello, I have a code in javascript that helps me to calculate the duration between one hour and another, I need to know how to make these values more dynamic, I want to put the input time in an input, the time of output in another input and the r...
asked by 25.02.2017 / 05:35
1
answer

Popular a select generated by javascript

I am copying fields from a form with javascript, but in this form two input are select and option are generated from the result of a query . When copies are created, query does not run, so select c...
asked by 23.02.2017 / 18:40
1
answer

Error trying to connect bd MSSQL Server using PDO [closed]

I can not access the MS SQL SERVER database using PDO. I've done everything, the best answer I got was with the code below, but I keep getting an error response:    Connection Error SQLSTATE [] (null) (severity 0) My server is CentOS 5.1...
asked by 04.01.2017 / 04:02
2
answers

Updating large amount of data in mysql

I have a MyISAM table with more than 200,000 records. From time to time I need to make a general update on the content. I create a new table and import ALL postings to the 'second' table in phpMyAdmin . So far so good. After that...
asked by 28.11.2016 / 16:39
1
answer

Problem with referential integrity in migrations (Laravel 5)

I have a problem using onDelete('set null') in a foreign key. You are returning the error:    [Illuminate \ Database \ QueryException]   SQLSTATE [HY000]: General error: 1215 Can not add foreign key constraint   (SQL: alter table u...
asked by 30.11.2016 / 16:59
1
answer

How to turn v-on: click="sync" into something automatic that is triggered when opening the html

Explaining the problem I have this javascript that in the html I call v-on:click="sync" it updates the news list, but this news list while I do not click on sync it goes blank, so I'm looking for a way to make v-on:click="sync"...
asked by 24.11.2016 / 23:01
2
answers

Is it possible, in MySQL, to update column information on multiple duplicate rows, leaving only one row with the original value?

For example, I have several rows in a table (which I pulled from an XML of google products, so the same product is presented several times, each for a clothing / product size) that are referenced for the same item, only with product size differe...
asked by 02.12.2016 / 19:11