Adventures with MySQL, Part 2

OK for some bonus points …

Use the SELECT command to find all books whose title begins with W
SELECT *
FROM books
WHERE title LIKE ‘W%’
Use a LIMIT clause on a SELECT command to just list the first two books
SELECT *
FROM books
ORDER BY title LIMIT 2

Use the SELECT command to find all books whose price is less than 10
SELECT *
FROM books
WHERE cost < 10 ORDER BY cost Interesting interface on PHP MyAdmin - there does not appear to be an obvious way to manipulate the database rows etc without using SQL commands, which I presume is deliberate to maintain database integrity. On the downside, unlike coding HTML / CSS (where despite being frowned upon, WYSIWYG editors can be used) this limits database updates to be performed by those willing to invest time learning the commands.

2 thoughts on “Adventures with MySQL, Part 2

  • September 23, 2008 at 11:28 pm
    Permalink

    Hey Ian. I agree PhpMyAdmin is not the most usable software, but it is possible to do most manipulations (deleting, editing, adding rows; creating tables, etc.) just by clicking and filling out forms. It’s not obvious at first glance, but try to click on the small icons around 😉

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.