I’ve bought Star Wars Battlefront 2. That’s not all… I’ve pre-ordered it. Did I know about the loot boxes? Yes. Do I care? Yes. So why am I still playing and didn’t get a refund like apparently the whole Reddit did? Because I like the game.
Add unique index to MySQL database
As of version 5.7 MySQL no longer support the keyword IGNORE for ALTER TABLE command, as it was an extension which was badly defined (more information here). Therefore it’s now impossible to use the old query that allowed to delete duplicates by creating a new UNIQUE INDEX and altering the table.
You work on a repository where the .gitignore file is defined globally and already tracked by git, but you have some files in your local directory that you don’t want to be tracked (logs, or build files, *.pyc etc.) and would like to ignore them (because who doesn’t like git status to show “working tree clean” or the status bar in zsh to be green).