MySQL database and table of the most basic command large inventory

Source: Internet
Author: User
Tags mysql mysql database

Are you really frustrated with the actual operation of getting the MySQL database and the table's most basic commands? If this is the case, the following article will give you the corresponding solution, the following article is mainly about the MySQL database and table of the most basic command of the program, the following is the specific description of the relevant content.

SELECT DATABASE (); Lists the currently selected database and displays NULL if no database is selected;

Show DATABASES; Lists the MySQL databases that are currently present on the server;

Use DatabaseName; Choose to access a database;

Show tables; Find out what tables the current MySQL database contains;

DESCRIBE TableName; Lists the structure of a table;

Show INDEX from TableName; Displays the index information in the table.

The above related content is to MySQL database and table of several basic command of introduction, hope you can have some harvest.



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.