- 论坛徽章:
- 24
|
- [root@django168 tmp]# awk 'BEGIN{FS="(SET|WHERE)";RS=ORS="UPDATE"}NR!=1{print $1"WHERE",$3"SET",$2}NR==1{printf "UPDATE"}' 1.txt
- UPDATE `sakila`.`actor`
- WHERE
- actor_id=1 /* SHORTINT meta=0 nullable=0 is_null=0 */
- first_name='homework_changed' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_name='GUINESS' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_update=1530602107 /* TIMESTAMP(0) meta=0 nullable=0 is_null=0 */
- SET
- actor_id=1 /* SHORTINT meta=0 nullable=0 is_null=0 */
- first_name='PENELOPE' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_name='GUINESS' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_update=1139949273 /* TIMESTAMP(0) meta=0 nullable=0 is_null=0 */
- UPDATE `sakila`.`actor`
- WHERE
- actor_id=2 /* SHORTINT meta=0 nullable=0 is_null=0 */
- first_name='homework_changed' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_name='WAHLBERG' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_update=1530602107 /* TIMESTAMP(0) meta=0 nullable=0 is_null=0 */
- SET
- actor_id=2 /* SHORTINT meta=0 nullable=0 is_null=0 */
- first_name='NICK' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_name='WAHLBERG' /* VARSTRING(135) meta=135 nullable=0 is_null=0 */
- last_update=1139949273 /* TIMESTAMP(0) meta=0 nullable=0 is_null=0 */
复制代码 |
|