how to get mysql command line client not to print blob fields in select * -

-

exploring tables have blob fields. how select * command line client , have surpress printing (or truncate standard field width) blob fields rather scrolling bunch of binary junk on screen? mysql 5.1 client. want select * , not list of non-blob fields individually, development.

this can performed natively in mysql, it's quite unwieldy:

set @sql=concat('select ', (select group_concat(column_name)      information_schema.columns table_schema='test' , table_name='test'      , data_type!='blob'), ' test.test'); prepare preparedsql @sql; execute preparedsql; deallocate prepare preparedsql;

i prefer bash aliases/function mysql procedures they're more transportable between systems:

function blobless() {   cols=''   _ifs=$ifs   ifs=$(echo -en "\n\b")   col in $(mysql --skip-column-names -e "select column_name        information_schema.columns table_schema='$1' , table_name='$2'        , data_type not '%blob'");      cols="$cols,$col"   done   ifs=$_ifs   mysql -e "select $(echo $cols | cut -c2-) $1.$2 $3" }

invoke so:

[andy ~]# blobless test test "where id>0" +----+--------+ | id | t      | +----+--------+ |  1 | 123    | |  2 | 124213 | +----+--------+

if in mysql client console use ctrl-z suspend program , drop shell. use blobless db table check blobless data. fg restore suspended job (i.e. mysql client) foreground.

you can set default mysql connection details in ~/.my.cnf (howto) save having supply host/user/pass on command line - used bash functions.


Comments

Post a Comment

Popular posts from this blog

c++ - Convert big endian to little endian when reading from a binary file -

-
this question has answer here: how convert between big-endian , little-endian values in c++? 28 answers i've been looking around how convert big-endian little-endians. didn't find solve problem. seem there's many way can conversion. anyway following code works ok in big-endian system. how should write conversion function work on little-endian system well? this homework, since systems @ school running big-endian system. it's got curious , wanted make work on home computer also #include <iostream> #include <fstream> using namespace std; int main() { ifstream file; file.open("file.bin", ios::in | ios::binary); if(!file) cerr << "not able read" << endl; else { cout << "opened" << endl; int i_var; double d_var; while(!file.eof()) {...
Read more

linq to sql - Linq2EF: Return DateTime with a TimeZone Offset -

-
our database has times stored utc, , know user's current timezone, want return relative that. want incorporate offset in linq projection so: var users = u in this.context.users select new userwithcorrecteddate { id = u.id, firstname = u.firstname, lastname = u.lastname, registrationdate = u.registrationdate.value.addhours(-5) }; of course, linq2ef cannot convert " addhours " canonical function. there way this? update: another thought, if timezone offset stored in database column, there way have db perform calculation (date + offset)? linq entities supports sqlfunctions. if know offset number of hours this: var users = u in this.context.users select new userwithcorrecteddate { id = u.id, firstname = u.firstname, lastname = u.lastname, registrationdate = sqlfunctions.dat...
Read more

gdi+ - WxWidgets draw a bitmap with opacity -

-
how can draw wximage, or wxbitmap dc opacity? looks not possible standard dc or wxgraphicscontext. beginlayer/endlayer not yet implemented in wxgraphicscontext have been 1 solution. gdi+ doesn't seem support layers, non-trivial add this. the solution seems to programmatically alter alpha channel pixel-by-pixel? void yourcustomwindow::onpaint( wxpaintevent& event ) { wxpaintdc dc(this); wximage image( width, height ); image.initalpha(); unsigned char* imgdata = img.getdata(); unsigned char* imgalpha = img.getalpha(); // manipulate raw memory buffers populate // them whatever image like. // putting zeros everywhere create // transparent image. // done, not quite... // wxdc can draw wxbitmaps, not wximage, // 1 last step required // wxbitmap bmp( image ); dc.drawbitmap( bmp, 0, 0 ); }
Read more