Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. stackoverflow.com › questions › 2177543MySQL - Using If Then Else in MySQL UPDATE or SELECT Queries

    1 lut 2010 · UPDATE table SET A = IF(A > 0 AND A < 1, 1, IF(A > 1 AND A < 2, 2, A)) WHERE A IS NOT NULL; you might want to use CEIL() if A is always a floating point value > 0 and <= 2

  2. www.geeksforgeeks.org › mysql-if-if-then-if-then-else-and-if-then-elseif-elseIF, IF-THEN, IF-THEN-ELSE and IF-THEN-ELSEIF-ELSE Statement -...

    21 sie 2024 · MySQL offers conditional control flow with IF statements, allowing us to execute blocks of SQL code depending on whether a condition is true or false. In this article, We will learn about What is Decision-Making in MySQL with different statements along with examples and so on.

  3. dirask.com › posts › MySQL-UPDATE-query-with-IF-condition-conditional-update-pOv4JDMySQL - UPDATE query with IF condition (conditional update)

    In this article, we would like to show you UPDATE query with IF condition in MySQL. Quick solution: UPDATE `table_name` SET `column_name` = IF(condition , if_true, if_false);

  4. www.w3schools.com › SQl › func_mysql_ifMySQL IF() Function - W3Schools

    Definition and Usage. The IF () function returns a value if a condition is TRUE, or another value if a condition is FALSE. Syntax. IF (condition, value_if_true, value_if_false) Parameter Values. Technical Details. More Examples. Example. Return 5 if the condition is TRUE, or 10 if the condition is FALSE: SELECT IF(500<1000, 5, 10);

  5. dba.stackexchange.com › questions › 198198mysql - How can I UPDATE multiple ROWs in a Single Query with...

    18 lut 2018 · You can use below one for one table if you want to update many columns of one table. UPDATE table SET col1 = CASE WHEN col3 = 'name1' THEN 'a' WHEN col3 = '2' THEN b ELSE 0 END , col2 = CASE WHEN col3 = '1' THEN 'b' WHEN col3 = 'name2' THEN 'c' ELSE '' END ;

  6. stackoverflow.com › questions › 15001217sql - Update MySQL with if condition - Stack Overflow

    21 lut 2013 · MySQL supports IF statement. UPDATE abbonamento SET punti = IF(tipo = 'punti', punti - 1, punti), bonus = IF(tipo <> 'punti', bonus - 1, bonus) WHERE id = 17 or you can also use CASE

  7. www.baeldung.com › sql › if-statement-where-clauseIncorporating IF Statements Within SQL WHERE Clauses - Baeldung

    4 sie 2024 · Moreover, we can provide three arguments to both functions, including the condition to execute, the return value if the condition is TRUE, and the value to return if the condition is FALSE. Furthermore, we can replace the IF() function with IIF() when using it in the MS SQL server.

  1. Wyszukiwania związane z mysql update if condition is false in one time in java

    mysql update if condition is false in one time in java programming
    mysql update if condition is false in one time in java with example
    mysql update if condition is false in one time in java 8
    mysql update if condition is false in one time in java code
    mysql update if condition is false in one time in java language
    mysql update if condition is false in one time in java error
    mysql update if condition is false in one time in java 10
    mysql update if condition is false in one time in java class
    mysql update if condition is false in one time in java 5
    mysql update if condition is false in one time in java 3
    mysql update if condition is false in one time in java 2
    mysql update if condition is false in one time in java 7
  2. Ludzie szukają również