Collections:
Show All Columns of an Existing Table in MySQL
How To Get a List of Columns in an Existing Table in MySQL?
✍: FYIcenter.com
If you have an existing table, but you don't remember what are the columns used in the table, you can use the "SHOW COLUMNS FROM tableName" command to get a list of all columns of the specified table. You can also use the "DESCRIBE tableName" command, which gives you the same output as "SHOW COLUMNS" command. The following tutorial script shows you a good example:
mysql> SHOW COLUMNS FROM tip; +-------------+--------------+------+-----+---------+------- | Field | Type | Null | Key | Default | Extra +-------------+--------------+------+-----+---------+------- | id | int(11) | NO | PRI | | | subject | varchar(80) | NO | | | | description | varchar(256) | NO | | | | create_date | date | YES | | NULL | +-------------+--------------+------+-----+---------+------- 4 rows in set (0.04 sec)
⇒ Show CREATE TABLE Statements of Existing Tables in MySQL
⇐ Show All Tables in a Database in MySQL
2018-03-10, 1959🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...