How do you execute all sql files in a directory?

my $path = 'C:\TestSQL';

my @scripts = `dir /B /s $path`;

foreach my $sqlfile (@scripts) {
   if ( $sqlfile =~ /^(.+\.sql)\s*$/i ) {
       `mysql <db_name> -u <user_name> -p <password> < $sqlfile.sql`;
   }
}

How do you select random 10 rows in MySQL?

SELECT *
FROM <TableName>
ORDER BY RAND()
LIMIT 10;

How do you execute a UNIX command within the MySQL command prompt?

\! <command>
For Example:
\! ls -lrt

How do you find all the tables with specific column names in MySQL?

SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ( 'ColumnA', 'ColumnB' )
AND TABLE_SCHEMA = 'DatabaseName';

How could you login into MySQL database?

mysql -h <DBHOSTNAME> -u <DBUSER> -p <PASSWORD>

How could you select the first N rows in MySQL?

# Retrieve first 5 rows, equivalent to: limit 0,5
SELECT * FROM <TableName> Limit 5;

# Retrieve rows 6-10
SELECT * FROM <TableName> Limit 5,10;