Hello guys, today, I am going to share one of the useful tips to find out how long a particular process is running in Linux. This is very useful while you are troubleshooting an issue and want to know whether your process or service is restarted fine on a daily or weekly basis. So you checked your process is running in Linux operating system and it's running fine, by using ps command. But now you want to know, from how long process is running, what is the start date of that process etc. Unfortunately, PS command in Linux or any UNIX based operating system doesn't provide that information.
How to create and call stored procedure in MySQL with IN and OUT parameters
It's hard to remember the exact syntax of, how to create a stored procedure in MySQL until you
are creating and working on stored procedure frequently, simply because the syntax
is not a one-liner. You need to remember the exact syntax if you are using the MySQL
database from the command line. What help, in this case, is, quick examples. In the last
couple of MySQL tutorial we have seen How
to find the second highest salary and How
to join 3 tables in one query; In this MySQL tutorial we will see a couple of
examples of creating stored procedure and calling stored procedure using IN and
OUT parameters. A
Top 6 SQL Query Interview Questions and Answers for Software Engineers and Data Scientists
SQL, a short form of Structured Query Language is one of the essential skills in today's programming world. No matter whether you are a Java developer, C++ developer or Python developer, you must know how to write SQL queries. Every programming job interview has at least one or two questions that require you to write SQL query for a given requirement and many developers struggle there. It's easy to answer theoretical questions like what is the difference between clustered and non-clustered index (see) or what is the difference between correlated and non-correlated subqueries (see), but when it comes time to actually write SQL queries to solve problems, it's not that easy, especially if you haven't done your homework and practice.
Subscribe to:
Posts
(
Atom
)
