Tuesday, March 29, 2016

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

0 comments:

Post a Comment