Isolation level is important DB parameter and this can be checked by using below query in MYSQL database. SELECT @@TX_ISOLATION; This will show the r…

In MySQL database we could have faced issue Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: and this will happen while running any …

In relational database we will link multiple tables with foreign key and unique key reference. How can we check any table linked with multiple tables thr…

In Mysql database we use MySQL connector to connect from java application. Till 5.7 of MySQL query_cache_size is supported but MySQL 8 this support is re…

How to find out number of records in each table of MySQL database?.We can do a count from each table but that was not a good solution.So below query is t…

In MySQL workbench we may execute many SQL queries. Some cases queries taking long time either due to bad index or number of records are more. In this ki…

MYSQL provides an option to rename the columns even after transaction happened in that table.Simple alter script will help to solve this problem. ALTER…

In MySQL Workbench by default we will not be able to download or see all the records available in the table. We will be able to see only 1000 records and…

Applications using oracle as a database in some scenario we used to get this error and there are several possible reasons for this exception. Conne…

In oracle database every error associated with an error code. In some times we might have encounter the situation database operation takes long time …

MYSQL is a open source database and which is used in many small and large scale applications. Below query is used to check the version of mysql databas…

Performance tuning can happen at many levels and one among them is tuning in database level. We need to know what are the queries are executing in data…