Unsupported Screen Size: The viewport size is too small for the theme to render properly.

how do I delete a record?

forums › forums › SQLyog › Using SQLyog › how do I delete a record?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 22, 2005 at 9:09 pm #8746
      leegold
      Member

      I looking around but do not see how to delete a (one row) record from a table. I see truncate but not how to delete a specific record from a table. Using ver 4.0 lite.

      Thanks

    • January 22, 2005 at 9:12 pm #16881
      CalEvans
      Member

      delete from table where primaryKey = keyToDelete?

      Or on smallish tables highlight the table, press F8 and check the box next to the record to delete. (This will only work if you have primary key defined.)

      =C=

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.