SQL
TSQL, SQLCMD, EXEC, Procédure stockée, database mail...
Comparaison des bases de données relationnels
Installation de MySQL
sudo apt install mariadb-server
Désinstallation propre de MYSQL
Linux
- Arrêter le service mysql :
sudo systemctl stop mariadb sudo service mysqld stop
Si vous avez désinstallé les paquets mysql avant d'arrêter le service mysql :
> lsof -i TCP:3306
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 12629 mysql 17u IPv4 78816 0t0 TCP localhost:mysql (LISTEN)
> kill -9 12629
-
Désinstaller les packages mysql :
sudo apt purge mariadb-server mysql-server mysql-common mysql-client sudo apt autoremove sudo apt clean -
Supprimer les fichiers de config/database/log :
sudo rm -rv /var/lib/mysql /etc/mysql/ /var/log/mysql*
ENCODING
sql server unicode utf8 : https://sqlquantumleap.com/2018/09/28/native-utf-8-support-in-sql-server-2019-savior-false-prophet-or-both/ http://kunststube.net/encoding/ http://kunststube.net/frontback/ https://www.joelonsoftware.com/2003/10/08/the-absolute-minimum-every-software-developer-absolutely-positively-must-know-about-unicode-and-character-sets-no-excuses/
https://www.sqlshack.com/3-ways-to-improve-t-sql-performance/