Essential points in MySQL to refer


————————
MySQL and MySQL AB :
————————
The difference between MySQL and MySQL AB
How MySQL AB operates
MySQL core values
MySQL dual licensing
Organization and structure of the MySQL Reference Manual
The MySQL mailing lists

———————–
MySQL Software :
———————–
Major program components used in MySQL
Major operating system families supported by MySQL
Differences between major MySQL distributions
Available MySQL client interfaces

———————–
Using MySQL Client Programs :
———————–
Invoking command-line client programs
Specifying command-line options
The mysql client
Using mysql interactively
Using script files with mysql
mysql client commands and SQL statements
Using the –safe-updates option
Using mysqlimport
Using mysqldump and reloading the dump
Checking tables with mysqlcheck and myisamchk
Using MySQL Connector/ODBC and MySQL Connector/J

———————–
Data Definition Language :
———————–
General database and table properties
Storage engines and table types
Limits on number and size of database components
Identifier syntax
CREATE DATABASE, DROP DATABASE
CREATE TABLE, ALTER TABLE, DROP TABLE
CREATE INDEX, DROP INDEX; specifying indexes at table-creation time
Creating and using primary keys
Column types
Using AUTO_INCREMENT
String and number formats
Using SHOW and DESCRIBE to review table structures

———————–
SELECT Statements :
———————–
Selecting which columns to display
Restricting a selection using WHERE
Using ORDER BY to sort query results
Limiting a selection using LIMIT
Aggregate functions, GROUP BY, and HAVING
Using DISTINCT to eliminate duplicates
Concatenating SELECT results with UNION

———————–
Basic SQL :
———————–
Using SQL expressions and functions
Using LIKE for pattern matching
Using IN() to test membership
Case sensitivity in string comparisons
Case sensitivity in database, table, column, and function names
Using reserved words as identifiers
NULL values in SELECT statements
Comments in SQL statements

————————
Update Statements :
————————
INSERT and REPLACE
UPDATE
DELETE and TRUNCATE
Handling duplicate key values
Using ORDER BY and LIMIT with UPDATE and DELETE statements

———————–
Joins :
———————–
Writing inner joins using INNER JOIN and the comma (',') operator
Writing outer joins using LEFT JOIN and RIGHT JOIN
Converting subqueries to inner and outer joins
Resolving name clashes using qualifiers and aliases
Multiple-table UPDATE and DELETE statements

———————–
Importing and Exporting Data :
———————–
LOAD DATA INFILE
Using files on the server and the client host
Limiting the columns and rows being imported
SELECT INTO OUTFILE
Privileges needed for LOAD DATA INFILE and SELECT INTO OUTFILE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: