<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=8047963799298605773&zx=355b2792-9460-43e8-81f9-e45dec8d4fdc' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=8047963799298605773&zx=355b2792-9460-43e8-81f9-e45dec8d4fdc' 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>

Flow Control Functions

BIKIN BALIK

16 Jun, 2023

Flow Control Function

MySQL memiliki fitur flow control function.

Ini mirip IF ELSE di bahasa pemrograman.

Tapi ingat, fitur ini tidak se kompleks yang dimiliki bahasa pemrograman.

https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html

Menggunakan Control Flow CASE

Menggunakan Control Flow IF

Menggunakan Control Flow IFNULL

Add Comment

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/325989852-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY6IRFhMxM_bNQ1xizm2JBE2XSN-XQ:1701400059086';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d8047963799298605773','//www.bikinbalik.com/2023/06/flow-control-functions.html','8047963799298605773');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '8047963799298605773', 'title': 'Bikin Balik', 'url': 'https://www.bikinbalik.com/2023/06/flow-control-functions.html', 'canonicalUrl': 'https://www.bikinbalik.com/2023/06/flow-control-functions.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/8064752436491132448/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/20dab6d510b63eb9', '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': '8064752436491132448', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcYoffVdh9X6zpqUHMeYgLP5yZ2yWD29bDsTkTycJTjuMdIUyLTt_4DywmB2XlI5r4p3pkn8W06TAs_sb6CC0iyeZduxPP5gkyPxb6tbTOsMd_hOayaADB1irtbrAR9RsZptYdzUEKCLIQSTkkC_CHfiva21c-SZK_1lH0-bJ_4kEbXcIne1OR3bV8/s72-w640-c-h360/Flow%20Control%20Functions.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcYoffVdh9X6zpqUHMeYgLP5yZ2yWD29bDsTkTycJTjuMdIUyLTt_4DywmB2XlI5r4p3pkn8W06TAs_sb6CC0iyeZduxPP5gkyPxb6tbTOsMd_hOayaADB1irtbrAR9RsZptYdzUEKCLIQSTkkC_CHfiva21c-SZK_1lH0-bJ_4kEbXcIne1OR3bV8/w640-h360/Flow%20Control%20Functions.png', 'pageName': 'Flow Control Functions', 'pageTitle': 'Bikin Balik: Flow Control Functions'}}, {'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': 'Flow Control Functions', 'description': 'Flow Control Function MySQL memiliki fitur flow control function. Ini mirip IF ELSE di bahasa pemrograman. Tapi ingat, fitur ini tidak se ko...', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcYoffVdh9X6zpqUHMeYgLP5yZ2yWD29bDsTkTycJTjuMdIUyLTt_4DywmB2XlI5r4p3pkn8W06TAs_sb6CC0iyeZduxPP5gkyPxb6tbTOsMd_hOayaADB1irtbrAR9RsZptYdzUEKCLIQSTkkC_CHfiva21c-SZK_1lH0-bJ_4kEbXcIne1OR3bV8/w640-h360/Flow%20Control%20Functions.png', 'url': 'https://www.bikinbalik.com/2023/06/flow-control-functions.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8064752436491132448}}, {'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': '8064752436491132448', 'title': 'Flow Control Functions', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcYoffVdh9X6zpqUHMeYgLP5yZ2yWD29bDsTkTycJTjuMdIUyLTt_4DywmB2XlI5r4p3pkn8W06TAs_sb6CC0iyeZduxPP5gkyPxb6tbTOsMd_hOayaADB1irtbrAR9RsZptYdzUEKCLIQSTkkC_CHfiva21c-SZK_1lH0-bJ_4kEbXcIne1OR3bV8/w640-h360/Flow%20Control%20Functions.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': 'Cara Menghapus Pod Pada Kubernetes', 'id': 2387124698134691437}, {'title': 'Bingung Memahami DNS? Berikut Penjelasaan, Fungsi, dan Cara Kerjanya ', 'id': 6127892806278546664}, {'title': 'Resource Computer dan Command Prompt Windows', 'id': 6335079639861731820}, {'title': 'Registry Editor Windows', 'id': 7298720243852859375}, {'title': 'Pengecekan Pod Pada Kubernetes dengan Probe', 'id': 9066181993922912117}, {'title': 'Memahami File Log untuk Melihat Kejadian Pada Sistem Operasi Berbasis Linux', 'id': 1025066118060552645}, {'title': 'Menambahkan Annotation Pada Pod Kubernetes', 'id': 2006622627967296270}, {'title': 'Mengenal Ansible Automation Untuk Mengelola Server Yang Lebih Mudah', 'id': 4216293643703130594}]}, {'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/2258190084-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>