Questions tagged as 'mysql'

Tagged questions
1
answer

Data not saved in the database

I'm using Java, JPA, PrimeFaces, Wildfly and Mysql, not much to see, but it's good to know. I fill in all the fields, all right the verification is performed. When I click on save the success message is displayed, but nothing is saved in the...
asked by 17.08.2016 / 22:02
2
answers

Select with inner join with CakePHP

I have a problem some time ago regarding a project I'm developing in cakephp , my view can not read a select with < in> inner join table. Controller: public function initialize() { $posts = $this->Post...
asked by 24.11.2015 / 12:26
0
answers

localhost / phpmyadmin / error 1146

I have a problem accessing phpmyadmin. Here is the error - >     
asked by 27.11.2015 / 20:40
0
answers

Error connecting to MySQL PDO

My Mac shut down from scratch and when you turned it back on, MySql stopped working. MySQL is installed by MAMP. You are giving this error when accessing only one site:    SQLSTATE [HY000] [2002] Can not connect to local MySQL server...
asked by 25.11.2015 / 15:13
1
answer

JSON API accents Restful [closed]

Good morning, I'm creating an API for studying, but I'm having some issues with accents. When I do a search, I have a response of not found. Below is a test. Would you have a solution for me to solve this situation? Q: Usi...
asked by 15.05.2016 / 17:53
1
answer

How to save String [] in MySQL

Hello, I would like to save a String[] in MySQL, but I do not know the type of datatype that saves String[] , nor what method I use to store this information.     
asked by 17.05.2016 / 18:52
1
answer

mysql error with foreign key

I'm creating a modeling but I'm stumbling on an error when I create foreign keys. MYSQL gives a "Can not add foreign key constraint" error. follow my sql. use fatec; create table aluno( ra int not null primary key, nome varchar(255), cida...
asked by 04.09.2016 / 01:37
0
answers

Login Function

Good afternoon I had a problem with my login script, it tells me that the email does not exist in the bank, the problem I always did this way, and now I have no idea what I did wrong Login function function login($conexao, $email, $senha...
asked by 30.05.2017 / 17:21
1
answer

Test data integrity using MySQL Transactions

I am using an ecommerce system where you use MySQL Transactions to maintain data integrity , for example in the simultaneous purchase of several customers of the same product where the system needs to decrease inventory and prevent it from bei...
asked by 05.09.2015 / 02:50
1
answer

Rows in Columns

I have the following result of a query : NOMECARACTERISTICA NOMEINFORMACAO Marca Samsung Marca ASUS Modelo E32 370E4K-KW3 Modelo X555LF My idea is to transform it a...
asked by 25.12.2016 / 16:08