IFERROR function in MySQL -

-

is there function iferror in mysql. example:

iferror(25/0,9)

i tried on phpmyadmin said such function iferror not exist. appreciate help

you can reach similar results ifnull:

if answer not valid, defaults null. ifnull give alternative answer:

your example (in case):

 select ifnull(25/0,9);

gives result: 9


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

jsf - How to order SelectItems in custom renderer extending MyFaces HtmlMenuRenderer -

-
i´m trying migrate custom component render selectonemenu on myfaces 2.0, need use library because 8.5 moved mojarra 1.2 myfaces 2.0 implementation. in mojarra 1.2, extended com.sun.faces.renderkit.html_basic.menurenderer had method renderoptions receives parameters facescontext context, uicomponent component, list<selectitem> listselectitems , myfaces haven´t similar method. this method used order items before render (mojarra 1.2): @override protected void renderoptions(facescontext context, uicomponent component, list<selectitem> listselectitems) throws ioexception { cobisselectonemenuuicomponent uicomponent = (cobisselectonemenuuicomponent) component; string order = uicomponent.getorder(); if (order == null || order.isempty()) { order = default_order; } if (order.equals("asc")) { collections.sort(listselectitems, comparatorselectitemlabel); } else { if (order.equals("desc")) { ...
Read more

sql server - SQL, get max id of column -

-
i've got table in ms sql server management studio +------+-----------+-------- | id | client id | bla bla blaaaa +------+-----------+-------- | 1 | 1 | ....... | 2 | 2 | ....... | 3 | 3 | ....... | 4 | 8 | ....... | 5 | 9 | ....... | 6 | 15 | ....... | 7 | 1 | ....... | 8 | 16 | ....... | 9 | 2 | ....... | 10 | 9 | ....... | 12 | 12 | ....... +------+-----------+-------- i need unique [client id] max value of [id], this +------+-----------+-------- | id | client id | bla bla blaaaa +------+-----------+-------- | 3 | 3 | ....... | 4 | 8 | ....... | 6 | 15 | ....... | 7 | 1 | ....... | 8 | 16 | ....... | 9 | 2 | ....... | 10 | 9 | ....... | 12 | 12 | ....... +------+-----------+-------- i tried code, doesn't work .. can me? select * table 1 inner join table 2 o...
Read more