mysql -Nse 'select * from users;' MYDATABASE # mysql -uroot -e "SELECT * FROM users;" MYDATABASE
mysql -Nse 'show tables' MYDATABASE | while read table; do mysql -e "truncate table $table" MYDATABASE; done
select eft.* from ExampleFeatureTable, ExampleOtherTable eot where eot.accountID='1234' AND eft.featureName = 'Button';
insert into targetdatabase.TargetTable ( accountID , FirstName , LastName ) select 'def-<accountID>', (select Name from NameTable where Name = 'John'), 'Smith';