How to get table structure in MYSQL?

Solved33.65K viewsApril 27, 2023Programmingaskquery html Mysql MYSQL QUERY MYSQLDATABASE

<img alt='' src='https://sp-ao.shortpixel.ai/client/to_auto,q_lossy,ret_img,w_50,h_50/https://codemylife.org/wp-content/uploads/nsl_avatars/24733cd84b67377be06d70f9e28c0cbb.jpg' srcset='https://sp-ao.shortpixel.ai/client/to_auto,q_lossy,ret_img/https://codemylife.org/wp-content/uploads/nsl_avatars/24733cd84b67377be06d70f9e28c0cbb.jpg 2x' class='avatar avatar-50 photo avatar-default' height='50' width='50' decoding='async'/>

Rishabh Raj 24 May 8, 2022

0 Comments

I have a table “tabe1” in “databases1” and want structure of it. How can I do this?
Please explain steps also.

Related

Question is closed for new answers.

Rishabh Raj Selected answer as best May 8, 2022

1

1 Answer

<img decoding="async" class="avatar" src="https://sp-ao.shortpixel.ai/client/to_auto,q_lossy,ret_img,w_50,h_50/https://codemylife.org/wp-content/uploads/2023/04/WhatsApp-Image-2023-04-04-at-17.48.25-150x150.jpg" width="50" height="50" alt="" />

Agastya 518 Posted May 8, 2022

1 Comment

Steps:
> use <database_name> ( use databases1 ) > desc or describe <table_name> ( desc table1)

Related

Code My Life - Official Changed status to publish April 27, 2023

<img alt='' src='https://sp-ao.shortpixel.ai/client/to_auto,q_lossy,ret_img,w_30,h_30/https://codemylife.org/wp-content/uploads/nsl_avatars/24733cd84b67377be06d70f9e28c0cbb.jpg' srcset='https://sp-ao.shortpixel.ai/client/to_auto,q_lossy,ret_img/https://codemylife.org/wp-content/uploads/nsl_avatars/24733cd84b67377be06d70f9e28c0cbb.jpg 2x' class='avatar avatar-30 photo avatar-default' height='30' width='30' decoding='async'/>

Rishabh Raj commented May 8, 2022

Thank you

1