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:
DDL - SQL Statement to drop table: Drop Table table_name; DDL - SQL Statement to create table: Creat Table table_name;
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
DDL - SQL Statement to drop table: Drop Table table_name; DDL - SQL Statement to create table: Creat Table table_name;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!