×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: userc865b
Added: Aug 30, 2017 2:56 PM
Views: 1
Tags: mysql
get colums of tables
  1.         SELECT column_name,column_key
  2.         FROM INFORMATION_SCHEMA.COLUMNS
  3.         WHERE TABLE_NAME = tabelle AND SCHEMA='DB_NAME' // ansonsten werden alle Datenbaken durchsucht!
  4.         ORDER BY ordinal_position;