priya

You can a create maximum of 16 indexed columns for a standard table. In MySQL, you can create an index with up to 16 indexed columns. This means you can include up to 16 columns in a single index definition. However, keep in mind that creating an index with too many columns might not always … Read more

REGEXP is a pattern match using a regular expression. The regular expression is a powerful way of specifying a pattern for a sophisticated search. Basically, it is a special text string for describing a search pattern. To understand it better, you can think of a situation of daily life when you search for .txt files … Read more

MySQL default port number is 3306. The default port number for MySQL is 3306.

Let us take a table named the employee. To find Nth highest salary is: select distinct(salary)from employee order by salary desc limit n-1,1 if you want to find 3rd largest salary: select distinct(salary)from employee order by salary desc limit 2,1 To display the nth highest salary from a table in MySQL, you can use the … Read more

Actually, both Unix timestamp and MySQL timestamp are stored as 32-bit integers, but MySQL timestamp is represented in the readable format of YYYY-MM-DD HH:MM:SS format. UNIX timestamps and MySQL timestamps are both used to represent points in time, but they differ in their formats and usage: UNIX Timestamps: UNIX timestamps, also known as epoch time … Read more