mysql -u root -pmysql;
SELECT TABLE_NAME AS "Table Name", table_rows AS "Quant of Rows", ROUND((data_length + index_length)/1024/1024,2) AS "Total Size Mb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema='database_name';
Я хочу создать сценарий оболочки, который выполнит эту команду и вернет результат.
Как я могу запускать эти команды через сценарий оболочки?
mysql -u root -pmysql & lt; & lt; eof SELECT TABLE_NAME AS "Имя таблицы", table_rows AS "Quant of Rows", ROUND ((data_length + index_length) / 1024 / 1024,2) AS "Общий размер Mb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema = 'database_name «; eof
mysql -u root -pmysql & lt; & lt; eof SELECT TABLE_NAME AS "Имя таблицы", table_rows AS "Quant of Rows", ROUND ((data_length + index_length) / 1024 / 1024,2) AS "Общий размер Mb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema = 'database_name «; eof
mysql -u root -pmysql & lt; & lt; eof SELECT TABLE_NAME AS "Имя таблицы", table_rows AS "Quant of Rows", ROUND ((data_length + index_length) / 1024 / 1024,2) AS "Общий размер Mb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema = 'database_name «; eof
mysql -u root -pmysql & lt; & lt; eof SELECT TABLE_NAME AS "Имя таблицы", table_rows AS "Quant of Rows", ROUND ((data_length + index_length) / 1024 / 1024,2) AS "Общий размер Mb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema = 'database_name «; eof