SQL 语句格式化问题

LMUser

# Time: 101014  5:40:54
# User@Host: root[root] @  [192.168.1.1]
# Query_time: 5.146172  Lock_time: 0.000082 Rows_sent: 0  Rows_examined: 0
SET timestamp=1287006054;
select uid from TEMP.loginfo where uid > 10000 AND uid < 1000000;
# Time: 101014  5:42:45
# User@Host: root[root] @  [192.168.1.1]
# Query_time: 1.332682  Lock_time: 0.000059 Rows_sent: 1  Rows_examined: 3
SET timestamp=1287006165;
select
     
    id, uid, degree, start_date, end_date, school_name, major, major_name,
    class_rank, major_descr, create_date, update_date
   
    from tbuser
     
      where uid=4566656
     
     
      order by  degree asc, end_date desc limit 1;
# Time: 101014  5:43:28
# User@Host:root[root] @  [192.168.1.1]
# Query_time: 1.882335  Lock_time: 0.000075 Rows_sent: 0  Rows_examined: 0
SET timestamp=1287006208;
insert into TEMP.tb_loginfo (uid,type,ip,create_date) values (285568,2,'192.168.1.1',now());
.............................. 省略

希望得到的结果:
select uid from TEMP.loginfo where uid > 10000 AND uid < 1000000;
select id, uid, degree, start_date, end_date, school_name, major, major_name, class_rank, major_descr, create_date, update_date from tbuser where uid=4566656 order by  degree asc, end_date desc limit 1;
其中第二句SQL在结果中两行之间没有换行；

springwind426

1. 
   
2. awk -v RS=';' '$1~/select/{gsub(/\n/,"");gsub(/ +/," ");print $0";"}'
   

复制代码

springwind426

1. 
   
2. sed -n '/^select/{:a;/;/!{$!{N;ba}};s/\n//g;s/ \+/ /g;p}'
   

复制代码

LMUser

回复 3# springwind426


哈，很简洁，awk、sed 都给出来了；
感谢！