Do you have a headache in obtaining the most basic commands for MySQL databases and tables? The following article describes how to obtain the most basic commands for MySQL databases and tables.
Do you have a headache in obtaining the most basic commands for MySQL databases and tables? The following article describes how to obtain the most basic commands for MySQL databases and tables.
Select database (); list the currently selected databases. If no DATABASE is selected, NULL is displayed;
Show databases; list the existing MySQL DATABASES on the server;
USE databasename; select to access a database;
SHOW tables; find out the tables in the current MySQL database;
DESCRIBE tablename; list the structure of a table;
Show index from tablename; displays the INDEX information in the table.
The above content introduces several basic commands of MySQL databases and tables.