In this article, we have explained how to install MySQL on Ubuntu Server. This article contains 4 steps.
Install MySQL on Ubuntu:
Prerequisites:
1. Must have internet conneciton.
2. Make sure you are logged in as a user with sudo privileges
1. Update Index Package:
sudo apt-get update
In this article, we are going to see how to clear MySQL Screen in Linux. We ar going to clear the screen using two methods.
1. Using Ctrl+L command
2. Using \! clear command
1. Using Ctrl+L command Continue reading Clear MySQL Screen in Linux
In this article, we are going to get list of permissions granted to the user on a table in Sybase. We can get permissions on a table to user by using the stored procedure sp_helprotect.
Syntax:
sp_helprotect table_name, user_name
Continue reading Show all permission for a table to user in Sybase
In this article, we have divided into 5 steps:
1. Blocking Definition
2. Query to check blocking in Sybase
3. Get the showplan(query plan) in Sybase
4. Get the SQLText of Sybase process ID.
5. How to kill the Sybase process id which is causing blocking.
1. Blocking Definition:
“Blocking” means that one connection is holding a lock on a resource when another connection wants to read or write to it.
Continue reading How to check blocking Sybase