What is MySQL?
MySQL is an open-source relational database management system (RDBMS). It is the most popular database system used with PHP. MySQL is developed, distri...
Share
The mysqli_num_rows() function is an inbuilt function in PHP which is used to return the number of rows present in the result set. It is generally used to check if da...
Share
The BIN() function in MySQL is used to convert a decimal number to its binary equivalent.The BIN() function is equivalent to the CONV() function written in the format...
Share
Given a TABLE, in this TABLE, it prints entry of the table. If table is empty then it gives NULL.
Examples:
QUESTION : Given an employee table, print name from the gi...
Share
MySQL supports another type of pattern matching operation based on the regular expressions and the REGEXP operator.
It provide a powerful and flexible pattern match ...
Share
The RENAME USER statement can be used in MySQL if a MySQL administrator wants to change the username or the host of an existing MySQL user account without altering th...
Share
Granting Privileges
We have already learned about how to create user in MySQL using MySQL | create user statement. But using the Create User Statement only creates a...
Share
The LAST_DAY() function in MySQL can be used to know the last day of the month for a given date or a datetime. The LAST_DAY() function takes a date value as argument ...
Share
In MySQL, the user account password can be changed using 3 different statements:
UPDATE statement
SET PASSWORD statement
ALTER USER statement.
But before changing t...
Share
MySQL allows us to specify which user account can connect to a database server. The user account details in MySQL contains two information – username and host ...
Share