how to use constants in SQL CREATE TABLE?
- by kchiu
Hi,
I have 3 SQL tables, defined as follows:
CREATE TABLE organs(
abbreviation VARCHAR(16),
-- ... other stuff
);
CREATE TABLE blocks(
abbreviation VARCHAR(16),
-- ... other stuff
);
CREATE TABLE slides(
title VARCHAR(16),
-- ... other stuff
);
The 3 fields above all use VARCHAR(16) because they're…