Category Archives: mysql

MySQL – CREATE VIEW Table of content MySQL views are a type of virtual tables. They are stored in the database with an associated name. They allow users to do the following − Structure data in a way that users or classes of users find natural or intuitive. Restrict access to the data in such […]

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 […]