MySQL¶

Install MySQL server¶

brew install mysql

Download MySQL Community Server

apt-get install default-mysql-client

for mac

brew install --cask mysqlworkbench

for others, go to webpage and download

Try downgrading if there are some weird errors

mysql -u <username> -p'<pw>' -h <host> -P <port>

Notice there's no space after -p and port is specified with -P

\P less -Sin

Just type it

Use the ON DUPLICATE KEY UPDATE clause for upserting.

However, you cannot specify your own key to lookup, but only the a UNIQUE index or PRIMARY KEY will be checked.

ALTER TABLE table_name MODIFY COLUMN column_name ENUM('striker', 'center back');

Try downgrading