Редактирование: MySQL (раздел)

== DELETE ==

Don't even use. DELETE FROM ss13_player will delete the entire player log (forever). 

Here is an example of how to use it if you ever need to:

DELETE FROM ss13_player WHERE id = 6

The way you should handle this when making new databases is to include a 'deleted' column in a table. For example:

ss13_player: ckey, lastadminrank, firstseen, lastseen, deleted

Then, instead of using DELETE FROM ss13_player WHERE id = 6, you'd delete it by doing UPDATE ss13_player SET deleted = 1 WHERE id = 6.<br>
When selecting data from it, instead of doing SELECT * FROM ss13_player, you'd do SELECT * FROM ss13_player WHERE ISNULL(deleted)<br>
So you'd only 'effectively' be deleting them, they would however still remain in the database. This allows you to fix potential issues, allowing you to restore entries by editing the 'deleted' column. If you'd have used the DELETE statement, the data would be pretty much lost, if you hadn't previously backed it up.

=== In MySQL Workbench ===

In the menu on the left, expand the database (probably called 'feedback'), right click the table you wish to delete from, select 'edit table data', select any number of entries you wish to delete (don't have to select the entire row, just have something in the row selected), right click the selected area and select 'Delete Row(s)', select something else (so the 'Apply' button in the bottom right is enabled), hit the 'Apply' button and execute it. If you wish to see more examples of how DELETE works, you can see the statements it provides you with.


{{Contribution guides}}