Questions tagged as 'sql-update'

Tagged questions
1
answer

Hashbytes with different values when doing select and save with update

SELECT HASHBYTES('MD5','123') This select above returns me the following result: 0x202CB962AC59075B964B07152D234B70 But when I do an update to the table using the same hashbytes UPDATE USUARIOSLOGADOS SET TOKENSESSAO = HASHBYTES('...
asked by 17.08.2016 / 22:38
2
answers

Trigger that accumulates the MySQL result

Given the following tables: Player ( id; name number; ) j team_ficticia ( id; userId; name; puntuacao_ficticia; ) ef team_fiction_player ( id; teamFicticiaId; pilotId; ) efj step ( id; local; year; state; ) and puntuacao_ficticia_...
asked by 31.07.2016 / 16:13
3
answers

Popular Modal Bootstrap for Edit User

Good morning, folks, I have a user screen with a list that was populated by a foreach, and each line has a link to edit the user. This link opens a modal that should already come with user information, but I'm having a hard time doing it. I'm...
asked by 19.07.2016 / 13:14
1
answer

Update table with data from another table by decreasing character

Hello, I have the BDMCOM1 bank that has a Product Balance table and a Quantity column with values like this: 1,000. However I have another bank BDMCOM1_V3_ALEA that also has the Product Balance table and Quantity column, but with values in this...
asked by 11.07.2016 / 16:08
2
answers

Update all table records with SQLiteDatabase.update ()

I have the following code to update a field in my table. I would like to know if I would like to change the "note" and "missing" fields in all the records in the table. Example: put all records with note = 8 and missing = 5 public void Upda...
asked by 31.03.2016 / 19:33
1
answer

Update multiple IDs at the same time

How to update multiple records at once with just one click with php / mysql? Example:     
asked by 24.08.2015 / 18:07
2
answers

SQLite Android Base Date Problem

So, my problem is this, I tried and researched everything but I could not implement any solution. I tried to update the database with the update and also insert new columns with ALTER TABLE, nothing worked. I am a beginner so please be specific...
asked by 26.07.2015 / 00:47
1
answer

Error in update "Call to undefined function mysqli_sql ()"

update returns the following error in the 1st result: Error:    Fatal error: Call to undefined function mysqli_sql () in F: \ XAMPP \ htdocs \ PAPBRUNO \ PAPBRUNO \ alter_cli_exe.php on line 21 My code: <?php $link = mysqli...
asked by 14.06.2015 / 21:21
2
answers

MySQL UPDATE multiple fields under the same condition (IF or CASE)

Friends, I need help. I have these 2 queries: UPDATE leilaov SET seconds = CASE WHEN (mesini = MONTH(NOW()) AND diaini = DAYOFMONTH(NOW()) AND horaini = HOUR(NOW()) AND minutoini <= MINUTE(NOW())) OR (mesini = MONTH(NOW())...
asked by 26.03.2015 / 19:57
0
answers

PDO - update, update values in Form with MySQL

This is a simple query for updating data from form_pag_atualizar.php . The insert and delete have already tested and are working, as well as bringing the information to the values of form_pag_atualizar.php , however at the time...
asked by 03.01.2019 / 11:43