How to return all table names and column data types of a database in Mysql
How to return all table names and column data types of a database in Mysql
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;
You can also
Use information_schema
Select table_schema, table_name from tables where table_schema = 'database name'
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.
Retrieve column name data type Remarks
SELECT COLUMN_NAME, DATA_TYPE, COLUMN_COMMENT FROM information_schema.columns WHERE table_name =?
