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.

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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

Because I Learn CI and Jquery

Twitter Updates

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

%d bloggers like this: