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
Does php need html?
What are the types of variables in php?
Why php was called as personal home page?
What is the main difference between require() and include()?
If we login more than one browser windows at the same time with same user and after that we close one window, then is the session is exist to other windows or not? And if yes then why? If no then why?
why did u want to leave your past organisation?
What is c++ polymorphism?
Does facebook use php framework?
Can I learn laravel without php?
Explain me what are the differences between mysql_fetch_array(), mysql_fetch_object(), mysql_fetch_row()?
Should I learn php before wordpress?
What u mean by query?
What is a php 5?
What is serialization in php?
What is in php 7?