Mwongozo wa SQL

Maktaba ya Tathmini ya SQL kutoka CodeW3C.com. Inaweza kianzishwa, kwa ajili ya matumizi ya kila siku.

Tathmini ya SQL

Tathmini Maktaba ya Kiwango
AND / OR SELECT jina la kolumu (z)
FROM jina la tablica
WHERE maelezo
AND|OR condition
ALTER TABLE (add column) ALTER TABLE table_name
ADD column_name datatype
ALTER TABLE (drop column) ALTER TABLE table_name
DROP COLUMN column_name
AS (alias for column) SELECT column_name AS column_alias
FROM jina la tablica
AS (alias for table) SELECT column_name
FROM table_name　 AS table_alias
BETWEEN SELECT jina la kolumu (z)
FROM jina la tablica
WHERE jina la kolumu
BETWEEN value1 AND value2
CREATE DATABASE CREATE DATABASE database_name
CREATE INDEX CREATE INDEX index_name
ON table_name (column_name)
CREATE TABLE CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
.......
)
CREATE UNIQUE INDEX CREATE UNIQUE INDEX index_name
ON table_name (column_name)
CREATE VIEW CREATE VIEW view_name AS
SELECT jina la kolumu (z)
FROM jina la tablica
WHERE maelezo
DELETE FROM DELETE FROM table_name
(Umasikie: Mfuoza tablio kipofikia inayopita!!)

or

DELETE FROM table_name
WHERE maelezo
DROP DATABASE DROP DATABASE database_name
DROP INDEX DROP INDEX table_name.index_name
DROP TABLE DROP TABLE table_name
GROUP BY SELECT jina la kolumu1,SUM(jina la kolumu2)
FROM jina la tablica
GROUP BY jina la kolumu1
HAVING SELECT jina la kolumu1,SUM(jina la kolumu2)
FROM jina la tablica
GROUP BY jina la kolumu1
HAVING SUM(jina la kolumu2) maelezo value
IN SELECT jina la kolumu (z)
FROM jina la tablica
WHERE jina la kolumu
IN (value1,value2,..)
INSERT INTO INSERT INTO jina la tablica
VALUES (value1, value2,....)

or

INSERT INTO jina la tablica
(jina la kolumu1, jina la kolumu2,...)
VALUES (value1, value2,....)
LIKE SELECT jina la kolumu (z)
FROM jina la tablica
WHERE jina la kolumu
LIKE mbinu
ORDER BY SELECT jina la kolumu (z)
FROM jina la tablica
ORDER BY jina la kolumu [ASC|DESC]
SELECT SELECT jina la kolumu (z)
FROM jina la tablica
SELECT * SELECT *
FROM jina la tablica
SELECT DISTINCT SELECT DISTINCT jina la kolumu (z)
FROM jina la tablica
SELECT INTO
(inaunda kopi zingine za tables)		 SELECT *
INTO jina la tablica jipya
FROM jina la tablica asili

or

SELECT jina la kolumu (z)
INTO jina la tablica jipya
FROM jina la tablica asili
TRUNCATE TABLE
(hatarisha data zilizopo kwenye the table)		 TRUNCATE TABLE jina la tablica
UPDATE UPDATE jina la tablica
SET jina la kolumu=new_value
[, jina la kolumu=new_value]
WHERE jina la kolumu=some_value
WHERE SELECT jina la kolumu (z)
FROM jina la tablica
WHERE maelezo