Author: admin
-
MySQL INSERT Statement
MySQL INSERT statement is used to store or add data in MySQL table within the database. We can perform insertion of records in two ways using a single query in MySQL: Syntax: The below is generic syntax of SQL INSERT INTO command to insert a single record in MySQL table: In the above syntax, we first have to specify…
-
MySQL Constraints
The constraint in MySQL is used to specify the rule that allows or restricts what values/data will be stored in the table. They provide a suitable method to ensure data accuracy and integrity inside the table. It also helps to limit the type of data that will be inserted inside the table. If any interruption…
-
MySQL Queries
A list of commonly used MySQL queries to create database, use database, create table, insert record, update record, delete record, select record, truncate table and drop table are given below. 1) MySQL Create Database MySQL create database is used to create database. For example 2) MySQL Select/Use Database MySQL use database is used to select…
-
MySQL Unlock Account
Unlock is a mechanism that allows the user to release all locks or any specific lock associated with the account. In this article, we will learn how to unlock the user accounts in the MySQL server. When the CREATE USER… UNLOCK statement creates a new user account, the new user stored as a locked state. If we want to…
-
MySQL Lock Account
A lock is a mechanism used to prevent unauthorized modifications into our database. It is essential to the security of our database. In this article, we are going to learn how to use the CREATE USER… ACCOUNT LOCK and ALTER TABLE… ACCOUNT LOCK statements for locking the user accounts in the MySQL server. We can lock the user accounts…
-
MySQL Table Locking
A lock is a mechanism associated with a table used to restrict the unauthorized access of the data in a table. MySQL allows a client session to acquire a table lock explicitly to cooperate with other sessions to access the table’s data. MySQL also allows table locking to prevent it from unauthorized modification into the same…
-
MySQL View
A view is a database object that has no values. Its contents are based on the base table. It contains rows and columns similar to the real table. In MySQL, the View is a virtual table created by a query by joining one or more tables. It is operated similarly to the base table but does not…
-
MySQL Rename Column
Sometimes our column name is non-meaningful, so it is required to rename or change the column’s name. MySQL provides a useful syntax that can rename one or more columns in the table. Few privileges are essential before renaming the column, such as ALTER and DROP statement privileges. MySQL can rename the column name in two…
-
MySQL Show Columns
Columns in the table are a series of cells that can stores text, numbers, and images. Every column stores one value for each row in a table. When we work with the MySQL server, it is common to display the column information from a particular table. In this section, we are going to discuss how…
-
MySQL Add/Delete Column
A column is a series of cells in a table that may contain text, numbers, and images. Every column stores one value for each row in a table. In this section, we are going to discuss how to add or delete columns in an existing table. How can we add a column in MySQL table?…