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 to uploaded files to a table?

1000

---

am from coimbatore.am learning php&mysql. what will be the approx salary for me if i get a job in coimbatore.

2070

---

What is cookie and session in php?

949

---

Where is the submitted form data stored?

1079

---

How To Get the Uploaded File Information in the Receiving Script?

1033

---

Why php is used?

1099

---

Is multiple inheritance supported in php?

1011

---

What is the use of mysqli_real_escape_string() function?

917

---

How to write the form tag correctly for uploading files?

968

---

Can you define an argument as a reference type?

958

---

Tell me when a conditional statement is ended with an endif?

903

---

What are the method available in form submitting?

994

---

Is php dying 2018?

956

---

Please explain is it possible to use com component in php?

998

---

What are the methods of array in java?

954

---