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 table name; Use information_schemaselect * from columns where table_name = 'table name'; write down: 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) 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 the index logic is incorrect, add another field and 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: In this case, the pc_id, pac_name, and pac_value fields are not foreign keys. Otherwise, you must drop Foreign keys first, redo the previous step to obtain the column Name Data Type remarks.

Select column_name, data_type, column_comment from information_schema.columns where table_name =?