Drop Rows From MYSQL Table

Discussion in 'Site & Server Administration' started by acevincie, Jun 9, 2012.

  1. #1
    I want to Drop Rows from MYSQL Table According to the Values in a Specific Row. Command to do this or do This visually?
     
    acevincie, Jun 9, 2012 IP
  2. SolidShellSecurity

    SolidShellSecurity Banned

    Messages:
    262
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    45
    #2
    You can do it visually from phpMyAdmin. Are you on a CPanel host?
     
    SolidShellSecurity, Jun 12, 2012 IP
  3. depert

    depert Peon

    Messages:
    38
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    DELETE FROM table_name WHERE NameColumn=SpecificValue
    Code (markup):
    Following example will delete a record into test_tbl whose test_id is 1.
    DELETE FROM test_tbl WHERE test_id=1;
    Code (markup):
     
    depert, Jun 12, 2012 IP