Questions tagged as 'mysql'

Tagged questions
2
answers

Date to String conversion in Pyhton

I'm trying to get a date from this next select in python select MAX(PAYMENT_DATE) from fact_cashflow WHERE DOCUMENT_ID = 'SALDO FINAL' and PAYMENT_AMOUNT > 0 But my answer on the console is this    (datetime.date (2017, 2, 1)) I w...
asked by 16.03.2017 / 19:19
1
answer

Error verifying user duplication

I wanted to prohibit the user from registering two identical users, type two equal emails or enrollment, but is still being registered data already exists, After I press register and send the data to the bank appears this error:    Notice: Un...
asked by 31.10.2018 / 20:50
1
answer

Create blog from scratch without using wordpress [closed]

I need to create a blog without using wordpres or any other ready structure, what language I can use and what is the fastest way to do it, the blog has a form that will save e-mail , nome completo and ip da pessoa , I already...
asked by 04.10.2017 / 06:25
1
answer

How to handle Null records? In the bank or app? (java & mysql)

I'm integrating a legacy (MySQL) database with a new module (Java - this problem-giving object is a bean) that I'm developing. I have a method that does a select and returns some results that possibly have some null data and thi...
asked by 25.04.2018 / 22:28
1
answer

Search in different tables knowing which came the result

I am trying to search for a term in 4 different tables in MySQL, using like , but I need to retrieve the id of each one and identify which table came to do the listing and direct with link. This is a search system where the result...
asked by 04.11.2016 / 16:22
1
answer

How to return the expected result in this query?

Good afternoon, guys. The case is as follows: I have a table with 2 blogs of category "automovel" and part of the title "Hackers" then whatever my query, can not return more than two results combining the "title" and "category" . Can you help me...
asked by 19.11.2016 / 15:26
1
answer

Error in the user registry, changing the user instead insert

My problem is the following, I saw that when I edit a registry, it works, the registry changes, but when I want to register a new user, it falls into the edit condition, it edits the registry information that I was changing previously , not allo...
asked by 09.11.2016 / 13:36
1
answer

What is the difference between primary key and index in mysql?

I wanted to know if there is any difference between primary key and index.     
asked by 28.02.2016 / 21:43
2
answers

No select error with PHP + MySQLi

I'm trying to use a query to pull a specific ID from another page. I can get ID through $_GET , I printed the query to see if it was right, even though it did not show me what error it was. Code: <?php $mys...
asked by 31.05.2016 / 06:21
1
answer

Remove spaces via Update

I have a field called titulo , in the noticias table. Unfortunately, due to forgetting PHP's trim command, it has several titles with space at the beginning and end of the string . How can I via SQL (MySQL) update the titles...
asked by 22.03.2016 / 16:01