MySQL / MariaDB SQL

Snippet na SQL don MySQL / MariaDB da ke amsa requests zuwa /pixel.gif da empty GIF, wanda ake decoding ɗinsa sau ɗaya lokacin farawa.

MySQL / MariaDB SQL

Path

Fayil: 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=='));

An duba shi da takardun bayani na yanzu na framework ɗin.

Shafin hukuma: MySQL / MariaDB

Ƙari a SQL

PostgreSQL
SQLite CLI