Answer Posted / hrindows@gmail.com
DML is a short form for Data Manipulation Language which is used in data manipulation and mostly includes common SQL statements to store, modify, retrieve, delete and update data in a database.
The list of DML Queries:
SELECT
INSERT
UPDATE
DELETE
MERGE
CALL
EXPLAIN PLAN
LOCK TABLE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
What is mysql enterprise edition?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
Is mariadb better than mysql?
How do stored procedures work?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
What mysql means?
Create table employee (eno int(2),ename varchar(10)) ?
How do I view mysql logs?
List the different types of normalization?
How do I edit a table in mysql?
What is clob in mysql
How to calculate the difference between two time values?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
What is the use of concat() in mysql?