Terminology • Database - contains one or more tables • Relation (or table) - contains tuples and attributes • Tuple (or row) - a set of fields which generally represent an “object” like a person or a music track • Attribute (also column or field) - one of possibly many elements of data corresponding to the object represented by the row
Command Line After Control Panel is running... •Macintosh
- /Applications/MAMP/Library/bin/mysql --host=localhost -uroot –p
- Enter "root" when prompted for the password •Windows
- c:\xampp\mysql\bin\mysql.exe -u root –p
- Press enter when prompted for password