Answer Posted / ambika balasubramanian
DDL => Data Definition Language
DML => Data Manipulation Language
DDL Commands
1. CREATE TABLE
2. ALTER TABLE
3.DESCRIBE TABLE
4.DROP TABLE
* CREATE TABLE
Syntax:
create table tablename( fieldname1 datatype(),fieldname2
datatype()...);
*ALTER TABLE
1. ADD
2.MODIFY
*ADD
Syntax:
alter table tablename ADD(fieldname datatype()...);
*modify:
syntax:
Alter table tablename modify(fieldname datatype()...);
*DESCRIBE TABLE
Syntax:
DESC(table name)
*DROP TABLE
Syntax: DROP TABLE(Table name);
DML Commands:
1.INSERT
2.SELECT
3.UPDATE
4.DELETE
*INSERT:
SYN:
INSERT INTO Tablename values();
*SELECT:
syn:
select*from <table name>
*UPDATE:
SYN:
update<table name> set to(calculation);
*DELETE:
SYN:
delete form<table name>;
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
How many escape sequences are recognized in double-quoted strings in php?
How to remove duplicate values from array using php?
What is the difference between php and java?
What is orm in php framework?
Which is variable cost?
What does session start do in php?
Why echo is faster than print in php?
What is the functionality of the functions strstr() and stristr()?
What are the difference between overloading and overriding in oops?
What is the use of mysqli_real_escape_string() function?
How to Pass JSON Data in a URL using CURL in PHP?
What are the different ways to login to a remote server?
What are the functions used in php?
Explain how is it possible to set an infinite execution time for php script?
What is the phpstorm?