How do I delete a row from a table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • diyasaini
    Junior Member
    • Feb 2014
    • 14

    How do I delete a row from a table?

    Hello friends,

    I want to know that How do I delete a row from a table in MySQL database ?
    Last edited by megri; 03-12-2014, 10:33 AM.
  • Guest

    #2
    It is very simple to delete the row from table.
    1. Select the row you want to delete.
    2. On the table menu point to delete and then click either rows

    Comment

    • deepika
      Member
      • Feb 2014
      • 44

      #3
      DELETE FROM EMP WHERE ID=1 AND NOT EXISTS(SELECT * FROM BAR WHERE ID=1)
      In the above example EMP and BAR are tables and I want to remove a record from EMP if it doesn't exists in bar.
      I Love Myself

      Comment

      • rohit
        Junior Member
        • Mar 2014
        • 11

        #4
        The delete statement is used to delete rows in a table
        DELETE FROM table name
        WHERE Customer Name=’rohit’;
        I Love Bookmarking

        Comment

        • stevex
          Member
          • Apr 2014
          • 74

          #5
          use the query :
          DELETE FROM table_name
          WHERE column=value;
          for e.g.
          DELETE FROM customers
          WHERE customer='ram';

          Comment

          • Guest

            #6
            You can delete it by the delete command.

            Comment

            • Daljeet
              Senior Member
              • Dec 2014
              • 205

              #7
              This is very simple way to delete.Firstly select row you want to delete then apply delete command.

              Comment

              • AmitSood
                Member
                • Oct 2015
                • 89

                #8
                You can use this syntax

                DELETE FROM table_name WHERE column_name=some_value

                Comment

                • sangeetanegi
                  Senior Member
                  • Dec 2015
                  • 140

                  #9
                  Thanks for sharing this information.

                  Comment

                  • shilparana
                    Senior Member
                    • May 2015
                    • 194

                    #10
                    It is so simple, select the row you want to delete then apply delete command.

                    Comment

                    • sapnathakur
                      Member
                      • Jan 2016
                      • 33

                      #11
                      Yes. its too easy to delete a row just Select the row you want to delete.

                      Comment

                      • sangeetanegi
                        Senior Member
                        • Dec 2015
                        • 140

                        #12
                        Delete columns and rows, right-click a row or column, and then click the command you want. You can also quickly add a row by clicking in the lower-right cell of the table pressing the Tab key.

                        Comment

                        • Swati walia
                          Senior Member
                          • Sep 2016
                          • 108

                          #13
                          It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact

                          DELETE FROM table_name;

                          or

                          DELETE * FROM table_name;

                          Comment

                          • Shubham Kumar
                            Junior Member
                            • Aug 2016
                            • 16

                            #14
                            Please confirm which database you are using.

                            so that I will let you know exact how to delete a row from a table ?

                            Thanks

                            Comment

                            Working...
                            😀
                            😂
                            🥰
                            😘
                            🤢
                            😎
                            😞
                            😡
                            👍
                            👎