MySQL / MariaDB SQL

Snippet SQL kanggo MySQL / MariaDB sing mangsuli request menyang /pixel.gif nganggo empty GIF, sing didekode sepisan nalika startup.

MySQL / MariaDB SQL

Path

File: pixel.sql

CREATE TABLE IF NOT EXISTS assets (
  name         VARCHAR(255) PRIMARY KEY,
  content_type VARCHAR(100) NOT NULL,
  body         BLOB NOT NULL
);

REPLACE INTO assets (name, content_type, body)
VALUES ('pixel.gif', 'image/gif', FROM_BASE64('R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw=='));

Wis dicocogake karo dokumentasi framework sing paling anyar.

Situs resmi: MySQL / MariaDB

Liyane ing SQL

PostgreSQL
SQLite CLI