Search
ssh login@147.32.84.109
mysql --user=login --password=SECRET --database=login
–host
You can also use the mysql command in batch mode (provided the student table exists). This approach was needed for D-tasks before year 2015.
student
MYSQL_LOGIN_PARAMS=" --user=login --password=SECRET --database=login " MYSQL_PARAMS=" --skip-column-names " MYSQL_SQL_QUERY='SELECT * FROM student;' mysql ${MYSQL_LOGIN_PARAMS} ${MYSQL_PARAMS} --execute="${MYSQL_SQL_QUERY}" \ | while read i ; do echo $i ; done
Download and play with the world.sql database export.
Try the following examples: