MySQL – DESCRIBE Tables Table of content Describing a MySQL table refers to retrieving its definition or structure. When we describe a table, it basically includes the fields present, their datatypes, and if any constraints defined on them. We can get the information about the table structure using the following SQL statements − DESCRIBE Statement […]
Category Archives: mysql
MySQL – Add/Delete Columns Table of content A column in a table is a series of vertical cells that are used to store different types of data such as text, numbers, images, etc. Every column can contain one or more rows, where each row can store a single value. Adding Columns to a MySQL table […]
MySQL – Show Columns Table of content MySQL Show Columns Statement To retrieve entire information of a table, we use DESCRIBE, DESC or SHOW COLUMNS statements. All of these statements of MySQL can be used to retrieve/display the description of all the columns of a table, as they all retrieve the same result-sets. Obtaining column […]