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>;

How do you check is php not empty?

1008

---

What is the meaning of a persistent cookie?

1131

---

What is the purpose of the '.myd' file extension? What do thes file contain?

992

---

What is == and === in php?

912

---

How do I start a php session?

997

---

Which variable declarations within a class is invalid in php?

980

---

What is properties of class?

1061

---

What is php trait?

977

---

Are objects passed by value or by reference?

994

---

Explain how does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?

996

---

What is difference between strstr() and stristr()?

1080

---

How many types of inheritances used in php and how we achieve it.

966

---

What is the difference between single quoted string and double quoted string?

1099

---

What is php explain?

957

---

What is the difference between the include() and require() functions?

1497

---