MySQL on Milkshake

Binary Installation on Windows

To install MyODBC on Windows, you should download the appropriate distribution file for your operating system from http://www.mysql.com/downloads/api-myodbc.html, unpack it, and execute the SETUP.EXE file.

milk:~# mysql -u username -p database name 
Enter password:

	CREATE TABLE table name
	(
		column name TYPE, CONDITIONS
	);

For example

	CREATE TABLE contacts
	(
		firstname varchar(30) not null,
		lastname varchar(30) primary key,
		age int(9) not null
	);

	INSERT INTO table name (column name)
	VALUES ("values");

For example

	INSERT INTO contacts (firstname,lastname,age)
	VALUES ("Andrew","Och","27");

	SELECT column name
	FROM table name
	WHERE condition
	AND more conditions
	ORDER BY column name 

For example

        SELECT firstname, lastname, age
        FROM contacts 
        WHERE firstname="andrew"
        AND age >= "20" 
        ORDER BY lastname;

	DELETE FROM table name
	WHERE condition;

For example

	DELETE FROM contacts
	WHERE lastname = "och";
	
FORGETTING the WHERE clause will delete ALL data in database!!!