CodingForums.com - View Single Post

Old Pedant · 12-06-2012, 10:28 PM

Here's an example of the name MySQL generates if you omit it. This is from SHOW CREATE TABLE:

Code:

CREATE TABLE `customers` (
  `custid` int(11) NOT NULL AUTO_INCREMENT,
  `coid` int(11) DEFAULT NULL,
  `custname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`custid`),
  KEY `coid` (`coid`),
  CONSTRAINT `customers_ibfk_1` FOREIGN KEY (`coid`) REFERENCES `countries` (`coid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

12-06-2012, 10:28 PM	PM User \| #19
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,187 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	Here's an example of the name MySQL generates if you omit it. This is from SHOW CREATE TABLE: Code: CREATE TABLE `customers` ( `custid` int(11) NOT NULL AUTO_INCREMENT, `coid` int(11) DEFAULT NULL, `custname` varchar(100) DEFAULT NULL, PRIMARY KEY (`custid`), KEY `coid` (`coid`), CONSTRAINT `customers_ibfk_1` FOREIGN KEY (`coid`) REFERENCES `countries` (`coid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.