Questions tagged as 'mysql'

Tagged questions
1
answer

how to insert into the database a variable that brings an array?

I have a page that has a textarea and in this textarea the user will put a list of records and in that records I separate the strings with the function explode this is my html index.php code Active MTMs     #Login{         text-align:...
asked by 18.04.2016 / 00:07
2
answers

What command in Mysql that kills the process if a query takes more than 20s to execute?

Galera would like to know some configuration command in mysql, which kill the process if the query takes more than 30 seconds to return some result exists? how?     
asked by 18.04.2016 / 19:48
1
answer

Login with JAAS + Tomcat

I have done the JAAS configuration procedures in my JSF project, when I try to access it, it shows the information that user and password does not give, but I already created the user table. context.xml<Contextpath="/FastChoice"> <...
asked by 06.11.2015 / 17:33
1
answer

Error number 1064 CodeIgniter

An error is popping up when I log into my system:    Error Number: 1064       You have an error in your SQL syntax; check the manual that   correspond to your MySQL server version for the right syntax to use   near 'SET last_activity...
asked by 22.10.2015 / 20:10
1
answer

Number of rows changed by the user

I have some tables in a system and for all entries I do the validation and compare if the input is equal to what is currently defined in the table and I use PHP rowCount () to check if I had update and display the correct message for the user....
asked by 22.10.2015 / 21:48
2
answers

How to insert query result in mysql with python

I need to insert in the database the result of this query through the temperature module. The code is this. Temperature and humidity are already returning, but the values are not saved in the database. # Carrega as bibliotecas #!/usr/bin...
asked by 16.02.2016 / 19:15
1
answer

Problems with MySQL Server for OS X

Hello, Has anyone here been able to install MySQL Server for Mac? I installed it, but I can not start it! I click the button on his panel, he asks for the password, I type and nothing. I try for Terminal , it gets processed and t...
asked by 15.01.2016 / 19:16
1
answer

Uploading an entity Country related to State

I'm starting in the Entity Framework and when trying to load an entity state, the relational parent entity is coming with null value, what could I adjust in my code to solve? Class Status: public class Estado { ... public int Id { g...
asked by 14.01.2016 / 20:25
1
answer

Store Search by Zip Code

I'm developing a website with PHP and MySQL where I register several stores, and each store serves a region of the city. What would be the best strategy to adopt in this case, where I have CEP of the customer and want to check which is...
asked by 05.10.2015 / 04:42
2
answers

Set field to null - CodeIgniter

Hello, beauty? I am doing an update in a table and am sending the array of data. However, I have a date field. Every time I update, it sends the field as 'dtnascimento' = '' . When this data arrives in the database, my database hits t...
asked by 22.09.2015 / 20:09