MySQL Interview Questions

What is the difference between NOW() and CURRENT_DATE()? NOW() command is used to show current year, month, date with hours, minutes, and seconds while CURRENT_DATE() shows the current year with month and date only. What are the different column comparison operators in MySQL? The =, , <=, =, >, <>, , AND, OR or LIKE … Read more

What is MySQL data directory? MySQL data directory is a place where MySQL stores its data. Each subdirectory under this data dictionary represents a MySQL database. By default, the information managed my MySQL = server mysqld is stored in the data directory. How to clear screen in MySQL? If we use MySQL in Windows, it … Read more

What are the security alerts while using MySQL? Install antivirus and configure the operating system’s firewall. Never use the MySQL Server as the UNIX root user. Change the root username and password Restrict or disable remote access. What is the difference between the database and the table? There is a major difference between a database … Read more

What is REGEXP? 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 … Read more

How will Show all records containing the name “sonia” AND the phone number ‘9876543210’ mysql> SELECT * FROM tablename WHERE name = “sonia” AND phone_number = ‘9876543210’ How to Update database permissions/privilages. mysql> flush privileges; how to Return total number of rows mysql> SELECT COUNT(*) FROM tablename; How to dump one database for backup. # … Read more