Big Data Lab notes 02/19/14 - Revision history

Juliana: /* Installing and starting mySQL */

2014-02-25T17:21:50Z

Installing and starting mySQL

← Older revision		Revision as of 17:21, 25 February 2014
Line 24:		Line 24:
	You can also use the shortcut command: mysqlup		You can also use the shortcut command: mysqlup

	To connect to the MySQL server, on a terminal, invoke `/usr/local/mysql/bin/mysql.		To connect to the MySQL server, on a terminal, invoke /usr/local/mysql/bin/mysql.

	You can add aliases to your shell's resource file to make it easier to access commonly used programs such as `mysql' and `mysqladmin' from the command line. I have added the following 2 lines to my .bashrc:		You can add aliases to your shell's resource file to make it easier to access commonly used programs such as `mysql' and `mysqladmin' from the command line. I have added the following 2 lines to my .bashrc:

2014-02-24T20:37:34Z

Installing and starting mySQL

← Older revision		Revision as of 20:37, 24 February 2014
Line 9:		Line 9:
	for example, MacOS: https://dev.mysql.com/doc/refman/5.7/en/macosx-installation.html		for example, MacOS: https://dev.mysql.com/doc/refman/5.7/en/macosx-installation.html
	and for Windows: http://www.mysql.com/why-mysql/windows/		and for Windows: http://www.mysql.com/why-mysql/windows/

			''Several students had trouble installing the MySQL Startup Item, do not install this option!''

	I run mySQL on MacOS, so here's what I did after I installed the system to 'start' the database:		I run mySQL on MacOS, so here's what I did after I installed the system to 'start' the database:

2014-02-19T13:53:28Z

SQL Cheat Sheet

← Older revision		Revision as of 13:53, 19 February 2014
Line 60:		Line 60:

	== SQL Cheat Sheet ==		== SQL Cheat Sheet ==

			<code>

			SELECT AcctNo, Amount
			FROM ATMWithdrawal
			WHERE Amount < 50;

			</code>

			A SQL query is evaluated as follows:
			* First the FROM clause tells us the input tables
			* Second, the WHERE clause is evaluated for all possible combinations from the input tables
			* Third, the SELECT clause tells us which attributes to keep in the query answer

2014-02-19T13:50:51Z

Our running example

2014-02-19T13:50:29Z

Our running example

2014-02-19T13:49:21Z

Our running example

2014-02-19T13:49:07Z

Our running example

2014-02-19T13:48:45Z

Our running example

2014-02-19T13:47:46Z

Our running example

2014-02-19T13:47:24Z