Ẓeṛ aɣbalu n MySQL

{{Databox}}
MySQL d yiwen unagraw n usefrek n taffa n yisefka tamasɣant.

S unagraw-a, nezmer ad nekles isefka n yiwen wahil sdaxel yiwet taffa. Deg taffa n yisefka, llant tifelwa anda ara yilin yisefka. Deg yiwet tfelwit llan yisefka yedduklen, amedya tafelwit “Udem” tezmer ad tesɛu isefka “Isem”, “Azemz n tlalit”, “Tansa”, atg.
Isem 	Azemz_n_Tlalit 	Tansa
Afrux 	10/02/2008 	1 aɣlad Asigna 00001 Igenni
Adeffu 	02/06/2008 	5 aɣlad Tibḥirt 00002 Akal

SQL (Structured Query Language) d yiwet tmeslayt n usihel s wayes yezmer yiwen ad yesteqsi yiwet taffa n yisefka. Ma nra ad nessin azemz n tlalit n yiwen isem-is Adeffu deg tfelwit Udem, nezmer ad naru s tutlayt SQL:
select Udem.Azemz_n_Tlalit from Udem where Udem.Isem = ‘Adeffu’;

Ad naf:
Azemz_n_Tlalit
02/06/2008

Iwakken ad nernu yiwen wudem deg tfelwit Udem, nezmer ad naru:
Insert into Udem values (’Tafunast’, ‘12/05/2008′, ‘25 aɣlad Adaynin 00005 Taddart’);

Tafelwit Udem teqqel:
Isem 	Azemz_n_Tlalit 	Tansa
Afrux 	10/02/2008 	1 aɣlad Asigna 00001 Igenni
Adeffu 	02/06/2008 	5 aɣlad Tibḥirt 00002 Akal
Tafunast 	12/05/2008 	25 aɣlad Adaynin 00005 Taddart

Akka, taffawin n yisefka, neḥwaj-itent iwakken ad nejmaɛ isefka n yiwen wahil neɣ n yiwen usmel Web sdaxel tifelwa. SQL d yiwet tmeslayt i taffawin n yisefka. MySQL d yiwen unagraw anda llant taffawin n yisefka.

Asmel unṣib : www.mysql.com