All Questions
4
questions
-1
votes
2
answers
105
views
Increment my variable in a database with UPDATE in PHP
I get the variable 'stock' from my database. I would like increment my variable with an update with this code:
$stock = $_POST['stock']
$nom = 'salade';
$req=("UPDATE ingredients SET stock=$stock+1 ...
2
votes
1
answer
2k
views
What will happen when i update table with same values again and again?
What will happen when i update table with same values again and again?
Ex :
update tblExample set Col1 =1214 where Id=17
lets assume i keep updating this record with same value without changing ...
2
votes
4
answers
74
views
UPDATE and SELECT
Why do I need the SELECT privilege on this:
UPDATE Sailors S SET
S.rating = S.rating - 1
While I don't need it for this query:
UPDATE Sailors S
SET S.rating = 8
0
votes
1
answer
682
views
Update Extended Properties of a Stored Procedure
Dummy in SQL here needing to update an extended property of a stored procedure. Can only find info on updating table contents, not properties.
Needing to send a query to a database from a C# function....