Mysql returns all the table names of a database, column name data type remark _ MySQL
Source: Internet
Author: User
Mysql returns the names of all tables in a database, and the column name data type remarks bitsCN. comdesc 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 =? BitsCN.com
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.