Related questions

MySQL rows deleted on varchar column

2018-07-11 05:18 Sana Ullah imported from Stackoverflow

I have a situation where I am stuck. I want to delete all the records in a table of varchar column. The query is to be:

DELETE FROM table WHERE column = 'value'

But istead of this query I mistakenly executed the following query

DELETE FROM table WHERE column = 0

All the records in the table are deleted. Why? Any suggestion

See also questions close to this topic

  • Entry not added to database

    I would like to ask a help regarding my problem in thesis PHP programming. My problem is below code is not adding an entry to the database.

    $sqlRet = "SELECT * FROM tblbookcopy WHERE rId = '$roomno' AND (ciDate = '$checkin' OR coDate = '$checkout')";

    if (mysqli_num_rows($conn,$sqlRet) != 0){
        $Message = urlencode("ERROR");
        // header("Location:index.php?Message=".$Message);
        header("Location: ../ac-hotel/reservationform.php?Message=".$Message);
        die;
    }

    Willl you please enlighten me what I've missed. Thank you in advanced.

    Regards,

    Ray

  • The server encountered an unexpected condition that prevented it from fulfilling the request. when connecting a mysql in webapp

    i am using intellj idea and I am trying to connect a database with jsp in a webapp but this exception appears all the time. I am unable to insert/query data. I think database is not connected properly. please help me...

    I HAVE ATTACHED 2 PICS OF THE CODE AND THE EXCEPTIONS

    EXCEPTIONS

    jsp code

  • mariadb (ver.10.x.x) innodb locking? when concurrency occur

    i'm developer with mariadb using innodb i have a question about innodb.

    here test table

    column-> test_idx | test_num 
value ->    1001  |    0

    For example, when 50 clients have below query and start query at the same time.

    UPDATE 'test' SET test_num = test_num+1 WHERE test_idx=1;

    Does innodb has final value of 'test_num' column that is 50 ?