Some useful MySQL queries for ready reference
Jan
31
2024
Finding non-unique values in a column: SELECT col_name, COUNT(col_name) FROM table_name GROUP BY col_name HAVING COUNT(col_name) > 1; ...
DetailsHow to integrate MySql database with Django?
May
07
2023
Download & install latest available version XAMPP. Remember MySQL will integrate with Django only with MariaDB 10.4 or ...
DetailsHow to disable MySQL Strict Mode
Aug
24
2021
Login to MySQL Server as ‘root’ user and run the following command. SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”))
DetailsAllow access to remote mysql server
Feb
09
2021
You have to put this as root: GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME’@’IP’ IDENTIFIED BY ‘PASSWORD’ with ...
DetailsHow to import very large MySQL database in XAMPP
Feb
02
2021
Certainly, this method is very helpful when you have a very heavy SQL file to be imported to ...
Details