CodingForums.com - View Single Post

Old Pedant · 11-30-2012, 08:17 PM

When I use SHOW CREATE TABLE USERS on my created table, I see this:

Code:

mysql> show create table users;
+-------+-------------------------------------------
| Table | Create Table
+-------+-------------------------------------------
| users | CREATE TABLE `users` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `verified` tinyint(1) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-------------------------------------------

Man, your experience sure make me want to learn PHPMyAdmin....NOT!

11-30-2012, 08:17 PM	PM User \| #5
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,168 Thanks: 59 Thanked 3,992 Times in 3,961 Posts	When I use SHOW CREATE TABLE USERS on my created table, I see this: Code: mysql> show create table users; +-------+------------------------------------------- \| Table \| Create Table +-------+------------------------------------------- \| users \| CREATE TABLE `users` ( `userid` int(11) NOT NULL AUTO_INCREMENT, `verified` tinyint(1) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, PRIMARY KEY (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 \| +-------+------------------------------------------- Man, your experience sure make me want to learn PHPMyAdmin....NOT! __________________ 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.