You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

15 lines
362 B
MySQL

-- DDL section
create table crm.product (
id numeric primary key,
title varchar(255) character set utf8
);
-- DML section
insert into product
values (1, 'Product1');
select count(*) from crm.product;
select id as ProductID, title as ProductName
from crm.product where id = :id;
\set content `cat data.txt`