My mistakes

Mysql finding the informations about tables and its columns

Posted on: May 13, 2008

First, get the tablenames:

SELECT table_name,null FROM information_schema.tables

Second, get the columnnames:

SELECT column_name,null FROM information_schema.columns WHERE table_name = ‘tablename’

for more information use the below link

http://websec.wordpress.com/2007/11/17/mysql-table-and-column-names

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: