Computer Science, asked by tejaswinidixit2006, 1 day ago

Write the syntax of SQL commands as follow :INSERT,SELECT,CREATE,DELETE,UPDATE ​

Answers

Answered by r27272278
0

\huge\fcolorbox {magenta} {pink} {Hey mate here is the answer}

Syntax of insert

INSERT INTO table_name (column1, column2, column3, ...)

VALUES (value1, value2, value3, ...);

'2nd way

INSERT INTO table_name

VALUES (value1, value2, value3, ...)

Syntax of Select

SELECT column1, column2, ...

FROM table_name;

Syntax of Create

CREATE TABLE table_name (

column1 datatype,

column2 datatype,

column3 datatype,

....

);

Syntax of Delete

DELETE FROM table_name WHERE condition;

Syntax of Update

UPDATE table_name

SET column1 = value1, column2 = value2, ...

WHERE condition;

Similar questions