Execute Select in any Mysql Database. Copy and Paste the below .saveResults

Enable Parameterized Query.

Execute the query and then Click on the Execute button when the parameters window comes up.

You get the below NPE

 

SELECT * FROM superstore

GO

.saveResults 'Format=Excel,

        Source=Grid,

        File="/Users/tariq/Desktop/\&Region_ &t.xls",

        Overwrite=true,

        IncludeChart=false,

        IncludeHeader=true,

        IncludeNullText=false,

        IncludeRowCount=false,

        IncludeSQL=false,

        AlternateRow=false,

        AlternateRowBackground=#e8e8ff,

        AlternateRowForeground=#000000'

 

 

 

java.lang.NullPointerException

        at \\...\\ .\\हिñçêČάй語简??한\\.tꌂꍾꈭꆯ 5 synchronized.y(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.tꌂꍾꈭꆯ 5 synchronized.x(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.tꌂꍾꈭꆯ 5 synchronized.u(Unknown Source)

        at com.aquafold.datastudio.queryanalyzer.M⠟ꁖᛎꀟ catch abstract.LX(Unknown Source)

        at com.aquafold.datastudio.queryanalyzer.M⠟ꁖᛎꀟ catch abstract.b(Unknown Source)

        at com.aquafold.datastudio.queryanalyzer.M⠟ꁖᛎꀟ catch abstract.czW(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.Xꈰᠰꈻꍡ public if.a(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.a̹ᛓꎽ⢏ native.a(Unknown Source)

        at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)

        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)

        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)

        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

        at com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source)

        at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)

        at java.awt.Component.processMouseEvent(Component.java:6382)

        at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)

        at java.awt.Component.processEvent(Component.java:6147)

        at java.awt.Container.processEvent(Container.java:2083)

        at java.awt.Component.dispatchEventImpl(Component.java:4744)

        at java.awt.Container.dispatchEventImpl(Container.java:2141)

        at java.awt.Component.dispatchEvent(Component.java:4572)

        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619)

        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280)

        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210)

        at java.awt.Container.dispatchEventImpl(Container.java:2127)

        at java.awt.Window.dispatchEventImpl(Window.java:2489)

        at java.awt.Component.dispatchEvent(Component.java:4572)

        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:710)

        at java.awt.EventQueue.access$400(EventQueue.java:82)

        at java.awt.EventQueue$2.run(EventQueue.java:669)

        at java.awt.EventQueue$2.run(EventQueue.java:667)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

        at java.awt.EventQueue$3.run(EventQueue.java:683)

        at java.awt.EventQueue$3.run(EventQueue.java:681)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

        at java.awt.EventQueue.dispatchEvent(EventQueue.java:680)

        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)

        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)