Skip to content

Tag Archives: mysql

Granting Privileges We have already learned about how to create user in MySQL using MySQL | create user statement. But using the Create User Statement… Read More
DATABASE() Function The DATABASE() Function in MySQL returns the name of the default or current database. The string or name returned by DATABASE() function uses… Read More
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… Read More
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()… Read More
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… Read More
The DROP USER statement in MySQL can be used to remove a user account along with its privileges from the MySQL completely.But before using the… Read More
MySQL allows us to specify which user account can connect to a database server. The user account details in MySQL contains two information – username… Read More
In MySQL, the user account password can be changed using 3 different statements: UPDATE statement SET PASSWORD statement ALTER USER statement. But before changing the… Read More
The WHERE Clause is used to filter only those records that are fulfilled by a specific condition given by the user. in other words, the… Read More
The MySQL UPDATE query is used to update existing records in a table in a MySQL database. It can be used to update one or… Read More
The DELETE query is used to delete records from a database table. It is generally used along with the “Select” statement to delete only those… Read More
The SQL SELECT statement is used to select the records from database tables. Syntax : The basic syntax of the select clause is – To… Read More
Prerequisites : MySQL introduction, Creating MySQL database INSERT INTO statement is used to insert new rows in a database table. Let’s see the syntax how… Read More
What is a table? In relational databases, and flat file databases, a table is a set of data elements using a model of vertical columns… Read More
What is a database? Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes… Read More

Start Your Coding Journey Now!