NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL Which method is best to select values present in one table but missing in another one? This: SELECT l.* FROM t_left l LEFT JOIN t_right r ON r.value = l.value WHERE r.value IS NULL ,this: SELECT [...]
Browsing Posts in MySQL
Resetting the root password of a MySQL database is trivial if you know the current password if you don’t it is a little tricker. Thankfully it isn’t too difficult to fix, and here we’ll show one possible way of doing so. If you’ve got access to the root account already, because you know the password, [...]
By default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server. You need type the following commands which will allow remote connections. Once connected you need to edit the MySQL server configuration file my.cnf. * [...]
