DDL - SQL Statement to drop table: Drop Table table_name; DDL - SQL Statement to create table: Creat Table table_name;
Posted: Thu Jul 14, 2022 2:13 pm
DDL - SQL Statement to drop table:
Drop Table table_name;
DDL - SQL Statement to create table:
Creat Table table_name;
DML - SQL Statement to insert a new row:
Insert Into table_name (column1, column2, column3, etc)
Values ( value1, value2, value3, etc) ;
DML - SQL Statement to retrieve all columns from all rows:
DML - SQL Statement to retrieve all columns from one row based on the primary key:
DML - SQL Statement to update two fields of one row based on the primary key:
DML - SQL Statement to delete one row based on the primary key:
Drop Table table_name;
DDL - SQL Statement to create table:
Creat Table table_name;
DML - SQL Statement to insert a new row:
Insert Into table_name (column1, column2, column3, etc)
Values ( value1, value2, value3, etc) ;
DML - SQL Statement to retrieve all columns from all rows:
DML - SQL Statement to retrieve all columns from one row based on the primary key:
DML - SQL Statement to update two fields of one row based on the primary key:
DML - SQL Statement to delete one row based on the primary key: