πŸ—„οΈ SQL

Podstawowe skΕ‚adnie i generator zapytaΕ„ dla 5 dialektΓ³w SQL

SELECT β€” pobieranie danych

MySQL 8.x
SELECT `id`, `name`, `email`
FROM `users`
WHERE `active` = 1
ORDER BY `name` ASC
LIMIT 10;
PostgreSQL 15+
SELECT "id", "name", "email"
FROM "users"
WHERE "active" = TRUE
ORDER BY "name" ASC
LIMIT 10;
MariaDB 10.x
SELECT `id`, `name`, `email`
FROM `users`
WHERE `active` = 1
ORDER BY `name` ASC
LIMIT 10;
T-SQL SQL Server
SELECT TOP 10
  [id], [name], [email]
FROM [users]
WHERE [active] = 1
ORDER BY [name] ASC;
PL/SQL Oracle
SELECT id, name, email
FROM users
WHERE active = 1
ORDER BY name ASC
FETCH FIRST 10 ROWS ONLY;

INSERT β€” wstawianie danych

MySQL 8.x
INSERT INTO `users`
  (`name`, `email`, `age`)
VALUES
  ('Jan', 'jan@mail.com', 30);
PostgreSQL 15+
INSERT INTO "users"
  ("name", "email", "age")
VALUES
  ('Jan', 'jan@mail.com', 30)
RETURNING "id";
MariaDB 10.x
INSERT INTO `users`
  (`name`, `email`, `age`)
VALUES
  ('Jan', 'jan@mail.com', 30);
T-SQL SQL Server
INSERT INTO [users]
  ([name], [email], [age])
VALUES
  ('Jan', 'jan@mail.com', 30);
PL/SQL Oracle
INSERT INTO users
  (name, email, age)
VALUES
  ('Jan', 'jan@mail.com', 30);

UPDATE β€” aktualizacja danych

MySQL 8.x
UPDATE `users`
SET
  `name` = 'Adam',
  `age` = 31
WHERE `id` = 5;
PostgreSQL 15+
UPDATE "users"
SET
  "name" = 'Adam',
  "age" = 31
WHERE "id" = 5
RETURNING *;
MariaDB 10.x
UPDATE `users`
SET
  `name` = 'Adam',
  `age` = 31
WHERE `id` = 5;
T-SQL SQL Server
UPDATE [users]
SET
  [name] = 'Adam',
  [age] = 31
WHERE [id] = 5;
PL/SQL Oracle
UPDATE users
SET
  name = 'Adam',
  age = 31
WHERE id = 5;

DELETE β€” usuwanie danych

MySQL 8.x
DELETE FROM `users`
WHERE `id` = 5;
PostgreSQL 15+
DELETE FROM "users"
WHERE "id" = 5
RETURNING "id";
MariaDB 10.x
DELETE FROM `users`
WHERE `id` = 5;
T-SQL SQL Server
DELETE FROM [users]
WHERE [id] = 5;
PL/SQL Oracle
DELETE FROM users
WHERE id = 5;

CREATE TABLE β€” tworzenie tabeli

MySQL 8.x
CREATE TABLE `users` (
  `id`         INT AUTO_INCREMENT PRIMARY KEY,
  `name`       VARCHAR(100) NOT NULL,
  `email`      VARCHAR(150) UNIQUE NOT NULL,
  `age`        INT,
  `created_at` DATETIME DEFAULT NOW()
) ENGINE=InnoDB
  DEFAULT CHARSET=utf8mb4;
PostgreSQL 15+
CREATE TABLE "users" (
  "id"         SERIAL PRIMARY KEY,
  "name"       VARCHAR(100) NOT NULL,
  "email"      VARCHAR(150) UNIQUE NOT NULL,
  "age"        INTEGER,
  "created_at" TIMESTAMP DEFAULT NOW()
);
MariaDB 10.x
CREATE TABLE `users` (
  `id`         INT AUTO_INCREMENT PRIMARY KEY,
  `name`       VARCHAR(100) NOT NULL,
  `email`      VARCHAR(150) UNIQUE NOT NULL,
  `age`        INT,
  `created_at` DATETIME DEFAULT NOW()
) ENGINE=InnoDB
  CHARSET=utf8mb4;
T-SQL SQL Server
CREATE TABLE [users] (
  [id]         INT IDENTITY(1,1) PRIMARY KEY,
  [name]       NVARCHAR(100) NOT NULL,
  [email]      NVARCHAR(150) NOT NULL UNIQUE,
  [age]        INT,
  [created_at] DATETIME2 DEFAULT GETDATE()
);
PL/SQL Oracle
CREATE TABLE users (
  id         NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  name       VARCHAR2(100) NOT NULL,
  email      VARCHAR2(150) NOT NULL UNIQUE,
  age        NUMBER(3),
  created_at TIMESTAMP DEFAULT SYSTIMESTAMP
);

Wybierz typ zapytania:

Parametry zapytania

Najpierw wybierz typ zapytania powyΕΌej.

📄 Wygenerowane zapytania
↑ Wybierz typ zapytania, a nastΔ™pnie wypeΕ‚nij pola