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, 2415🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...