The INSERT INTO statement is used to insert new records in a table.
Syntax:-
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);
The DELETE statement is used to DELETE records in a table.
Syntax:-
DELETE FROM table_name
WHERE some_column=some_value;
The UPDATE statement is used to UPDATE records in a table.
Syntax:-
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
Syntax:-
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);
The DELETE statement is used to DELETE records in a table.
Syntax:-
DELETE FROM table_name
WHERE some_column=some_value;
The UPDATE statement is used to UPDATE records in a table.
Syntax:-
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
0 comments :
Post a Comment