Tutorial
Sintaxa SQL
SQL Tutorial » Sintaxa SQL
Care este sintaxa SQL?
O baz? de date con?ine de cele mai multe ori unul sau mai multe tabele. Fiecare tabel este identificat printr-un nume (de exemplu, „Clien?i” sau „Comenzi”). Tabelele con?in înregistr?ri (rânduri) cu date.
Toate instruc?iunile SQL încep cu oricare dintre cuvintele cheie precum SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW ?i toate instruc?iunile se termin? cu punct ?i virgul? (;).
De tinut minte este faptul ca SQL este case insensitive, adica "SELECT" inseamna acelasi lucru cu "select", dar numele tabelelor sunt case sensitive.Sintaxa SQL SELECT Statement:
SELECT coloana_1, coloana_2 .... coloana_n FROM nume_tabel;
Sintaxa SQL DISTINCT
SELECT DISTINCT coloana_1, coloana_2 .... coloana_N FROM nume_tabel;
SQL WHERE Clause
SELECT DISTINCT coloana_1, coloana_2 .... coloana_N FROM nume_tabel
WHERE CONDITION;
WHERE CONDITION;
SQL AND/OR Clause
SELECT DISTINCT coloana_1, coloana_2 .... coloana_N FROM nume_tabel;
WHERE CONDITION-1 {AND|OR} CONDITION-2;
WHERE CONDITION-1 {AND|OR} CONDITION-2;
SQL IN Clause
SELECT DISTINCT coloana_1, coloana_2 .... coloana_N
FROM nume_tabel
WHERE coloana_nume IN (val-1, val-2,...val-N);
FROM nume_tabel
WHERE coloana_nume IN (val-1, val-2,...val-N);
SQL BETWEEN Clause
SELECT DISTINCT coloana_1, coloana_2 .... coloana_N
FROM nume_tabel
WHERE column_name BETWEEN val-1 AND val-2;
FROM nume_tabel
WHERE column_name BETWEEN val-1 AND val-2;
SQL LIKE Clause
SELECT DISTINCT coloana_1, coloana_2 .... coloana_N
FROM nume_tabel
WHERE column_name LIKE { PATTERN };
FROM nume_tabel
WHERE column_name LIKE { PATTERN };
SQL ORDER BY Clause
SELECT DISTINCT coloana_1, coloana_2 .... coloana_N
FROM nume_tabel
WHERE WHERE CONDITION ORDER BY column_name {ASC|DESC};
FROM nume_tabel
WHERE WHERE CONDITION ORDER BY column_name {ASC|DESC};
Se va folosi punct ?i virgul? la sfâr?itul fiec?rei instruc?iuni SQL.
Online Editor
This tool makes it easy to create, adjust, and experiment with custom colors for the web.
HTML Templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.
CSS HTML Layout
Find here examples of creative and unique website layouts.
Free CSS HTML Menu
Find here examples of creative and unique website CSS HTML menu.