What command should I use to view the Mysql table structure? The following describes the commands for viewing the Mysql table structure in detail. If you have encountered a similar problem in the Mysql table organization, you may wish to take a look.
Run the following command to view the Mysql table structure:
Desc table name;
Show columns from table name;
Describe table name;
Show create table name;
Use information_schema
Select * from columns where table_name = 'table name ';
By the way:
Show databases;
Use Database Name;
Show tables;
The original unique index AK_PAS_Name (PAC_Name) is in the tb_webparamcounter table,
Run the following SQL statement to modify the index:
Alter table tb_webparamcounter drop index AK_PAS_Name;
Alter table tb_webparamcounter add UNIQUE AK_PAS_Name (PC_ID, PAC_Name );
If you find that the index logic is incorrect, you need to add another field to execute
Alter table tb_webparamcounter drop index AK_PAS_Name;
Alter table tb_webparamcounter add UNIQUE AK_PAS_Name (PC_ID, PAC_Name, PAC_Value );
Note: The PC_ID, PAC_Name, and PAC_Value fields are not FOREIGN keys.
Otherwise, you must first drop foreign key and then redo the previous step.
By the way, oracle
Select * from v $ database;
Select * from all_users;
Select * from user_tables;
Several common MySQL performance testing tools
MySQL queries tables with matching letters
MySQL table lock status and number of opened files
View the processes of the MySQL server
Mysql Key_buffer_size parameter settings