Questions tagged as 'mysql'

Tagged questions
1
answer

Two selects in a while with PDO

Hello, I'm migrating from MySQL to PDO and I'm having a hard time putting two selects in a table. try{ $CON = new PDO("mysql:host=localhost;dbname=tcc", 'root', '1234'); } catch (PDOException $e) { echo "Erro : ".$e...
asked by 05.06.2017 / 02:39
1
answer

Generate score of a table based on a scoreboard

I have a job to do SQL database I have the following problem ... I have in a GAMES table the columns    JOG_ID, MAJOR_ID_JOG_TIM, JOG_TIM_ID_VISITANT,   JOG_MANDANTE_PLACAR, JOG_VISITANTE_PLACAR explanation:    JOG_TIM_ID_MANDANT...
asked by 05.06.2017 / 00:15
2
answers

accent problem when saving to database [duplicate]

There is a problem with me, when I save a value in the database, it saves without any accent. All my code on the page is utf8, my whole database is utf8, the tables are utf8 and where the insert is utf8 When I put utf8_encode () in the c...
asked by 01.06.2017 / 14:04
1
answer

Hibernate gives insert but does not insert data into table

I have a visitor record in which I fill in the data (title and date), and hibernate executes when requesting "save" on the form. Here is the log when I ask to save in bank (MySql). 12:37:27.752 DEBUG org.hibernate.validator.internal.metadat...
asked by 15.06.2017 / 17:42
1
answer

Error inserting the result of a SELECT into tables of different MySQL databases

I am getting an error when generating a select and then giving an insert, I have 2 different banks but on the same server and I am giving a select in the database double_dir (source database) whose table is a record and giving an insert to the...
asked by 15.06.2017 / 01:56
1
answer

How to create a trigger that loopes in MySQL

In my database I have the following tables: module_user, module and control. I need to create a trigger that is executed after an insert in the table user_group. This trigger should make a select in the module table and create a loop that...
asked by 17.06.2017 / 19:38
0
answers

MySQL - VB - Connection Error

I have an error, when trying to connect to MySQL in a report accompanied by a ReportViewer is giving me the following error .. I have tried to create a user with all accesses in Workbench in the previous error but now I come across this o...
asked by 16.06.2017 / 23:09
2
answers

Login that compares user input with encrypted data in MySQL

I'm having trouble finding a way to compare the data entered by the user to a jPasswordField on the login screen and compare it with the encrypted password in AES and saved in the MySQL database. Can anyone help me? Save button code th...
asked by 17.06.2017 / 20:32
1
answer

Removing brackets from an array

You would need to remove the brackets from an impression of the results of an array within a While. Here is the code: <?php $termo = $_GET['termo']; include "conn.php"; //Consulta busca informações para montar auto-complete $sql = "SELEC...
asked by 14.06.2017 / 02:52
2
answers

Bulk change in MYSQL

Hi everyone, all right? I have a database in mysql and I need to make a bulk change, how? I want to change all the records in the "show_address" column of the ptv_osrs_properties table to "1". I have about 300 records, can I do this in...
asked by 31.05.2017 / 20:52