Querying Data Mysql

Basic commands on mysql command line:

  % mysql

  mysql> USE wbluhm;
  
  mysql> SELECT * FROM books;
 
  mysql> SELECT title, price 
      -> FROM books
      -> ;
  
  mysql> SELECT title, author
      -> FROM books
      -> WHERE topic="Java";
  
  mysql> SELECT title, author, price 
      -> FROM books
      -> WHERE topic="Java"
      -> ORDER BY price; 	  

  mysql> SELECT title, author, price 
      -> FROM books
      -> WHERE topic="Java"
      -> ORDER BY price DESC;

  mysql> USE samp_db;
  
  mysql> SHOW TABLES;
  
  mysql> DESCRIBE president;
  
  mysql> SELECT last_name, first_name, birth
      -> FROM president
      -> WHERE death IS NULL
      -> ORDER BY last_name;
	  
  mysql> DESCRIBE student;
  
  mysql> DESCRIBE absence;
  
  mysql> SELECT student.name, absence.date
      -> FROM student JOIN absence
      -> WHERE student.student_id = absence.student_id;
  
  mysql> exit;
  
  % 

Querying data with .sql scripts:

SQL script example: select_java_books.sql

SELECT title, author, price FROM books 
WHERE  topic="Java" 
ORDER BY price;

  % mysql wbluhm < select_java_books.sql
  
  % mysql -t wbluhm < select_java_books.sql