Banyangin jika punya bejibun kolom di table, malas hitung, pakai ini !

July 6, 2012 at 3:15 pm Leave a comment

SELECT count(information_schema.columns.column_name)
FROM   information_schema.columns
WHERE  information_schema.columns.table_schema = ‘NAMA DB’
AND    information_schema.columns.table_name = ‘NAMA TABLE’

Return dari script itu ada ‘Jumlah kolom (Integer)’.

Entry filed under: Database. Tags: .

Doing Something More ! A little bit poem, Send email via PHP with Xampp 1.7.3

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

Trackback this post  |  Subscribe to the comments via RSS Feed


Because I Learn CI and Jquery

http://api.jquery.com

http://www.grocerycrud.com

http://Zedwood.com

Twitter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

My FB page


%d bloggers like this: