Sql Data Management

Front 1

Installing mysql on Red Hat

Back 1

1. yum install mysql

2. service mysqld start

3. mysqladmin -uroot password "new password"

Front 2

Installing mysql on Debian/Ubuntu

Back 2

apt-get install mysql

Front 3

Accessing mysql

Back 3

Type mysql -u root -p and type in the password to access mysql.

Front 4

Creating a Database in mysql

Back 4

CREATE DATABASE {database_name};

Front 5

List all Created Databases in mysql

Back 5

SHOW DATABASES;

Front 6

Move Into a Database in mysql

Back 6

USE {database_name};

Front 7

List all Tables Inside of a Database

Back 7

Once inside/moved into database: SHOW TABLES;

Front 8

Create a Table

Back 8

CREATE TABLE {table_name} ( {field1} {field type}, {field2} {field type} );

Front 9

Insert Data Into a Table

Back 9

INSERT INTO {table name} ( {field1}, {field2} ) VALUES ( "field1" , "field2" );

Front 10

Update Data in a Row/Table

Back 10

UPDATE {table name} SET {field}="{VALUE}" WHERE {field}="{VALUE}";

Front 11

Delete Row

Back 11

DELETE FROM {table name} WHERE {field}="{value}"

Front 12

Return All Data From a Table

Back 12

SELECT * FROM {table};

Front 13

Return A Single Column From a Table

Back 13

SELECT {column} FROM {table};

Front 14

Sorting Using Order By

Back 14

SELECT * FROM {table} ORDER BY {field};

To sort in ascending (ASC) order:

SELECT * FROM {table} ORDER BY {field} ASC;

To sort in descending (DESC) order:

SELECT * FROM {table} ORDER BY {field} DESC;

Front 15

Select Statement Using Multiple Fields

Back 15

SELECT * FROM {table} WHERE {field}="value" AND {field}="value";

Front 16

Left Join Statement

Back 16

SELECT * FROM {table1} LEFT JOIN {table2} ON {table1}.{field}={table2}.{field};