Menu
I would like to delete the first 100 rows or the last 100 rows in a certain table (ordered by the primary key).
Note: Lots of data is being spooled into this table.
353
For this, select your work area and click on the Filter button. Select the arrow next to the header of the temporary column and uncheck the checkbox next to '0'. Select all these rows, right-click and select “Delete”. Once again remove the filters by clicking on the Filter button.
Once the data is filtered, you can delete only the filtered rows by selecting the filtered data and pressing the "Ctrl" and "-" keys on your keyboard at the same time. This will open the "Delete" dialog box. Make sure that the "Shift cells up" option is selected and then click the "OK" button.
Simply select the rows or columns you want to delete, and then press the Ctrl+Shift+- keys on your keyboard. All of the selected rows and columns will be deleted. You can also use this shortcut to delete multiple cells. Simply select the cells you want to delete, and then press the Ctrl+Shift+- keys on your keyboard.
DELETE FROM table ORDER BY the field DESC|ASC limit 100 If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
