{"flag":true,"single":true,"pageTitle":"Get all columns Name from Mysql for all tables","post":{"id":244,"user_id":"1","slug":"get-all-columns-name-from-mysql-for-all-tables-atp7","title":"Get all columns Name from Mysql for all tables","body":"<pre class=\"language-markup\"><code>select * from information_schema.columns\r\nwhere table_schema = 'your_db'\r\norder by table_name,ordinal_position<\/code><\/pre>","category_id":"23","is_private":"0","created_at":"2024-06-16T07:34:32.000000Z","updated_at":"2024-06-16T07:34:32.000000Z","category":{"id":23,"user_id":"1","name":"DATABASE","slug":"database-j4ss","parent_id":null,"created_at":"2023-05-26T03:25:05.000000Z","updated_at":"2023-05-26T03:25:05.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"select * from information_schema.columns where table_schema = 'your_db' order by table_name,ordinal_position - Get all columns Name from Mysql for all tables (Updated: June 16, 2024) - Read more about Get all columns Name from Mysql for all tables at my programming site [SITE]","categories":[]}