Sample commands

testdatabase 'testsietske';

> mysql -u root

MariaDB [testsietske]> use testsietske;

MariaDB [testsietske]> show tables;

MariaDB [testsietske]> select * from City;

MariaDB [testsietske]> select * from City where Countrycode = "NLD";

MariaDB [testsietske]> select * from City where District = "Noord-Holland";

MariaDB [testsietske]> select * from City where Countrycode = "NLD" and  population > "100000";


MariaDB [testsietske]> show tables;

MariaDB [testsietske]> select * from Country where Continent = "Europe";

----


SHOW COLUMNS FROM City;

You can use db_name.tbl_name as an alternative to the tbl_name FROM db_name syntax. In other words, these two statements are equivalent:

MariaDB [testsietske]> SHOW COLUMNS FROM mytable FROM mydb;
MariaDB [testsietske]> SHOW COLUMNS FROM mydb.mytable;

MariaDB [testsietske]> select * from City limit 10;

      LIMIT limit OFFSET offset