MySQL Basics In Pictures
Delete records
  1. Type:

    DELETE FROM name WHERE id>2;

    then press ENTER.

    The DELETE command deletes records that match the criteria you set.

    In this case, you told MySQL to DELETE from the table name any records WHERE the value for id is greater than 2.
  2. Type:

    SELECT * FROM name;

    then press ENTER.

    The table should now hold only these records: