MySQL学习足迹记录01--SOURCE,SHOW(二)

2014-11-24 16:39:14 · 作者: · 浏览: 1
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | orders | CREATE TABLE `orders` ( `order_num` int(11) NOT NULL AUTO_INCREMENT, `order_date` datetime NOT NULL, `cust_id` int(11) NOT NULL, PRIMARY KEY (`order_num`), KEY `fk_orders_customers` (`cust_id`), CONSTRAINT `fk_orders_customers` FOREIGN KEY (`cust_id`) REFERENCES `customers` (`cust_id`) ) ENGINE=InnoDB AUTO_INCREMENT=20010 DEFAULT CHARSET=latin1 | ....

9.其他SHOW命令
HELP SHOW;