Questions tagged as 'mysql'

Tagged questions
1
answer

Error 'Duplicate entry' 1 'for key' PRIMARY '"

I'm not sure how to do this, but I'm not sure how to do this. Duplicate entry '1' for key 'PRIMARY' Using the following code: mysql_query("INSERT INTO vendaproduto (id, id_venda, produtos) SELECT venda.id_venda, venda.id_venda, venda...
asked by 14.12.2015 / 13:59
1
answer

Is it possible to synchronize a mysql server with a local Firebird bank?

I'm new to web applications, and I have a MySql DBMS based site. What is the best way to synchronize the web bank with a local bank (where the bank is in a fixed ip)? The local bank is firebird.     
asked by 07.11.2015 / 15:42
3
answers

Select works on localhost but does not work on the server

The select was working normally in wamp, however when uploading the site to the server the information on some pages simply stopped coming. The only part where select is working is the login area of the administrative area, I ha...
asked by 02.10.2015 / 19:22
1
answer

How to put the current date and time in a datetime field? [closed]

I have a date field in a table that is of type datetime and I want to put the current date of my server. Ihavetriedeverything,withNOW()intheinsertionSQL,butthenIsawthatitdoesnotwork.IalreadytriedtochangetheDEFAULToffielddatetoCURREN...
asked by 19.01.2016 / 11:01
1
answer

Left outer Join does not have Null values [duplicate]

I have two tables: formulario_campo ( cod_campo, descricao, cod_formulario ) Filled with the following values - input_nome, Nome, 1 - input_sexo, Sexo, 1 The second table: — formulario_valor(cod_campo,valor,cd_oportunidade) In...
asked by 21.01.2016 / 14:40
1
answer

How to do a select beginning with a certain line

How do I get a Select starting with example from the second row of my table? I know that by using ASC limit 1,1 I can choose the second line, but how do I start from it?     
asked by 14.01.2016 / 16:47
1
answer

Is it possible to use IGNORE based on a field other than the PK, is it just a Single Index?

Considering the following modeling: ID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY PONTO INT (10) NOT NULL UNIQUE ENDEREÇO INT (10) NOT NULL (FOREIGN KEY) Where the ID field is an Auto Increment field, the PONTO field is a field...
asked by 04.11.2015 / 21:20
1
answer

Start / End of Summer Schedule: problem with date verification of type "greater than"

Every year I have two problems, one when summer time begins and the other when it's over. Anyway, yesterday the clock was delayed in an hour that created a giant problem. The page should allow the user to access it only with a time interva...
asked by 21.02.2016 / 13:15
1
answer

Handling Mysql error

I have an insert script and would like to be able to display the user a custom message for the following message trying to register an existing record: Duplicate entry '42-1' for key 'PRIMARY'. I tried to use some examples like: mysql_er...
asked by 22.02.2016 / 21:01
1
answer

Date from Mysql for Highcharts

Good I've been here a few days back from this subject until I got something, my only problem now and convert my graph I was reading through a CSV to now read directly from MYSQL My original graphic is this: <script type="text/javascr...
asked by 26.02.2016 / 12:09