SQL command in open office base create insert select update alter delete drop sql ddl dml commands
Join this channel to get access to perks:
/ @askindetail
To become member click this link friends.
SQL command in open office base create insert select update alter delete drop sql ddl dml commands
create table stud(id int,name varchar(10));
insert into stud values (1,'om');
select * from STUD;
select * from STUD where ID=1;
alter table stud add marks int;
update stud set marks=11 where id=1;
alter table stud drop marks;
delete from stud where id=1;
drop table stud;
0:13 What is SQL?
0:14 What is DDL?
0:15 What is DML?
0:16 How to insert values into new column field?
0:17 SQL command in open office base create insert select update alter delete drop sql ddl dml commands
0.50 create table command
1:21 insert values in table
2:33 select command
3:44 alter table commands
4:55 update table values command
5:66 delete record values from table
6:77 drop table command
0:21 SQL commands syntax & exaples:
0:22 create table stud(id int,name varchar(10));
0:23 insert into stud values (1,'om');
0:24 select * from STUD;
0:25 select * from STUD where ID=1;
0:26 alter table stud add marks int;
0:27update stud set marks=11 where id=1;
0:28 alter table stud drop marks;
0:29 delete from stud where id=1;
0:30 drop table stud;