-
Data Manipulation Language (DML) statements Allow you to modify the contents of tables. There are three DML statements:
-
INSERT Allows you to add rows to a table.
-
UPDATE Allows you to change a row.
-
DELETE Allows you to remove rows.
-
Data Manipulation Language (DML) statements ?
PMA01:53
Categories: MySQL, MySQL-Interview-Questions
Related Posts:
What Is SQL? The Structured Query Language (SQL) is the most common way to retrieve and manage database information. An SQL query consists of a series of keywords that define the data set you want to fetch from the database. SQL uses… Read More
what is Triggers? A trigger is a stored database object that contains a series of SQL commands, set to activate automatically when certain events take place. Each trigger is associated with a table. You can create a trigger that will fire… Read More
How set a root password if there is on root password? # mysqladmin -u root password newpassword … Read More
Use mysqldump to create a copy of the database? mysqldump -h mysqlhost -u username -p mydatabasename > tgdbdump.sql … Read More
What is SERIAL data type in MySQL? BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT … Read More
Data Manipulation Language (DML) statements ? Data Manipulation Language (DML) statements Allow you to modify the contents of tables. There are three DML statements: INSERT Allows you to add rows to a table. UPDATE Allows yo… Read More
Data Definition Language (DDL) statements? Data Definition Language (DDL) statements Allow you to define the data structures, such as tables, that make up a database. There are five basic types of DDL statements: CREATE Allows you to cr… Read More
Show unique records mysql? mysql> SELECT DISTINCT column FROM table; … Read More
CSV tables? CSV tables are the special tables, data for which is saved into comma-separated values files and cannot be indexed. … Read More
What’s the default port for MySQL Server? 3306 … Read More
Restore database (or database table) from backup? [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql … Read More
total number of rows? mysql> SELECT COUNT(*) FROM table; … Read More
MySQL Subqueries? You can use the result of a query like you use a list of values with the IN operator to filter a query based on the result of another query. The subquery appears in parentheses after the IN keyword. The following query f… Read More
What Is a Relational Database? The basic concepts of a relational database are fairly easy to understand. A relational database is a collection of related information that has been organized into structures known as tables. Each table contains rows th… Read More
Data Control Language (DCL) statements ? Data Control Language (DCL) statements Allow you to change the permissions on database structures. There are two DCL statements: GRANT Allows you to give another user access to your database st… Read More