SHARE
TWEET

Untitled

a guest Jul 22nd, 2015 229 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE IF NOT EXISTS `test` (
  2.   `field1` VARCHAR(50) NOT NULL,
  3.   `field2` INT(11) DEFAULT NULL,
  4.   `field3` INT(11) DEFAULT NULL,
  5.   UNIQUE KEY `unique1` (`field1`,`field2`),
  6.   UNIQUE KEY `unique2` (`field1`,`field3`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  8.  
  9. INSERT INTO `test` (`field1`, `field2`, `field3`) VALUES
  10.         ('test', NULL, NULL),
  11.         ('test', 1, NULL),
  12.         ('test', NULL, 1),
  13.         ('test', NULL, NULL),
  14.         ('testing', 1, NULL);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top