Categories
MySQL

How to resolve error 1175 in MySQL Workbench

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 […]

Categories
MySQL PostgreSQL

Concat two strings in postgreSQL and MySQL

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 […]

Categories
MySQL

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 […]

Exit mobile version