How to rename table in MySQL
Renaming means changing the name of table after it has been created. Since this is a basic operation for a…
1 Min Read
How to know the current selected database in mysql
Requirement Knowing the current selected database becomes very important when there are more than one databases created and you want…
1 Min Read
How to force MySQL to take 0 as auto-increment value
Problem Suppose there is a column in a table which is set to auto-increment in MySQL. Now when you try…
2 Min Read
How to resolve “Can’t connect to local mysql server through socket /run/mysqld/mysqld.sock” in linux
Whey trying to connect to MySQL server on linux Operating system you might encounter an error Can’t connect to local MySQL…
1 Min Read
How to resolve “Select is not valid at this position for this server version, expecting ‘(‘, with” error in MySQL
If you use MySQL workbench, you might or already have encountered an error such as “Select is not valid at…
1 Min Read
How to resolve “com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure java.net.ConnectException: Connection refused” error
If you are facing this error, then it indicates that you are connecting to a MySQL database from a java…