开发者

Difference SHOW INDEX, SHOW INDEXES and SHOW KEYS in MySQL

开发者 https://www.devze.com 2023-03-22 11:45 出处:网络
What\'s the difference between the SHOW INDEX, the SHOW INDEXES and the SHOW KEYS command in MySQL? If an开发者_如何学JAVAy. I get the same results.MySQL Doc

What's the difference between the SHOW INDEX, the SHOW INDEXES and the SHOW KEYS command in MySQL? If an开发者_如何学JAVAy. I get the same results.


MySQL Doc

They are synonyms.


As per MySQL documentations it is same :-

SHOW {INDEX | INDEXES | KEYS}
    {FROM | IN} tbl_name
    [{FROM | IN} db_name]

http://dev.mysql.com/doc/refman/4.1/en/show-index.html

0

精彩评论

暂无评论...
验证码 换一张
取 消