Skip to content

Instantly share code, notes, and snippets.

@nullstyle
Created March 31, 2016 01:20
Show Gist options
  • Save nullstyle/07d1a902155eaeca8456da7e0375cddc to your computer and use it in GitHub Desktop.
Save nullstyle/07d1a902155eaeca8456da7e0375cddc to your computer and use it in GitHub Desktop.
CREATE DATABASE test;
SET DATABASE = test;
CREATE TABLE test (v DECIMAL);
INSERT INTO test VALUES (DECIMAL '1.0');
ALTER TABLE test ADD COLUMN v2 DECIMAL NOT NULL;
SELECT * FROM test;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment