Advertisement
Guest User

Untitled

a guest
Apr 27th, 2012
592
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.22 KB | None | 0 0
  1.  
  2. mysql> SHOW CREATE TABLE users;                                                                                                                                        +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | TABLE | CREATE TABLE                                                                                                                                                                                                    |
  4. +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | users | CREATE TABLE `users` (
  6.   `uid` INT(10) NOT NULL AUTO_INCREMENT,
  7.   `fname` VARCHAR(255) NOT NULL,
  8.   `lname` VARCHAR(255) NOT NULL,
  9.   PRIMARY KEY (`uid`)
  10. ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 |
  11. +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  12. 1 ROW IN SET (0.00 sec)
  13.  
  14. mysql> SHOW CREATE TABLE follows;
  15. +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  16. | TABLE   | CREATE TABLE                                                                                                                                                          |
  17. +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  18. | follows | CREATE TABLE `follows` (
  19.   `user_id` INT(10) NOT NULL,
  20.   `follow_id` INT(10) NOT NULL,
  21.   KEY `user_id` (`user_id`,`follow_id`)
  22. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
  23. +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  24. 1 ROW IN SET (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement