fork download
copy 
  1. CREATE TABLE IF NOT EXISTS stiri (
  2.     titlu TEXT PRIMARY KEY,                   -- Ensures the title is unique
  3.     continut_stire TEXT NOT NULL UNIQUE,      -- Content cannot be NULL and must be unique
  4.     data_publicare INTEGER DEFAULT 1556388672 -- Default UNIX timestamp
  5. );
Success #stdin #stdout 0.01s 5284KB
comments (?)
stdin
copy 
INSERT INTO stiri (titlu, continut_stire) VALUES ('News Title 1', 'This is the content of the first news item.');
SELECT * FROM stiri;
stdout
copy 
News Title 1|This is the content of the first news item.|1556388672
https://ideone.com/wbixR3
language:
SQLite (sqlite 3.27.2)
created:
3 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!