Cacher is the code snippet organizer for pro developers

\!h Creates a basic table
CREATE TABLE artist (
artist_id SMALLINT(5) NOT NULL DEFAULT 0, -- fills columns
artist_name CHAR(128) DEFAULT NULL,
PRIMARY KEY (artist_id)
);

\!h The basic syntax:
-- <name> <type> [NOT NULL | NULL] [DEFAULT <value>]

\!h No warning if exists:
CREATE TABLE IF NOT EXISTS artist (...);