Questions tagged as 'mysql'

Tagged questions
1
answer

Problem connecting multiple CodeIgniter databases

I have an application where it connects to multiple databases, initially I use the database settings database.php . When I connect to another database, it still loads the settings from the database.php file, so I make the following connect...
asked by 02.03.2015 / 19:41
1
answer

ZIP format in Query - Mysql

In my bank column I have the CEP varchar (20) field, and a record: "92820142" is there any way to format in the default: 92.820-142 during the query? I tried to use the format, but conflicted in the data type.     
asked by 26.09.2017 / 17:19
2
answers

How does pagination done with PHP + AJAX?

I was browsing through the site looking for a functional example of pagination with AJAX + PHP, when I found this example Sorry for my ignorance, but the 'asynchronous loading' of AJAX causes me doubts .. However, I had a question: In th...
asked by 20.01.2016 / 15:52
2
answers

Avoid more than one record in the database

I'm having problems because I'm doing a community system where the user registers and shares stories. More when I was testing I clicked to register 2 times and 2 times it went to the database even with a checking function. MYSQL: CAMPO |...
asked by 22.11.2015 / 16:09
1
answer

Error importing CSV to phpMyAdmin

I need to import a .csv file into phpMyAdmin, but the special characters do not appear, nor the text that follows them. What could be the problem?     
asked by 16.05.2014 / 20:42
1
answer

Monitoring MySQL database with Java application

I have a Java desktop application w / DB MySQL running on 100 company branches for over 6 years. Today at the head office we need some information from the branch database. I'm developing a web service Rest, to perform this integration. The f...
asked by 05.08.2015 / 00:38
2
answers

Encryption with Java and PostgreSQL / MYSQL

Hello I have a question in my college project, in scope it says like this:  "Users and passwords can be stored in the database, using the bank's own encryption." Is the crypto in both default by MD5? In that case I need to use the MD5 crypto...
asked by 28.07.2015 / 19:16
1
answer

Index cardinality does not update

I'm creating a program that connects to a MySQL database online, and when I start it it creates a table with an index if it does not exist. To check if everything is ok I am analyzing the database by phpMyAdmin from the server, but when I che...
asked by 09.08.2015 / 02:59
2
answers

Combining column value with MySQL

I'm working on a report in MySQL where I need to show a percentage of various events that occurred with a group of entities. The structure of my table is as follows: | id | eventoA | eventoB | eventoC | eventoD | |----|---------|---------|-...
asked by 06.08.2015 / 18:51
1
answer

How to insert value returned in form fields with jQuery?

I need, after doing query on BD , to insert values returned in fields of a form, since I will use these fields to make a change in BD , the call to search is working correctly and is configured in this way, function BuscaDados...
asked by 08.09.2015 / 20:54