Uyisebenzisa kanjani i-SQL Yenza iNkcazo yokuDala indawo yogcino lwedatha kunye neetafile

Kule posi siza kujonga indlela yokusebenzisa iSQL ukwenza ingxelo ukwenza isiseko sedatha kunye neetafile kwi-SQL. Ngaphambi kokuba sikwazi ukwenza itafile kunye nokongeza idatha, kufuneka kuqala senze isiseko sedatha.

I-SQL YENZA ISICWANGCISO SESIKHATHI

Ukwenza i-database kwi-SQL, kufuneka sisebenzise CREATE DATABASE umyalelo.

CREATE DATABASE dbname;

Umzekelo:

Ingxelo elandelayo ye-SQL yenza i-database ebizwa ngokuba yi 'ProductionDB'

CREATE DATABASE ProductionDB;

BONISA IZIKHOKELO

Ukubona idathabheyisi oyenzileyo kwaye ubone uluhlu lwedatha kwinkqubo, sisebenzisa SHOW DATABASES myalelo:

SHOW DATABASES;

SQL YENZA ISICWANGCISO SETABLE Syntax

Iitafile ziibhloko zokwakha zolwazi. Itheyibhile yedatha kulapho kugcinwa khona yonke idatha kwindawo yogcino lwedatha.

Ukwenza itafile kwi-SQL, kufuneka sisebenzise CREATE TABLE umyalelo.

CREATE TABLE table_name (
column_name1 datatype,
column_name2 datatype,
column_name3 datatype, .... );

ikholamu_amagama achaza igama leekholamu zetafile.

Uhlobo lwedatha luchaza uhlobo lwedatha enokubanjwa yikholamu (umz.Inani elipheleleyo, isicatshulwa, umhla, njl.

Phawula:Xa kusenziwa itafile kwi-SQL, kufuneka sichaze ikholamu yetafile amagama kwaye i uhlobo lwedatha baya kubamba.

Ezona ntlobo zedatha zixhaphakileyo ezisetyenziswayo zezi:

• CHAR
• VARCHAR
• TEXT
• DATE
• TIME
• TIMESTAMP

I-SQL YENZA UMSEBENZI WOMSEBENZI

CREATE TABLE employees (
EmployeeID int,
FirstName varchar(255),
LastName varchar(255),
Department varchar(255),
JoiningDate DATE );

Le khowudi ingentla idala itafile engenanto ebizwa ngokuba 'ngabasebenzi' eneekholamu ezintlanu.

Kwiikholamu ezichaziweyo, i-EmployeeID inokubamba kuphela amanani apheleleyo- Igama lokuQala, igama lokugqibela kunye neekholamu zesebe zinokubamba ukuya kuthi ga kubalinganiswa abangama-255.

UkujoyinaDate ikholamu ibambe uhlobo lomhla.