Cashirka 2-aaad :Barashada Sql-ka Sida lo sameyo Database,Table,Insert,Update iyo Delete

Waxan cashirkan ku baran doona Sql-ka waxaan cashirkii hore ku so baranay qeybo kamid ah Koodka lkn maanta waa dhameystireyna si aan u galno Connection-ka.

Ogeysiiska cashirka
Cashirka 2-aad
So jediye:C/risaaq maxamed rashiid
Wixii su'aal ah kuso dir  :alaqsaa1996@gmail.com

Daawasho wacan Cashirkii 2--aad ee sql-ka

Codad-ka cashirka iyo sharaxaadooda:

Koodadka Sql-ka iyo waxa ay qabtaan

Create databse jaamacad :waa koodka lagu abuuro Databse

Note:hakuu doornaato  master

Create table student  (id  int,name  varcher(50),tel   int)     

waa koodka lagu abuuro table-ka

Note: Note:hakuu doornaato  database name jaamacad

Select * from  student:waa markaad rabto in aad soo kiciso Tableka

Insert into student values(‘10’,’rashka’,’06152315’) waxaa la adeegsadaa markaad rabto in aad tableka qoraal galiso

Update student set name=’muuse’where id=’10’  waxaa la adeegsadaa markii la rabo in table-ka wax laga badlo sida in la badalo magaca id ama tel-ka

Delete from student where id=’10’ waxa la adeegsadaa markii aad rabto in aad tirtitto hal row

Delete from student waxa la adeegsadaa markii aad rabto in aad tirtitto tableka rows-ka ku jiro dhano