SQL Programmability with variables in SingleStore

select-into-var.sql

CREATE DATABASE IF NOT EXISTS acme;

USE acme;

CREATE TABLE IF NOT EXISTS messages (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  content varchar(300) NOT NULL,
  createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO messages (
  content
) VALUES (
  'select ... into @var'
);


-- Incorrect syntax:
--declare @id bigint;
-- Use this instead:
select 1 into @id;

-- Now use variables:
select id, content, createdate
from messages
where id = @id;

-- We can do this in queries as well:
select content, createdate into @content, @date
from messages
where id = 1;

select @content, @date;