Linux Shell for MySQL

# Shellmysql ************************************** **#! Binbasholnameerik # Old value, that is, the replaced value nwnameerik # new value,

# Shell mysql ************************************* ***#! /Bin/basholname = erik # Old value, that is, the replaced value nwname = erik # new value,

# Shell mysql

****************************************

#! /Bin/bash

Olname = erik # Old value, that is, the value to be replaced

Nwname = erik # new value, that is, the value to be replaced

Domain = @ set-china.net # suffix, here is used to operate the mail, other purposes can not or replace with other

Mysql-u root-p password <

# Start of database operations. Enter the user name and password here. <

# <

Use extmail;

Show tables;

Update alias set goto = REPLACE (goto, '$ olname',' $ nwname $ domain ');

EOF

Exit 0;

****************************************

# When there are few statements, you can use the following:

#! /Bin/bash

Mysql-u root-p password-e "use mysql; select * from user (SQL statement )";

Exit 0;

****************************************