MySQL Workbench is a useful visualization tool for database architects, which provides similar features to PostgreSQL pgAdmin. Even though, that I am not a big fan of MySQL (I am a Postgres zombie 😉 ) , I cannot escape from it since it is widely used anywhere in any project. MySQL Workbench by default has […]
Category: MySQL
A category for MySQL related articles.
Recently, I have faced with the situation that I had to update one column value with the combination of two strings (one is another column string and the other one is a single word) for entire table. One way is to update each row manually but what if there are millions rows to update? In […]
MySQL basic commands
MySQL database is tightly coupled with Linux and in many extends it cannot be separated from Linux in my point of view. In this post I want to describe about some basic commands of MySQL. Note that MySQL also has GUI in Linux but I prefer to work in command and write command instead of […]