<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=8047963799298605773&zx=b85e3874-2d58-4db2-a188-c43aa42130bb' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=8047963799298605773&zx=b85e3874-2d58-4db2-a188-c43aa42130bb' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

</head><body>*/</style>

Alias

BIKIN BALIK

10 Jun, 2023

Alias

MySQL memiliki fitur untuk melakukan alias untuk kolom dan tabel.

Alias berguna jika kita ingin mengubah nama kolom atau nama tabel ketika melakukan SELECT data.

Mungkin saat ini alias untuk tabel tidak terlalu terlihat gunanya, tapi nanti ketika kita telah mempelajari tentang JOIN, maka fitur alias untuk tabel sangat berguna sekali.

Alias untuk Kolom

Alias untuk Tabel

Add Comment

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/3257101978-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY62NadqWbzpzmgvDP16rshnjjWqOQ:1702108992438';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d8047963799298605773','//www.bikinbalik.com/2023/06/alias.html','8047963799298605773');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '8047963799298605773', 'title': 'Bikin Balik', 'url': 'https://www.bikinbalik.com/2023/06/alias.html', 'canonicalUrl': 'https://www.bikinbalik.com/2023/06/alias.html', 'homepageUrl': 'https://www.bikinbalik.com/', 'searchUrl': 'https://www.bikinbalik.com/search', 'canonicalHomepageUrl': 'https://www.bikinbalik.com/', 'blogspotFaviconUrl': 'https://www.bikinbalik.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-347565951', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Bikin Balik - Atom\x22 href\x3d\x22https://www.bikinbalik.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Bikin Balik - RSS\x22 href\x3d\x22https://www.bikinbalik.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Bikin Balik - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/8047963799298605773/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Bikin Balik - Atom\x22 href\x3d\x22https://www.bikinbalik.com/feeds/2282828353867890542/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/665cf296a76b54d3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Bagikan ke Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '2282828353867890542', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy8NyQ_4Szu78f8hJCy-G3B5wI3cPQE965ST_xX-5oRMU_3Ac9Tdaq5jEB40ZbKh6ySmC7ahBSA8EkOrmaupTnyXlyQJCfdO1qeJnIVB4NkAJ4kyjZIqEjzU4YUljYC8Hpm29UwxuGZGVUOruaHtsbQ1jsYPz0oxbPcEFFu7WCo8YSGaQTx8awzAHv/s72-w640-c-h360/alias.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy8NyQ_4Szu78f8hJCy-G3B5wI3cPQE965ST_xX-5oRMU_3Ac9Tdaq5jEB40ZbKh6ySmC7ahBSA8EkOrmaupTnyXlyQJCfdO1qeJnIVB4NkAJ4kyjZIqEjzU4YUljYC8Hpm29UwxuGZGVUOruaHtsbQ1jsYPz0oxbPcEFFu7WCo8YSGaQTx8awzAHv/w640-h360/alias.png', 'pageName': 'Alias', 'pageTitle': 'Bikin Balik: Alias'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Alias', 'description': 'Alias MySQL memiliki fitur untuk melakukan alias untuk kolom dan tabel. Alias berguna jika kita ingin mengubah nama kolom atau nama tabel ke...', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy8NyQ_4Szu78f8hJCy-G3B5wI3cPQE965ST_xX-5oRMU_3Ac9Tdaq5jEB40ZbKh6ySmC7ahBSA8EkOrmaupTnyXlyQJCfdO1qeJnIVB4NkAJ4kyjZIqEjzU4YUljYC8Hpm29UwxuGZGVUOruaHtsbQ1jsYPz0oxbPcEFFu7WCo8YSGaQTx8awzAHv/w640-h360/alias.png', 'url': 'https://www.bikinbalik.com/2023/06/alias.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 2282828353867890542}}, {'name': 'widgets', 'data': [{'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': 'Postingan Blog', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '2282828353867890542', 'title': 'Alias', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy8NyQ_4Szu78f8hJCy-G3B5wI3cPQE965ST_xX-5oRMU_3Ac9Tdaq5jEB40ZbKh6ySmC7ahBSA8EkOrmaupTnyXlyQJCfdO1qeJnIVB4NkAJ4kyjZIqEjzU4YUljYC8Hpm29UwxuGZGVUOruaHtsbQ1jsYPz0oxbPcEFFu7WCo8YSGaQTx8awzAHv/w640-h360/alias.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': ''}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML15'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'Registry Editor Windows', 'id': 7298720243852859375}, {'title': 'Website Scanner dengan Helium Simplify Vulnerability Assessment', 'id': 1151240651303869926}, {'title': 'Mengenal Bash Scripting Pada Sistem Operasi Linux atau Mac Os', 'id': 3356468837551829135}, {'title': '7 OSI Layer dan Mengenal Lapisannya', 'id': 3991629984693403362}, {'title': '6 Hal Harus Dilakukan Setelah Install Base Arch Linux', 'id': 4089387359020577369}, {'title': '6 Alasan untuk Beralih dari Google Chrome ke Mozilla Firefox', 'id': 4936008846179487497}, {'title': 'Hexagonal Architecture', 'id': 6230690467233468061}, {'title': 'Google Chrome vs Microsoft Edge: Manakah Peramban Windows 11 Terbaik?', 'id': 7482629483376178230}]}, {'title': '', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML1'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Jaringan Media', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList1'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2545059178-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3268905543-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML15', 'ads-post', document.getElementById('HTML15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'sidebar-static', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList1', 'footer-widget', document.getElementById('LinkList1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>