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 – Change Password Table of content MySQL provides an account to each user which is authenticated with a username and a password. The default account in MySQL is a root with no password (One can however set a password to the root using a statement). Similarly, other user-defined accounts can have passwords set explicitly […]