Get a list of your functions in mysql

If you want a list of functions (as opposed to procedures) use this:

select * from information_schema.routines where routine_schema = 'your_schema_name' and routine_type != 'PROCEDURE'


Comments

Post a Comment

Popular posts from this blog

AutoCompleteTextView backed with data from SQLite in Android

Image
This is a handy piece of code. As your database gets bigger you can allow the user to pick the correct value by typing. If the db gets very big, you can always increase the threshold, so that the query does not run until there will be a suitably sized resultset returned. Running it at a threshold of 1 is fine for very small resultsets.  Here is the code you need to back your AutoCompleteTextView with a cursor adapter. @Override protected void onResume() { super.onResume(); text = (AutoCompleteTextView) findViewById(R.id.autoCompleteTextView1); final AdapterHelper h = new AdapterHelper(this); Cursor c = h.getAllResults(); startManagingCursor(c); String[] from = new String[] { "val" }; int[] to = new int[] { android.R.id.text1 }; CursorAdapter adapter = new MyCursorAdapter(this, android.R.layout.simple_dropdown_item_1line, c, from, to); adapter.setFilterQueryProvider(new FilterQueryProvider() { public Cursor runQuery(Cha...
Read more

Exporting drawings from Inkscape using the command line

Inkscape  has a command line that lets you do stuff in batch form. The most obvious use of this for an Android developer is to produce the various image resolutions required to support multiple devices on Android. This code opens inkscape, opens the drawing indicated (I created the $desktop variable to facilitate this) and then exports this drawing as a png file. $ inkscape --file=$desktop/inkscape-work/mystar.svg --export-png=$desktop/myfile.png -D The -D switch makes sure the whole drawing is exported, not just the page, or selected objects (you can select objects from the command line too). Width and height can also be provided, or you can give a resolution for the output. This is where the value will be for me. I will get this bit working next time I need multiple resolution drawings. Some of the command line options can be found here .
Read more

Using R to analyse data from the Central Statistics Office in Ireland

I started a Coursera course this week called Getting and cleaning data . I was looking at some data from the CSO and realised that I needed to clean it up. The course is good, but quite difficult. It assumes you have not forgotten everything you learned in the previous course, R Programming.    Mid way through week 2 (I am playing a bit of catchup) I stumbled across this package http://pxr.r-forge.r-project.org/ px is the format that the CSO releases its 'raw' data in. This package puts that into a data frame which is more amenable to analysis. I reckon there has to be something lurking within the CSO dataset which is one of my main motivations for getting up to speed on R.  Nothing to declare yet, but hopefully I will find something interesting soon :)
Read more