Αποτελέσματα Αναζήτησης
In this tutorial, you will learn how to show columns of a table using the DESCRIBE statement and MySQL SHOW COLUMNS command.
Learn how to use SHOW COLUMNS to display information about the columns in a table or a view. See the syntax, options, output, and examples of this statement.
If you want to find the columns of a table inside the currently selected database, then you can do this: SELECT COLUMN_NAME FROM information_schema.columns WHERE TABLE_NAME = 'my_table' AND TABLE_SCHEMA = DATABASE();
Learn how to use the SHOW COLUMNS statement to list all columns of a table in MySQL, with or without the FULL keyword. See syntax, examples and output of the statement.
Obtaining column information can be useful in several situations like inserting values into a table (based on the column datatype), updating or dropping a column, or to just simply know a table's structure. In this chapter, let us understand how to use SHOW COLUMNS statement in detail.
Learn how to use SHOW COLUMNS to display information about the columns in a table or a view. See the syntax, options, output, and examples of this statement.
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. mysqlshow provides a command-line interface to several SQL SHOW statements. See Section 15.7.7, “SHOW Statements”. The same information can be obtained by using those statements directly.
