queries

Useful way to practice SQL queries online in a web browser.

by

http://demo.phpmyadmin.net/STABLE/?pma_username=root. This is an online phpMyAdmin installation that allows you to create databases and practice the administration of the phpMyAdmin system online for free. if you want to practice MySQL queries and do not want the hassle of installing a huge package like SQL server 2012 or MySQl; then this is perfect. MySQL underpins nearly … Read more

using the MySQL SELECT statement to only select certain records.

by

We are taking another look at our database table and we are wanting to only view records that match certain criteria. This is easy with the SELECT statement. mysql> select * from operatingsystems where vendor in ("Microsoft","Mint"); +——+————————+———+———–+ | OsID | Name | Type | vendor | +——+————————+———+———–+ | 1 | Windows 3.0 | Windows … Read more