05-执行选项

+-----------+

-e, --execute=name 执行SQL语句并退出

此选项可以直接在MySQL客户端执行SQL语句，而不用连接到MySQL数据库后再执行，对于一些批处理脚本，这种方式尤其方便。下面的例子从客户端直接查询mysql数据库中user表中的User和Host字段：

[zzx@localhost～]$ mysql -u root -p mysql -e "SELECT User, Host FROM user"Enter password:

+------+-----------------------+

| User | Host |

+------+-----------------------+

| z1 | % |

| z2 | % |

| z3 | % |

| root | 127.0.0.1 |

| z1 | 192.168 |

| z1 | 1921168 |

| root | localhost |

| z1 | localhost |

| z10 | localhost |

| z3 | localhost |

| z4 | localhost |

| root | localhost.localdomain |

| z1 | test_hostname |

可以按这种方式连续执行多个SQL语句，用英文分号（;）隔开，下面的例子中连续执行了两个SQL语句：

shell> mysql -u root -p -e "SELECT Name FROM Country WHERE Name LIKE 'AU%';SELECT COUNT(*) FROM City" world

Enter password: **

| Name |

+-----------+

| Australia |

| Austria |

+-----------+

+-----------+

| COUNT(*) |

+-----------+

|4079 |