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

Which function would you use to replace a record in a database in php?

1085

---

What are the php variables?

1060

---

What are differences between PECL and PEAR?

1145

---

what is the current salary package in India for a PHP programmer who has 1.5 years experience

3029

---

How to create a session? How to remove data from a session?

1039

---

How do you execute a php script from the command line?

1121

---

Are php sessions secure?

1024

---

What are the encryption functions available in PHP?

1183

---

Explain briefly about a search-friendly site looks like?

961

---

How can you submit a form without a submit button?

1020

---

What are the features of php 7?

1136

---

How can we display information of a variable and readable by a human with php?

1008

---

How to redirect https to http url through .htaccess?

1022

---

What is env in laravel?

1074

---

Is it possible to remove the html tags from data?

965

---